public void BindComboBoxgetSalesmanName()
        {
            DataTable dt = SalesManDetailsController.getSalesmanDetails();

            Utility.BindComboBoxEmptyDataSelect(cmbSalesmanName, dt, "SalesmanId", "SalesmanName");
        }
Exemple #2
0
        public void BindSalesmanGrid()
        {
            try
            {
                grdSalesmanDetails.DataSource = null;
                DataTable lstsalesmanDetails = SalesManDetailsController.getSalesmanDetails();
                grdSalesmanDetails.AutoGenerateColumns = false;
                grdSalesmanDetails.ColumnHeadersDefaultCellStyle.BackColor = Color.Black;
                grdSalesmanDetails.ColumnHeadersDefaultCellStyle.ForeColor = Color.White;
                grdSalesmanDetails.Font = new Font("Tahoma", 11);

                grdSalesmanDetails.EnableHeadersVisualStyles = false;

                grdSalesmanDetails.ColumnCount = 7;
                if (Utility.Langn == "English")
                {
                    grdSalesmanDetails.Columns[0].Name             = "SalesmanId";
                    grdSalesmanDetails.Columns[0].HeaderText       = "SalesmanId";
                    grdSalesmanDetails.Columns[0].DataPropertyName = "SalesmanId";
                    grdSalesmanDetails.Columns[0].Visible          = false;

                    grdSalesmanDetails.Columns[1].Name             = "SalesmanName";
                    grdSalesmanDetails.Columns[1].HeaderText       = "Salesman Name";
                    grdSalesmanDetails.Columns[1].DataPropertyName = "SalesmanName";

                    grdSalesmanDetails.Columns[2].Name             = "Address";
                    grdSalesmanDetails.Columns[2].HeaderText       = "Address";
                    grdSalesmanDetails.Columns[2].DataPropertyName = "Address";

                    grdSalesmanDetails.Columns[3].Name             = "MobileNo";
                    grdSalesmanDetails.Columns[3].HeaderText       = "MobileNo";
                    grdSalesmanDetails.Columns[3].DataPropertyName = "MobileNo";

                    grdSalesmanDetails.Columns[4].Name             = "GenderId";
                    grdSalesmanDetails.Columns[4].HeaderText       = "Gender";
                    grdSalesmanDetails.Columns[4].DataPropertyName = "GenderId";

                    grdSalesmanDetails.Columns[5].Name                    = "DOB";
                    grdSalesmanDetails.Columns[5].HeaderText              = "DOB";
                    grdSalesmanDetails.Columns[5].DataPropertyName        = "DOB";
                    grdSalesmanDetails.Columns[5].DefaultCellStyle.Format = "dd-MM-yyyy";

                    grdSalesmanDetails.Columns[6].Name             = "EmailId";
                    grdSalesmanDetails.Columns[6].HeaderText       = "EmailId";
                    grdSalesmanDetails.Columns[6].DataPropertyName = "EmailId";
                }
                else
                {
                    grdSalesmanDetails.Columns[0].Name             = "SalesmanId";
                    grdSalesmanDetails.Columns[0].HeaderText       = "SalesmanId";
                    grdSalesmanDetails.Columns[0].DataPropertyName = "SalesmanId";
                    grdSalesmanDetails.Columns[0].Visible          = false;

                    grdSalesmanDetails.Columns[1].Name             = "SalesmanName";
                    grdSalesmanDetails.Columns[1].HeaderText       = "ग्राहकाचे नाव";
                    grdSalesmanDetails.Columns[1].DataPropertyName = "SalesmanName";

                    grdSalesmanDetails.Columns[2].Name             = "Address";
                    grdSalesmanDetails.Columns[2].HeaderText       = "पत्ता";
                    grdSalesmanDetails.Columns[2].DataPropertyName = "Address";

                    grdSalesmanDetails.Columns[3].Name             = "customerMobileNo";
                    grdSalesmanDetails.Columns[3].HeaderText       = "मोबाईल क्र.";
                    grdSalesmanDetails.Columns[3].DataPropertyName = "customerMobileNo";

                    grdSalesmanDetails.Columns[4].Name             = "GenderId";
                    grdSalesmanDetails.Columns[4].HeaderText       = "लिंग";
                    grdSalesmanDetails.Columns[4].DataPropertyName = "GenderId";

                    grdSalesmanDetails.Columns[5].Name                    = "DOB";
                    grdSalesmanDetails.Columns[5].HeaderText              = "जन्मदिनांक";
                    grdSalesmanDetails.Columns[5].DataPropertyName        = "DOB";
                    grdSalesmanDetails.Columns[5].DefaultCellStyle.Format = "dd-MM-yyyy";

                    grdSalesmanDetails.Columns[6].Name             = "EmailId";
                    grdSalesmanDetails.Columns[6].HeaderText       = "ई-मेल";
                    grdSalesmanDetails.Columns[6].DataPropertyName = "EmailId";
                }
                grdSalesmanDetails.DataSource = lstsalesmanDetails;
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message);
            }
        }