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