public void Doctor_LeaveApplication(int doctorId, string leaveFromDate, string leaveFromTime,
string leaveToDate, string leaveToTime, string leaveReason)
{
Doctor_LeaveApplicationBO objDoctor_LeaveApplicationBO = new Doctor_LeaveApplicationBO();
objDoctor_LeaveApplicationBO.doctorId = doctorId;
objDoctor_LeaveApplicationBO.leaveFromDate = leaveFromDate;
objDoctor_LeaveApplicationBO.leaveFromTime = leaveFromTime;
objDoctor_LeaveApplicationBO.leaveToDate = leaveToDate;
objDoctor_LeaveApplicationBO.leaveToTime = leaveToTime;
objDoctor_LeaveApplicationBO.leaveReason = leaveReason;
Doctor_LeaveApplicationDL objDoctor_LeaveApplicationDL = new Doctor_LeaveApplicationDL();
objDoctor_LeaveApplicationDL.Doctor_LeaveApplication(objDoctor_LeaveApplicationBO);
}
public void Doctor_LeaveApplication(Doctor_LeaveApplicationBO objDoctor_LeaveApplicationBO)
{
SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["ConnectionString"].ToString());
SqlCommand cmd = new SqlCommand("sp_Doctor_LeaveApplication", conn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@doctorId", objDoctor_LeaveApplicationBO.doctorId);
cmd.Parameters.Add("@leaveFromDate", objDoctor_LeaveApplicationBO.leaveFromDate);
cmd.Parameters.Add("@leaveFromTime", objDoctor_LeaveApplicationBO.leaveFromTime);
cmd.Parameters.Add("@leaveToDate", objDoctor_LeaveApplicationBO.leaveToDate);
cmd.Parameters.Add("@leaveToTime", objDoctor_LeaveApplicationBO.leaveToTime);
cmd.Parameters.Add("@leaveReason", objDoctor_LeaveApplicationBO.leaveReason);
conn.Open();
cmd.ExecuteNonQuery();
conn.Close();
}
public void Doctor_LeaveApplication(Doctor_LeaveApplicationBO objDoctor_LeaveApplicationBO)
{
SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["ConnectionString"].ToString());
SqlCommand cmd = new SqlCommand("sp_Doctor_LeaveApplication", conn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@doctorId", objDoctor_LeaveApplicationBO.doctorId);
cmd.Parameters.Add("@leaveFromDate", objDoctor_LeaveApplicationBO.leaveFromDate);
cmd.Parameters.Add("@leaveFromTime", objDoctor_LeaveApplicationBO.leaveFromTime);
cmd.Parameters.Add("@leaveToDate", objDoctor_LeaveApplicationBO.leaveToDate);
cmd.Parameters.Add("@leaveToTime", objDoctor_LeaveApplicationBO.leaveToTime);
cmd.Parameters.Add("@leaveReason", objDoctor_LeaveApplicationBO.leaveReason);
conn.Open();
cmd.ExecuteNonQuery();
conn.Close();
}
public void Doctor_LeaveApplication(int doctorId, string leaveFromDate, string leaveFromTime,
string leaveToDate, string leaveToTime, string leaveReason)
{
Doctor_LeaveApplicationBO objDoctor_LeaveApplicationBO = new Doctor_LeaveApplicationBO();
objDoctor_LeaveApplicationBO.doctorId = doctorId;
objDoctor_LeaveApplicationBO.leaveFromDate = leaveFromDate;
objDoctor_LeaveApplicationBO.leaveFromTime = leaveFromTime;
objDoctor_LeaveApplicationBO.leaveToDate = leaveToDate;
objDoctor_LeaveApplicationBO.leaveToTime = leaveToTime;
objDoctor_LeaveApplicationBO.leaveReason = leaveReason;
Doctor_LeaveApplicationDL objDoctor_LeaveApplicationDL = new Doctor_LeaveApplicationDL();
objDoctor_LeaveApplicationDL.Doctor_LeaveApplication(objDoctor_LeaveApplicationBO);
}
