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;
}
}
