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);
    }
Exemplo n.º 2
0
    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();
    }