public void loadEmployees()
    {
        LoanDSTableAdapters.NoOfEmployeesTableAdapter noOfEmployees = new LoanDSTableAdapters.NoOfEmployeesTableAdapter();
        LoanDS.NoOfEmployeesDataTable tblnoOfEmployees = noOfEmployees.GetNoOfEmployees(MySessionManager.AppID, MySessionManager.ClientID);

        if (tblnoOfEmployees.Rows.Count > 0)
        {
            txtCasual.Value = tblnoOfEmployees[0].datCasual.ToString();
            txtManagement.Value = tblnoOfEmployees[0].datManagement.ToString();
            txtSkilled .Value = tblnoOfEmployees[0].datSkilled .ToString();
            txtunskilled.Value = tblnoOfEmployees[0].datUnskilled.ToString();
            txtTotal.Value = tblnoOfEmployees[0].datTotal.ToString();                   
        }
    }
    public void loadEmployees()
    {
        LoanDSTableAdapters.NoOfEmployeesTableAdapter noOfEmployees = new LoanDSTableAdapters.NoOfEmployeesTableAdapter();
        LoanDS.NoOfEmployeesDataTable tblnoOfEmployees = noOfEmployees.GetNoOfEmployees(MySessionManager.AppID, MySessionManager.ClientID);

        if (tblnoOfEmployees.Rows.Count > 0)
        {
            txtCasual.Value     = tblnoOfEmployees[0].datCasual.ToString();
            txtManagement.Value = tblnoOfEmployees[0].datManagement.ToString();
            txtSkilled.Value    = tblnoOfEmployees[0].datSkilled.ToString();
            txtunskilled.Value  = tblnoOfEmployees[0].datUnskilled.ToString();
            txtTotal.Value      = tblnoOfEmployees[0].datTotal.ToString();
        }
    }
 protected void btnSave_Click(object sender, EventArgs e)
 {
     if (Page.IsValid)
     {
         LoanDSTableAdapters.NoOfEmployeesTableAdapter noOfEmployees = new LoanDSTableAdapters.NoOfEmployeesTableAdapter();
         noOfEmployees.InsertNoOfEmployees(MySessionManager.ClientID,
                                            MySessionManager.AppID,
                                            Convert.ToInt32(txtManagement.Value.Trim()),
                                            Convert.ToInt32(txtSkilled.Value.Trim()),
                                            Convert.ToInt32(txtunskilled.Value.Trim()),
                                            Convert.ToInt32(txtCasual.Value.Trim()),
                                            Convert.ToInt32(txtTotal.Value.Trim()),
                                            MySessionManager.CurrentUser.UserID
                                            );
     }
 }
 protected void btnSave_Click(object sender, EventArgs e)
 {
     if (Page.IsValid)
     {
         LoanDSTableAdapters.NoOfEmployeesTableAdapter noOfEmployees = new LoanDSTableAdapters.NoOfEmployeesTableAdapter();
         noOfEmployees.InsertNoOfEmployees(MySessionManager.ClientID,
                                           MySessionManager.AppID,
                                           Convert.ToInt32(txtManagement.Value.Trim()),
                                           Convert.ToInt32(txtSkilled.Value.Trim()),
                                           Convert.ToInt32(txtunskilled.Value.Trim()),
                                           Convert.ToInt32(txtCasual.Value.Trim()),
                                           Convert.ToInt32(txtTotal.Value.Trim()),
                                           MySessionManager.CurrentUser.UserID
                                           );
     }
 }