public ActionResult Create_Worktype(juggle.Models.tbl_worktype work_type) { using (jugglecontext dbcon = new jugglecontext()) { try { tbl_worktype worktype = new tbl_worktype(); worktype.name = work_type.name.Trim(); worktype.color = work_type.color; var time = Request.Form["multiple"]; worktype.time = time; worktype.user_id = Convert.ToInt32(Session["User_Id"]); worktype.created_date = DateTime.Now; dbcon.tbl_worktype.Add(worktype); dbcon.SaveChanges(); return(RedirectToAction("Work_type", "Work_type")); } catch (DbEntityValidationException ex) { foreach (var entityValidationErrors in ex.EntityValidationErrors) { foreach (var validationError in entityValidationErrors.ValidationErrors) { Response.Write("Property: " + validationError.PropertyName + " Error: " + validationError.ErrorMessage); } } return(View(work_type)); } } }
public ActionResult Worktype_Edit(juggle.Models.tbl_worktype work_type) { try { using (jugglecontext dbcon = new jugglecontext()) { tbl_worktype worktype = new tbl_worktype(); worktype.name = work_type.name.Trim(); worktype.color = work_type.color; var time = Request.Form["multiple"]; worktype.time = time; worktype.work_id = work_type.work_id; worktype.updated_date = DateTime.Now; worktype.user_id = work_type.user_id; worktype.created_date = work_type.created_date; dbcon.Entry(worktype).State = System.Data.Entity.EntityState.Modified; dbcon.SaveChanges(); return(RedirectToAction("Work_type", "Work_type")); } } catch { return(View()); } }
public ActionResult Worktype_Edit(Int32 work_id) // banse { jugglecontext dbcon1 = new jugglecontext(); var content = from p in dbcon1.tbl_worktype select new { p.work_id, p.name }; var wname = content.ToList().Select(c => new SelectListItem { Text = c.name.ToString(), Value = c.work_id.ToString(), Selected = (c.work_id == work_id) }).ToList(); ViewBag.CurrencyList = wname; try { using (jugglecontext dbcon = new jugglecontext()) { tbl_worktype work_type = dbcon.tbl_worktype.Where(x => x.work_id == work_id).FirstOrDefault(); tbl_worktype prod = new tbl_worktype(); prod.work_id = work_type.work_id; prod.name = work_type.name; prod.color = work_type.color; prod.worktypecat_id = work_type.worktypecat_id; prod.user_id = work_type.user_id; prod.created_date = work_type.created_date; return(View(prod)); } } catch (Exception ex) { return(View()); } }
public ActionResult Worktype_delete(Int32 work_id) { if (Session["User_Id"] != null) { try { using (jugglecontext dbcon = new jugglecontext()) { if (Session["User_Id"] != null) { string workid = work_id.ToString(); var employee_detail = (from a in dbcon.tbl_employee_info where a.emp_qualifiedservicetypes.Contains(workid) select a).ToList(); for (int i = 0; i < employee_detail.Count; i++) { string emp_worktype = employee_detail[i].emp_qualifiedservicetypes.ToString(); emp_worktype = emp_worktype.Replace(workid, ""); 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_worktype); command.Parameters.AddWithValue("@appointment_id", 0); command.Parameters.AddWithValue("@StatementType", "worktype_data"); command.Parameters.AddWithValue("@emp_id", Convert.ToInt32(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(); } tbl_worktype objEmp = dbcon.tbl_worktype.Find(work_id); dbcon.tbl_worktype.Remove(objEmp); dbcon.SaveChanges(); } return(RedirectToAction("Work_type", "Work_type")); } } catch { return(View()); } } else { return(View("Login", "Account")); } }
public void getworktype(Int32 work_id) { try { using (jugglecontext dbcon = new jugglecontext()) { tbl_worktype objEmp = dbcon.tbl_worktype.Find(work_id); } ViewBag.Countries = new List <string> { "India", "US", "UK", "Canada" }; } catch (Exception ex) { } }
public ActionResult Worktype_delete(Int32 work_id) { try { using (jugglecontext dbcon = new jugglecontext()) { if (Session["User_Id"] != null) { tbl_worktype objEmp = dbcon.tbl_worktype.Find(work_id); dbcon.tbl_worktype.Remove(objEmp); dbcon.SaveChanges(); } return(RedirectToAction("Worktype", "Worktype")); } } catch (Exception ex) { return(View()); } }
public ActionResult Worktype_Edit(Int32 work_id) // banse { if (Session["User_Id"] != null) { jugglecontext dbcon1 = new jugglecontext(); try { using (jugglecontext dbcon = new jugglecontext()) { tbl_worktype work_type = dbcon.tbl_worktype.Where(x => x.work_id == work_id).FirstOrDefault(); tbl_worktype prod = new tbl_worktype(); prod.work_id = work_type.work_id; prod.name = work_type.name; prod.color = work_type.color; prod.time = work_type.time; prod.user_id = work_type.user_id; prod.created_date = work_type.created_date; var content = from p in dbcon.servicetypetimes select new { p.value, p.timeinminute }; var y = content.ToList().Select(c => new SelectListItem { Text = c.timeinminute.ToString(), Value = c.value.ToString(), }).ToList(); ViewBag.servicetypeminute = y; return(View(prod)); } } catch { return(View()); } } else { return(View("Login", "Account")); } }
public ActionResult Create_Worktype(juggle.Models.tbl_worktype work_type) { using (jugglecontext dbcon = new jugglecontext()) { try { tbl_worktype worktype = new tbl_worktype(); worktype.name = work_type.name.Trim(); worktype.color = work_type.color.Trim(); worktype.worktypecat_id = Convert.ToInt32(work_type.worktypecat_id); worktype.user_id = Convert.ToInt32(Session["User_Id"]); worktype.created_date = DateTime.Now; dbcon.tbl_worktype.Add(worktype); dbcon.SaveChanges(); return(RedirectToAction("Worktype", "Worktype")); } catch (Exception ex) { return(View(work_type)); } } }