public bool AddnewDepartment(Cms_Department cmsdepartment) { string departmentname, regdate; try { con.Open(); SqlTransaction trans = con.BeginTransaction(); try { departmentname = cmsdepartment.Cms_Departmentname; regdate = cmsdepartment.Cms_Departmentregister.ToString(); SqlCommand dbcmd = con.CreateCommand(); dbcmd.Transaction = trans; dbcmd.CommandText = "insert into Cms_Department(Cms_Departmentname,Cms_Departmentregister) Values(@departmentname,@regdate)"; dbcmd.Parameters.AddWithValue("@departmentname", departmentname); 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 string Checkexist_department(Cms_Department cmsuser) { string department; department = cmsuser.Cms_Departmentname; SqlCommand cmd = con.CreateCommand(); cmd.CommandText = "Select * from Cms_Department Where Cms_Departmentname=@department"; cmd.Parameters.AddWithValue("@department", department); SqlDataAdapter da = new SqlDataAdapter(cmd); DataSet ds = new DataSet(); con.Open(); da.Fill(ds); con.Close(); if (ds.Tables[0].Rows.Count != 0) { return("Department already exists"); } return("Added succeess fully"); }
public ActionResult Adddepartment(Cms_Department cms_department) { if (ModelState.IsValid) { cms_department.Cms_Departmentregister = Convert.ToDateTime(DateTime.Now.ToLongTimeString()); string a = qh.Checkexist_department(cms_department); if (a == "Department already exists") { ViewBag.message = "Department name is already exists"; } else { qh.AddnewDepartment(cms_department); ModelState.Clear(); } } else { ViewBag.Error = "Something went wrong"; } ViewBag.Success = "Successfully register for Cms system!! "; return(View()); }