private void SaveData(string IsDelete) { long lngID = 0; try { if (hfIsUpdate.Value == "N") { lngID = objDB.GerMaxIDNumber("LeavePakMst", "LeavePakID"); } else { lngID = Convert.ToInt64(hfID.Value); } LeavePakMst objLeavePakMst = new LeavePakMst(lngID.ToString(), txtLeavePakName.Text, txtDescription.Text, (chkIsOffdayCounted.Checked == true ? "Y" : "N"), (chkLeavCalcOnJoining.Checked == true ? "Y" : "N"), (chkInActive.Checked == true ? "N" : "Y"), ddlEmploymentType.SelectedValue.ToString(), (chkIsDefault.Checked == true ? "Y" : "N"), Session["USERID"].ToString(), Common.SetDateTime(DateTime.Now.ToString()), "N", ddlMonthFrom.SelectedValue.ToString(), ddlMonthTo.SelectedValue.ToString(), (chkIsNextYear.Checked == true ? "Y" : "N"), strStartDate, strEndDate); objLeaveManager.InsertLeavePakMst(objLeavePakMst, hfIsUpdate.Value, IsDelete, (chkInActive.Checked == true ? "N" : "Y"), grLeaveList); //if (hfIsUpdate.Value == "Y") //{ // LeaveManager objLeaveMgr = new LeaveManager(); // objLeaveMgr.InsertLeaveProfile(ddlEmploymentType.SelectedValue, lngID.ToString(), Session["USERID"].ToString()); //} if ((hfIsUpdate.Value == "N") && (IsDelete == "N")) { lblMsg.Text = "Record Saved Successfully"; } else if ((hfIsUpdate.Value == "Y") && (IsDelete == "N")) { lblMsg.Text = "Record Updated Successfully"; } else if (IsDelete == "Y") { lblMsg.Text = "Record Deleted Successfully"; } this.OpenRecord(); Common.EmptyTextBoxValues(this); this.EntryMode(false); } catch (Exception ex) { lblMsg.Text = ""; throw (ex); } }
public void InsertLeavePakMst(LeavePakMst Lpm, string IsUpdate, string IsDelete, string IsActive, GridView grLeaveList) { SqlCommand[] cmd; cmd = new SqlCommand[grLeaveList.Rows.Count + 3]; cmd[0] = new SqlCommand("proc_Delete_LeavePakDet"); cmd[0].CommandType = CommandType.StoredProcedure; SqlParameter p_LPakIDD = cmd[0].Parameters.Add("LeavePakID", SqlDbType.Decimal); p_LPakIDD.Direction = ParameterDirection.Input; p_LPakIDD.Value = Lpm.LPakID; cmd[1] = new SqlCommand("proc_Insert_LeavePakMst"); cmd[1].CommandType = CommandType.StoredProcedure; SqlParameter p_LPakID = cmd[1].Parameters.Add("LeavePakID", SqlDbType.BigInt); p_LPakID.Direction = ParameterDirection.Input; p_LPakID.Value = Lpm.LPakID; SqlParameter p_LPackName = cmd[1].Parameters.Add("LPackName", SqlDbType.VarChar); p_LPackName.Direction = ParameterDirection.Input; p_LPackName.Value = Lpm.LPackName; SqlParameter p_LPdesc = cmd[1].Parameters.Add("LPdesc", SqlDbType.VarChar); p_LPdesc.Direction = ParameterDirection.Input; p_LPdesc.Value = Lpm.LPdesc; SqlParameter p_IsOffdayCounted = cmd[1].Parameters.Add("IsOffdayCounted", SqlDbType.Char); p_IsOffdayCounted.Direction = ParameterDirection.Input; p_IsOffdayCounted.Value = Lpm.IsOffdayCounted; SqlParameter p_IsLCalOnJoinDate = cmd[1].Parameters.Add("IsLCalOnJoinDate", SqlDbType.Char); p_IsLCalOnJoinDate.Direction = ParameterDirection.Input; p_IsLCalOnJoinDate.Value = Lpm.IsLCalOnJoinDate; SqlParameter p_IsActive = cmd[1].Parameters.Add("IsActive", SqlDbType.Char); p_IsActive.Direction = ParameterDirection.Input; p_IsActive.Value = Lpm.IsActive; SqlParameter p_EmpTypeStatus = cmd[1].Parameters.Add("EmpTypeId", DBNull.Value); p_EmpTypeStatus.Direction = ParameterDirection.Input; p_EmpTypeStatus.IsNullable = true; if (Lpm.EmpTypeStatus != "") { p_EmpTypeStatus.Value = Lpm.EmpTypeStatus; } SqlParameter p_FromMonth = cmd[1].Parameters.Add("FromMonth", DBNull.Value); p_FromMonth.Direction = ParameterDirection.Input; p_FromMonth.IsNullable = true; if (Lpm.FromMonth != "") { p_FromMonth.Value = Lpm.FromMonth; } SqlParameter p_ToMonth = cmd[1].Parameters.Add("ToMonth", DBNull.Value); p_ToMonth.Direction = ParameterDirection.Input; p_ToMonth.IsNullable = true; if (Lpm.ToMonth != "") { p_ToMonth.Value = Lpm.ToMonth; } SqlParameter p_IsNextYear = cmd[1].Parameters.Add("IsNextYear", SqlDbType.Char); p_IsNextYear.Direction = ParameterDirection.Input; p_IsNextYear.Value = Lpm.IsNextYear; SqlParameter p_IsDeleted = cmd[1].Parameters.Add("IsDeleted", SqlDbType.Char); p_IsDeleted.Direction = ParameterDirection.Input; p_IsDeleted.Value = Lpm.IsDeleted; SqlParameter p_ISDefault = cmd[1].Parameters.Add("ISDefault", SqlDbType.Char); p_ISDefault.Direction = ParameterDirection.Input; p_ISDefault.Value = Lpm.ISDefault; SqlParameter p_InsertedDate = cmd[1].Parameters.Add("InsertedDate", SqlDbType.DateTime); p_InsertedDate.Direction = ParameterDirection.Input; p_InsertedDate.Value = Lpm.InsertedDate; SqlParameter p_InsertedBy = cmd[1].Parameters.Add("InsertedBy", SqlDbType.VarChar); p_InsertedBy.Direction = ParameterDirection.Input; p_InsertedBy.Value = Lpm.InsertedBy; SqlParameter p_IsUpdate = cmd[1].Parameters.Add("IsUpdate", SqlDbType.Char); p_IsUpdate.Direction = ParameterDirection.Input; p_IsUpdate.Value = IsUpdate; SqlParameter p_IsDelete = cmd[1].Parameters.Add("IsDelete", SqlDbType.Char); p_IsDelete.Direction = ParameterDirection.Input; p_IsDelete.Value = IsDelete; long i = 2; foreach (GridViewRow tt in grLeaveList.Rows) { string LPakID; string LTypeID; string MaxLAmt; Boolean chkAll = Convert.ToBoolean(((CheckBox)tt.Cells[1].FindControl("chkSelect")).Checked); if (chkAll == true) { HiddenField hfLTypeID = (HiddenField)tt.Cells[2].FindControl("hfLTypeID"); LTypeID = hfLTypeID.Value.ToString(); LPakID = Lpm.LPakID; TextBox txtEntitled = (TextBox)tt.Cells[2].FindControl("txtEntitled"); MaxLAmt = txtEntitled.Text; cmd[i] = InsertLeavePakDet(LPakID, LTypeID, MaxLAmt, Lpm.InsertedBy, Lpm.InsertedDate); } i++; } if (Lpm.LeaveStartPeriod != "" && Lpm.LeaveEndPeriod != "") { cmd[i] = new SqlCommand("proc_Insert_LeavePeriod"); cmd[i].CommandType = CommandType.StoredProcedure; p_LPakID = cmd[i].Parameters.Add("LeavePakID", SqlDbType.BigInt); p_LPakID.Direction = ParameterDirection.Input; p_LPakID.Value = Lpm.LPakID; SqlParameter p_LeaveStartPeriod = cmd[i].Parameters.Add("LeaveStartPeriod", DBNull.Value); p_LeaveStartPeriod.Direction = ParameterDirection.Input; p_LeaveStartPeriod.IsNullable = true; if (Lpm.LeaveStartPeriod != "") { p_LeaveStartPeriod.Value = Lpm.LeaveStartPeriod; } SqlParameter p_LeaveEndPeriod = cmd[i].Parameters.Add("LeaveEndPeriod", DBNull.Value); p_LeaveEndPeriod.Direction = ParameterDirection.Input; p_LeaveEndPeriod.IsNullable = true; if (Lpm.LeaveEndPeriod != "") { p_LeaveEndPeriod.Value = Lpm.LeaveEndPeriod; } } try { objDC.MakeTransaction(cmd); } catch (Exception ex) { throw (ex); } finally { cmd = null; } }