public ActionResult Adddepartdomain() { Cms_Problemdescription cms_getdepart = new Cms_Problemdescription(); cms_getdepart.Departmentname = DepartmentList(); return(View(cms_getdepart)); }
public bool AddDepartmentwithdescription(Cms_Problemdescription cms_problemdescription) { string departmentid, departmentdescription, regdate; try { con.Open(); SqlTransaction trans = con.BeginTransaction(); try { departmentid = Convert.ToString(cms_problemdescription.Cms_Departmentid); departmentdescription = cms_problemdescription.Cms_Problemdomain; regdate = cms_problemdescription.Cms_Problemregistertime.ToString(); SqlCommand dbcmd = con.CreateCommand(); dbcmd.Transaction = trans; dbcmd.CommandText = "insert into Cms_Problemdescription(Cms_Departmentid,Cms_Problemdomain,Cms_Problemregistertime) Values(@departmentid,@departmentdescription,@regdate)"; dbcmd.Parameters.AddWithValue("@departmentid", departmentid); dbcmd.Parameters.AddWithValue("@departmentdescription", departmentdescription); dbcmd.Parameters.AddWithValue("@regdate", regdate); dbcmd.ExecuteNonQuery(); trans.Commit(); con.Close(); return(true); } catch (Exception ex) { trans.Rollback(); con.Close(); return(false); } } catch { return(false); } }
public ActionResult Adddepartdomain(Cms_Problemdescription cmsproblemdescription) { if (ModelState.IsValid) { cmsproblemdescription.Cms_Problemregistertime = Convert.ToDateTime(DateTime.Now.ToLongTimeString()); cmsproblemdescription.Departmentname = DepartmentList(); var selectedItem = cmsproblemdescription.Departmentname.Find(p => p.Value == cmsproblemdescription.Cms_Departmentid.ToString()); if (selectedItem != null) { selectedItem.Selected = true; qh.AddDepartmentwithdescription(cmsproblemdescription); ViewBag.Success = "Successfully Added!! "; } } if (ViewBag.Success == null) { ViewBag.Error = "Something went wrong"; } return(View(cmsproblemdescription)); }