internal DataTable DL_SaveTransMaster(PL_LeaveTrasaction plobj)
{
try
{
con = Connection.SetConnection();
cmd = new SqlCommand("SPLeaveTransaction", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@Ind", plobj.Ind);
cmd.Parameters.AddWithValue("@CITYCODE", plobj.CityCode);
cmd.Parameters.AddWithValue("@empno", plobj.Empno);
cmd.Parameters.AddWithValue("@LvCd", plobj.LvCd);
cmd.Parameters.AddWithValue("@NoOfLv", plobj.NoOfLv);
cmd.Parameters.AddWithValue("@DateFrom", plobj.DateFrom);
cmd.Parameters.AddWithValue("@DateTo", plobj.DateTo);
cmd.Parameters.AddWithValue("@month", plobj.Month);
cmd.Parameters.AddWithValue("@Upd_Ind", plobj.Upd_Ind);
cmd.Parameters.AddWithValue("@Narr", plobj.Narr);
da = new SqlDataAdapter(cmd);
dt = new DataTable();
da.Fill(dt);
return(dt);
}
catch { return(dt); }
finally
{
con.Close();
con.Dispose();
}
}
public DataTable UpdateData(PL_LeaveTrasaction plobj)
{
DL_LeaveTrasaction objdl = new DL_LeaveTrasaction();
DataTable dt = new DataTable();
if (plobj.Ind == 0)
{
return(dt);
}
else
{
dt = objdl.DL_SaveTransMaster(plobj);
return(dt);
}
}