public ActionResult attribute_Edit(Int32 attribute_id) // banse { try { using (jugglecontext dbcon = new jugglecontext()) { tbl_attribute_data work_type = dbcon.tbl_attribute_data.Where(x => x.attribute_id == attribute_id).FirstOrDefault(); tbl_attribute_data prod = new tbl_attribute_data(); prod.attribute_id = work_type.attribute_id; prod.attribute_name = work_type.attribute_name; prod.created_date = work_type.created_date; prod.updated_date = DateTime.Now; prod.user_id = Convert.ToInt32(Session["User_Id"]); return(View(prod)); } } catch { return(View()); } }
public ActionResult Create_attribute(tbl_attribute_data attribute) { if (Session["User_Id"] != null) { using (jugglecontext dbcon = new jugglecontext()) { tbl_attribute_data data_attribute = new tbl_attribute_data(); data_attribute.attribute_name = attribute.attribute_name; data_attribute.created_date = DateTime.Now; data_attribute.user_id = Convert.ToInt32(Session["User_Id"]); dbcon.tbl_attribute_data.Add(data_attribute); dbcon.SaveChanges(); return(RedirectToAction("attribute", "Attribute")); } } else { return(RedirectToAction("Login", "Account")); } }
public ActionResult attribute_Edit(juggle.Models.tbl_attribute_data work_type_category) { try { using (jugglecontext dbcon = new jugglecontext()) { var userId = Convert.ToInt32(Session["User_Id"]); tbl_attribute_data attribute = new tbl_attribute_data(); attribute.attribute_name = work_type_category.attribute_name.Trim(); attribute.attribute_id = work_type_category.attribute_id; attribute.updated_date = DateTime.Now; attribute.created_date = work_type_category.created_date; attribute.user_id = userId; dbcon.Entry(attribute).State = System.Data.Entity.EntityState.Modified; dbcon.SaveChanges(); return(RedirectToAction("attribute", "Attribute")); } } catch { return(View()); } }
public ActionResult attribute_delete(Int32 atrribute_id) { try { using (jugglecontext dbcon = new jugglecontext()) { if (Session["User_Id"] != null) { string atrributeid = atrribute_id.ToString(); // when delete attribute then remove that attribute from the appointment, client,employee var client_detail = (from a in dbcon.tbl_client where a.attribute_id.Contains(atrributeid) select a).ToList(); var employee_detail = (from a in dbcon.tbl_employee_info where a.attribute_id.Contains(atrributeid) select a).ToList(); var appointment_detail = (from a in dbcon.tbl_appointment where a.attribute_id.Contains(atrributeid) select a).ToList(); for (int i = 0; i < client_detail.Count; i++) { string client_attri = client_detail[i].attribute_id.ToString(); client_attri = client_attri.Replace(atrributeid, ""); SqlConnection connection = new SqlConnection(dbcon.connectionString()); var command = new SqlCommand("[updatedata]", connection); command.CommandType = CommandType.StoredProcedure; command.Parameters.AddWithValue("@client_id", Convert.ToInt32(client_detail[i].client_id)); command.Parameters.AddWithValue("@attribute_id", client_attri); command.Parameters.AddWithValue("@appointment_id", 0); command.Parameters.AddWithValue("@StatementType", "attribute_data"); command.Parameters.AddWithValue("@emp_id", 0); command.Parameters.AddWithValue("@startdate", 0); command.Parameters.AddWithValue("@enddate", 0); command.Parameters.AddWithValue("@StartTime", 0); command.Parameters.AddWithValue("@endTime", 0); command.Parameters.AddWithValue("@user_id", Convert.ToInt32(Session["User_Id"])); connection.Open(); SqlDataReader rdr = command.ExecuteReader(); } for (int i = 0; i < employee_detail.Count; i++) { string emp_attri = employee_detail[i].attribute_id.ToString(); emp_attri = emp_attri.Replace(atrributeid, ""); SqlConnection connection = new SqlConnection(dbcon.connectionString()); var command = new SqlCommand("[updatedata]", connection); command.CommandType = CommandType.StoredProcedure; command.Parameters.AddWithValue("@client_id", 0); command.Parameters.AddWithValue("@attribute_id", emp_attri); command.Parameters.AddWithValue("@StatementType", "attribute_data"); command.Parameters.AddWithValue("@appointment_id", 0); command.Parameters.AddWithValue("@emp_id", employee_detail[i].emp_id); command.Parameters.AddWithValue("@startdate", 0); command.Parameters.AddWithValue("@enddate", 0); command.Parameters.AddWithValue("@StartTime", 0); command.Parameters.AddWithValue("@endTime", 0); command.Parameters.AddWithValue("@user_id", Convert.ToInt32(Session["User_Id"])); connection.Open(); SqlDataReader rdr = command.ExecuteReader(); } for (int i = 0; i < appointment_detail.Count; i++) { string appointment_attri = appointment_detail[i].attribute_id.ToString(); appointment_attri = appointment_attri.Replace(atrributeid, ""); SqlConnection connection = new SqlConnection(dbcon.connectionString()); var command = new SqlCommand("[updatedata]", connection); command.CommandType = CommandType.StoredProcedure; command.Parameters.AddWithValue("@client_id", 0); command.Parameters.AddWithValue("@attribute_id", appointment_attri); command.Parameters.AddWithValue("@StatementType", "attribute_data"); command.Parameters.AddWithValue("@appointment_id", appointment_detail[i].appointment_id); command.Parameters.AddWithValue("@emp_id", 0); command.Parameters.AddWithValue("@startdate", 0); command.Parameters.AddWithValue("@enddate", 0); command.Parameters.AddWithValue("@StartTime", 0); command.Parameters.AddWithValue("@endTime", 0); command.Parameters.AddWithValue("@user_id", Convert.ToInt32(Session["User_Id"])); connection.Open(); SqlDataReader rdr = command.ExecuteReader(); } tbl_attribute_data objEmp = dbcon.tbl_attribute_data.Find(atrribute_id); dbcon.tbl_attribute_data.Remove(objEmp); dbcon.SaveChanges(); } return(RedirectToAction("attribute", "Attribute")); } } catch { return(View()); } }