public static int LeaveApplicationDetails_Save(Entity.LeaveManagement.LeaveApplicationDetails leaveApplicationDetails)
{
int retValue = 0;
using (SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["constr"].ToString()))
{
using (SqlCommand cmd = new SqlCommand())
{
cmd.Connection = con;
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "usp_HR_LeaveApplicationDetails_Save";
cmd.Parameters.AddWithValue("@LeaveApplicationDetailId", leaveApplicationDetails.LeaveApplicationDetailId);
cmd.Parameters.AddWithValue("@LeaveApplicationId", leaveApplicationDetails.LeaveApplicationId);
cmd.Parameters.AddWithValue("@LeaveDate", leaveApplicationDetails.LeaveDate);
cmd.Parameters.AddWithValue("@AppliedForDay", leaveApplicationDetails.AppliedForDay);
if (con.State == ConnectionState.Closed)
{
con.Open();
}
retValue = cmd.ExecuteNonQuery();
con.Close();
}
}
return(retValue);
}
private int LeaveApplicationDetails_Save(int leaveApplicationId, DateTime leaveDate, decimal appliedForDay)
{
Entity.LeaveManagement.LeaveApplicationDetails leaveApplicationDetails = new Entity.LeaveManagement.LeaveApplicationDetails();
Business.LeaveManagement.LeaveApplication objLeaveApplicationMaster = new Business.LeaveManagement.LeaveApplication();
leaveApplicationDetails.LeaveApplicationDetailId = 0;
leaveApplicationDetails.LeaveApplicationId = leaveApplicationId;
leaveApplicationDetails.LeaveDate = leaveDate;
leaveApplicationDetails.AppliedForDay = appliedForDay;
int response = objLeaveApplicationMaster.LeaveApplicationDetails_Save(leaveApplicationDetails);
return(response);
}
public static DataTable LeaveApplicationDetails_GetAll(Entity.LeaveManagement.LeaveApplicationDetails leaveApplicationDetails)
{
using (DataTable dt = new DataTable())
{
using (SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["constr"].ToString()))
{
using (SqlCommand cmd = new SqlCommand())
{
cmd.Connection = con;
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "usp_HR_LeaveApplicationDetails_GetAll";
if (leaveApplicationDetails.LeaveApplicationId == 0)
{
cmd.Parameters.AddWithValue("@LeaveApplicationId", DBNull.Value);
}
else
{
cmd.Parameters.AddWithValue("@LeaveApplicationId", leaveApplicationDetails.LeaveApplicationId);
}
if (leaveApplicationDetails.LeaveApplicationDetailId == 0)
{
cmd.Parameters.AddWithValue("@LeaveApplicationDetailId", DBNull.Value);
}
else
{
cmd.Parameters.AddWithValue("@LeaveApplicationDetailId", leaveApplicationDetails.LeaveApplicationDetailId);
}
using (SqlDataAdapter da = new SqlDataAdapter(cmd))
{
da.Fill(dt);
}
con.Close();
}
}
return(dt);
}
}
public DataTable LeaveApplicationDetails_GetAll(Entity.LeaveManagement.LeaveApplicationDetails leaveApplicationDetails)
{
return(DataAccess.LeaveManagement.LeaveApplication.LeaveApplicationDetails_GetAll(leaveApplicationDetails));
}
public int LeaveApplicationDetails_Save(Entity.LeaveManagement.LeaveApplicationDetails leaveApplicationDetails)
{
return(DataAccess.LeaveManagement.LeaveApplication.LeaveApplicationDetails_Save(leaveApplicationDetails));
}
