public void Common_AddReminder(int empId, string reminderTitle, string reminderDetails, string reminderDate)
{
AddReminderBO objAddReminderBO = new AddReminderBO();
objAddReminderBO.empId = empId;
objAddReminderBO.reminderTitle = reminderTitle;
objAddReminderBO.reminderDetails = reminderDetails;
objAddReminderBO.reminderDate = reminderDate;
AddReminderDL objAddReminderDL = new AddReminderDL();
objAddReminderDL.AddReminder(objAddReminderBO);
}
public void Common_AddReminder(int empId, string reminderTitle, string reminderDetails, string reminderDate)
{
AddReminderBO objAddReminderBO = new AddReminderBO();
objAddReminderBO.empId = empId;
objAddReminderBO.reminderTitle = reminderTitle;
objAddReminderBO.reminderDetails = reminderDetails;
objAddReminderBO.reminderDate = reminderDate;
AddReminderDL objAddReminderDL = new AddReminderDL();
objAddReminderDL.AddReminder(objAddReminderBO);
}
public void UpdateReminder(AddReminderBO objUpdateReminderBO)
{
SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["ConnectionString"].ToString());
SqlCommand cmd = new SqlCommand("spUpdateReminder", conn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@empId", objUpdateReminderBO.empId);
cmd.Parameters.Add("@reminderId", objUpdateReminderBO.reminderId);
cmd.Parameters.Add("@reminderTitle", objUpdateReminderBO.reminderTitle);
cmd.Parameters.Add("@reminderDetails", objUpdateReminderBO.reminderDetails);
conn.Open();
cmd.ExecuteNonQuery();
conn.Close();
}
public void UpdateReminder(AddReminderBO objUpdateReminderBO)
{
SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["ConnectionString"].ToString());
SqlCommand cmd = new SqlCommand("spUpdateReminder", conn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@empId", objUpdateReminderBO.empId);
cmd.Parameters.Add("@reminderId", objUpdateReminderBO.reminderId);
cmd.Parameters.Add("@reminderTitle", objUpdateReminderBO.reminderTitle);
cmd.Parameters.Add("@reminderDetails", objUpdateReminderBO.reminderDetails);
conn.Open();
cmd.ExecuteNonQuery();
conn.Close();
}
