protected void grdMain_RowCommand(object sender, GridViewCommandEventArgs e) { string strMsg = string.Empty; if (e.CommandName == "cmdEdit") { Response.Redirect("EmployeeSalry.aspx?EmpSal=" + e.CommandArgument, true); } else if (e.CommandName == "cmdstatus") { EmployeeSalaryDAL objemp = new EmployeeSalaryDAL(); int EmpSal_ID = 0; bool bStatus = false; string[] strStatus = Convert.ToString(e.CommandArgument).Split(new char[] { '_' }); if (strStatus.Length > 1) { EmpSal_ID = Convert.ToInt32(strStatus[0]); if (Convert.ToBoolean(strStatus[1]) == true) { bStatus = false; } else { bStatus = true; } Int32 value = objemp.UpdateStatus(EmpSal_ID, bStatus); if (value > 0) { this.BindGrid(); ShowMessage("Status updated successfully."); } else { ShowMessageErr("Status not updated!"); } } } else if (e.CommandName == "cmddelete") { EmployeeSalaryDAL objsal = new EmployeeSalaryDAL(); Int32 intValue = objsal.Delete(Convert.ToInt32(e.CommandArgument)); if (intValue > 0) { this.BindGrid(); ShowMessage("Record deleted successfully."); } else { ShowMessage("Record not deleted!"); } } }
private void BindEmployees() { EmployeeSalaryDAL objemp = new EmployeeSalaryDAL(); var lst = objemp.FetchEmployeeName(); ddlEmpName.DataSource = lst; ddlEmpName.DataTextField = "Acnt_Name"; ddlEmpName.DataValueField = "Acnt_Idno"; ddlEmpName.DataBind(); ddlEmpName.Items.Insert(0, new ListItem("< Choose emp name >", "0")); }
private void BindGrid() { EmployeeSalaryDAL objSalry = new EmployeeSalaryDAL(); string strEmpName = txtEmpName.Text.Trim(); var lstGridData = objSalry.SelectForSearch(strEmpName); if (lstGridData != null && lstGridData.Count > 0) { DataTable dt = new DataTable(); dt.Columns.Add("EmpSal_ID", typeof(string)); dt.Columns.Add("Acnt_Name", typeof(string)); dt.Columns.Add("EmpSal_Salary", typeof(string)); dt.Columns.Add("EmpSal_Year", typeof(string)); dt.Columns.Add("EmpSal_Status", typeof(string)); for (int i = 0; i < lstGridData.Count; i++) { DataRow dr = dt.NewRow(); dr["EmpSal_ID"] = Convert.ToString(i + 1); dr["Acnt_Name"] = Convert.ToString(DataBinder.Eval(lstGridData[i], "Acnt_Name")); dr["EmpSal_Salary"] = Convert.ToString(DataBinder.Eval(lstGridData[i], "EmpSal_Salary")); dr["EmpSal_Year"] = Convert.ToString(DataBinder.Eval(lstGridData[i], "EmpSal_Year")); dr["EmpSal_Status"] = Convert.ToString(DataBinder.Eval(lstGridData[i], "EmpSal_Status")); dt.Rows.Add(dr); } if (dt != null && dt.Rows.Count > 0) { ViewState["Dt"] = dt; } // grdMain.DataSource = lstGridData; grdMain.DataBind(); lblTotalRecord.Text = "T. Record(s): " + lstGridData.Count; int startRowOnPage = (grdMain.PageIndex * grdMain.PageSize) + 1; int lastRowOnPage = startRowOnPage + grdMain.Rows.Count - 1; lblcontant.Text = "Showing " + startRowOnPage.ToString() + " - " + lastRowOnPage.ToString() + " of " + lstGridData.Count.ToString(); lblcontant.Visible = true; imgBtnExcel.Visible = true; divpaging.Visible = true; } else { grdMain.DataSource = null; grdMain.DataBind(); lblTotalRecord.Text = "T. Record(s): 0 "; imgBtnExcel.Visible = false; lblcontant.Visible = false; divpaging.Visible = false; } }
private void PopulateEmpDetl(Int32 EmpID) { EmployeeSalaryDAL objEmpSal = new EmployeeSalaryDAL(); var vartblEmpSal = objEmpSal.SelectEmployeeDetailAtEditTime(EmpID); if (vartblEmpSal != null) { ddlEmpName.SelectedValue = Convert.ToString(DataBinder.Eval(vartblEmpSal[0], "EmpSal_EmpID")); txtSalary.Text = Convert.ToString(DataBinder.Eval(vartblEmpSal[0], "EmpSal_Salary")); ddlMonth.SelectedValue = Convert.ToString(DataBinder.Eval(vartblEmpSal[0], "EmpSal_Month")); ddlYear.SelectedValue = Convert.ToString(DataBinder.Eval(vartblEmpSal[0], "EmpSal_Year")); chkStatus.Checked = Convert.ToBoolean(DataBinder.Eval(vartblEmpSal[0], "EmpSal_Status")); } }
protected void lnkbtnSave_OnClick(object sender, EventArgs e) { EmployeeSalaryDAL Empobj = new EmployeeSalaryDAL(); Int64 value = 0; string Date = DateTime.Now.Date.ToString("dd-MM-yyyy"); DateTime DateAdd = Convert.ToDateTime(ApplicationFunction.mmddyyyy(Date)); using (TransactionScope dbTran = new TransactionScope(TransactionScopeOption.Required)) { try { if (string.IsNullOrEmpty(hdnQry.Value) == true) { value = Empobj.InsertEmployeeDetl(Convert.ToInt64(ddlEmpName.SelectedValue), Convert.ToDouble(txtSalary.Text.Trim()), Convert.ToInt32(ddlMonth.SelectedValue), Convert.ToInt32(ddlYear.SelectedValue), chkStatus.Checked, DateAdd); } else { value = Empobj.UpdateEmployeeDetl(Convert.ToInt64(hdnQry.Value), Convert.ToInt64(ddlEmpName.SelectedValue), Convert.ToDouble(txtSalary.Text.Trim()), Convert.ToInt32(ddlMonth.SelectedValue), Convert.ToInt32(ddlYear.SelectedValue), chkStatus.Checked, DateAdd); } if (value > 0) { if (string.IsNullOrEmpty(hdnQry.Value) == true) { ShowMessage("Records successfully inserted."); } else { lnkbtnNew.Visible = false; ShowMessage("Records successfully updated."); } dbTran.Complete(); this.ClearAllData(); } else { if (string.IsNullOrEmpty(hdnQry.Value) == true) { ShowMessageErr("Records not inserted!"); } else { ShowMessageErr("Records not updated!"); } dbTran.Dispose(); } } catch (Exception ex) { if (string.IsNullOrEmpty(hdnQry.Value) == true) { ShowMessageErr("Error in records inserting!"); } else { ShowMessageErr("Error in Records updating!"); } } } }