public ShippingDoc( IdentityObject ident)
 {
     InitializeComponent();
     base.SaveIdent(ident);
     label_UserName.Text = base.ident.UserName.Trim();
     label_UserID.Text = base.ident.UserID.Trim();
 }

        public view_training_progress_and_report(IdentityObject ident)
        {
            InitializeComponent();

            base.SaveIdent(ident);
            base.DisplayIdent(ident);
        }

 public Training_Evaluation_Template(IdentityObject ident)
 {
     InitializeComponent();
     label_SubName.Text = "Training and Evaluation";
     base.SaveIdent(ident);
     base.DisplayIdent(ident);
 }

 public Change(IdentityObject _ident, string _cmd, string tablename, string _docNum,string _docType, string type)
 {
     InitializeComponent();
     base.SaveIdent(_ident);
     base.DisplayIdent(_ident);
     label_UserName.Text = base.ident.UserName.Trim();
     label_UserID.Text = base.ident.UserID.Trim();
     textBox_Cmd.Text = _cmd;
     textBox_TableName.Text = tablename;
     textBox_DocNum.Text = _docNum;
     textBox_DocType.Text = _docType;
     textBox_DataStrings.Visible = true;
     //LoadSelectionInfo(_docType, _docNum);
     LoadBBasicDocInfo();
       //  button_GetDocument_Click(this, null);
     if (type == "view")
     {
         button_approve.Visible = false;
     }
     else if (type == "approve")
     {
         button_approve.Visible = true;
     }
     button_GetDoc_Click(this, null);
 }

 public DisplayDelivery(IdentityObject _ident)
 {
     InitializeComponent();
     ident = _ident;
     LoadDelivery();
     //    comboBox1.SelectedIndex = 0;
 }

 public SalesAndMarketingMain(IdentityObject ident)
 {
     InitializeComponent();
     base.SaveIdent(ident);
     base.DisplayIdent(ident);
        label_SubName.Text = "Sales And Marketing";
 }

 public HR_Main()
 {
     InitializeComponent();
     IdentityObject ident = new IdentityObject();
     base.SaveIdent(ident);
     base.DisplayIdent(ident);
 }

 public DisplayEmployee(IdentityObject _ident)
 {
     InitializeComponent();
     base.SaveIdent(_ident);
     LoadEmployees();
     comboBox1.SelectedIndex = 1;
 }

        public AddServiceOrderItem(IdentityObject _ident,  String _ServiceProductType ,String _DocNUM, String _DocType, String _ProductID, String _Quantity , String _Comment)
        {
            InitializeComponent();
            base.SaveIdent( _ident);
            //FillCustomerList();
            panel1.Visible = true;

            DataTable Services = Utilities.DataBaseUtility.GetTable("Select ServiceProductType, ServiceProductDescription from Service_Type");
            ServiceProductTypeCombobox.DataSource = Services;
            ServiceProductTypeCombobox.DisplayMember = "ServiceProductDescription";
            ServiceProductTypeCombobox.ValueMember = "ServiceProductType";

            CommentTxt.Text = _Comment;
            ORDER_DOCNUMTXT.Text = _DocNUM;
            ORDERDOCTYPETXT.Text = _DocType;
            ProductIDTXT.Text = _ProductID;
            QuanitytTXT.Text = _Quantity;

             //If service product is passed then it is update else it is add item
            if (!String.IsNullOrEmpty(_ServiceProductType) )
            { ServiceProductTypeCombobox.SelectedValue = _ServiceProductType;
            button2.Text = "Update ServiceOrder";
            }
               // _ServiceTypes = Utilities.DataBaseUtility.GetList("select DocNum, DocType, EmployeeID, ServiceProductType, ServiceProductDescription, Rate, Standard_Hrs, GrossPrice, DateCreated, DateModified from Service_Type  " + ProdTypeSql );
            //FillTextBoxes();
        }

 public DisplayServiceTypes(IdentityObject _ident)
 {
     InitializeComponent();
     base.SaveIdent( _ident);
     base.DisplayIdent(ident);
     //FillCustomerList();
 }

 public LogSrvcReq(IdentityObject ident)
 {
     InitializeComponent();
     base.SaveIdent(ident);
     base.DisplayIdent(ident);
     label_SubName.Text="SALES S&M > LIST OF SERVICES";
 }

        public ConfirmOrder(IdentityObject ident,int promoProdId,String id,String price)
        {
            productOrBundle = id;
            InitializeComponent();
               this. price=Convert.ToDouble(price);
            base.SaveIdent(ident);
            base.DisplayIdent(ident);
            this.promoProdId = promoProdId;
            label_SubName.Text = "Pre Sales";
             //   MessageBox.Show("price-----------------------"+price);
            label7.Text += price;
            dataGridView2.DataSource=   Utilities.DataBaseUtility.GetTable("select EmplID,FirstName,LastName from Employees");
            dataGridView3.DataSource = Utilities.DataBaseUtility.GetTable("select CustomerID,FirstName,LastName from Customers");

            if (id.Equals("bundle"))
            {
                dataGridView1.DataSource = Utilities.DataBaseUtility.GetTable("select * from Bundle_Details where PromoCode=" + promoProdId);
                label6.Text = "Confirm Promo Bundle Details";
            }
            else
            {
               //     MessageBox.Show("Confirm order"+promoProdId);
                dataGridView1.DataSource = Utilities.DataBaseUtility.GetTable("select * from Products where ProductID=" + promoProdId);
                label6.Text = "Confirm Product Details";
            }
            //MessageBox.Show("Confirm order");
        }

        public AddServiceOrder(IdentityObject ident, String _Orderid, string Customerinp)
        {
            InitializeComponent();
            base.SaveIdent(ident);
            base.DisplayIdent(ident);
            ident_local = ident;
            label_SubName.Text = "Sales_sm";
            Doctype.Text ="22";
            CustomerID.Text = Customerinp;

            if (_Orderid == "")
            {
                _NewOrder = Utilities.DataBaseUtility.GetList("select max(Docnum)+1 from Service_Order_Details" );
            FillTextBoxes("New");
            FormMode = "New";
            }
            else {
              _NewOrder = Utilities.DataBaseUtility.GetList("select * from Service_Order where Docnum =" +_Orderid );
            FillTextBoxes("Update");
            FormMode = "Update";
            }

            bind_data("Service_Order_Details",  DocNum.Text );

            ResultString = Customerinp;
        }

 public static Boolean Authorize(IdentityObject _ident, string _resource)
 {
     bool _authorized = false;
     if (_ident.Role  == "employee")
         _authorized = true;
     return _authorized;
 }

 public DisplayInventoryItem(IdentityObject in_ident)
 {
     InitializeComponent();
     _ident = in_ident;
     base.ident = in_ident;
     label_Ident.Text = _ident.UserID.ToString() + " :  " + _ident.UserName;
 }

 public static string Execute(string _sqlCommand, IdentityObject ident)
 {
     string _message = "no errors";
     OleDbConnection conn;
     conn = GetConnectionObject();
     try
     {
         //if (ident.ActionLevel < 5)
         //{
         //    _message = "command requires a higher permission level than " + ident.ActionLevel + " by user : " + ident.UserName;
         //    //     return _message;
         //}
         OleDbCommand _command = new OleDbCommand(_sqlCommand, conn);
         conn.Open();
         int _count = _command.ExecuteNonQuery();
         if (_count < 1)
         {
             _message = "could not execute  " + _sqlCommand;
             return _message;
         }
         else return "no errors";
     }
     catch (Exception e)
     {
         return (e.ToString());
     }
     finally
     {
         conn.Close();
     }
 }

 public DisplaySelectedObject(IdentityObject ident)
 {
     InitializeComponent();
       //  textBox_TableName.Text = "Sales_sm";
     base.SaveIdent(ident);
     base.DisplayIdent(ident);
 }

 public Documents_Main(IdentityObject ident)
 {
     InitializeComponent();
     base.SaveIdent(ident);
     base.DisplayIdent(ident);
     Utilities.Documents.ListObjects pds = new Utilities.Documents.ListObjects(base.ident); pds.Show();
 }

 public ListObjects(IdentityObject ident)
 {
     InitializeComponent();
     base.SaveIdent(ident);
     base.DisplayIdent(ident);
     label_SubName.Text="Sales_sm";
 }

        public CreatePurchaseOrder(IdentityObject ident,Purchases.InventoryItem item)
        {
            InitializeComponent();
            label_SubName.Text = "New Purchase Order";
            _ident = ident;
            textBox_Role.Text = _ident.Role;
            if (_ident == null) _ident = new IdentityObject("111", "Johnson", "clerk", 1, 2);
            textBox_Employee.Text = _ident.UserID;
            textBox_AuthLevel.Text = _ident.ActionLevel.ToString();
            FillSupplier();
            comboBox1.SelectedIndex = item.Supplier;
            textBox_Supplier.Text = item.Supplier.ToString();
            comboBox1_SelectedIndexChanged(this, null);
            _productID = item.ProductID.ToString();
            //textBox_Comment.Text = "Product No:" + _productID + "(" + item.ProductName  +")";
            textBox_OnHand.Text = item.OnHand.ToString();
            textBox_MinQuantity.Text = item.MinQuantity.ToString();
            textBox_Quantity.Text = (item.MinQuantity - item.OnHand).ToString();
            textBox_Price.Text = item.Cost.ToString();
            textBox_ProductID.Text = item.InvID.ToString();
            textBox_PO_ID2.Text = item.ProductName.ToString();
            button_Preview.Visible = false;
            button_DataToText.Visible = false;
            button_ConvertToSql.Visible = false;

            NewPurchaseOrder(_ident);
        }