public ActionResult AdminOracleTutorialsCreate(int?Id) { if (Session["Email"] == null) { return(RedirectToAction("Login", "AdminLogin")); } OracleTutorials OT = new OracleTutorials(); if (Id == null) { OT.PublishOn = DateTime.Now.ToString("MM dd yyyy hh:mm tt"); ViewBag.IsEdit = false; } else { using (SqlConnection con = new SqlConnection(cs)) { con.Open(); SqlCommand cmd = new SqlCommand("GetTutorialById", con); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@tutorialId", Id); cmd.ExecuteNonQuery(); DataTable dt = new DataTable(); SqlDataAdapter da = new SqlDataAdapter(cmd); da.Fill(dt); foreach (DataRow dr in dt.Rows) { OT.TutorialId = Convert.ToInt16(dr["TutorialId"]); OT.PublishOn = dr["PublishOn"].ToString(); OT.TutorialTabName = dr["TutorialTabName"].ToString(); OT.TutorialTitle = dr["TutorialTitle"].ToString(); OT.TutorialDescription = dr["TutorialDescription"].ToString(); } ViewBag.IsEdit = true; ViewBag.Id = Id; con.Close(); } } return(View(OT)); }
public ActionResult AdminOracleTutorialsCreate(OracleTutorials ot, bool IsEdit, int?id) { int result = 0; if (IsEdit) { using (SqlConnection con = new SqlConnection(cs)) { try { ot.TutorialId = Convert.ToInt16(id); con.Open(); SqlCommand cmd = new SqlCommand("InsertUpdateOracleTutorial", con); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@tutorialId", ot.TutorialId); cmd.Parameters.AddWithValue("@tutorialTabName", ot.TutorialTabName); cmd.Parameters.AddWithValue("@tutorialTitle", ot.TutorialTitle); cmd.Parameters.AddWithValue("@tutorialDescription", ot.TutorialDescription); cmd.Parameters.AddWithValue("@publishOn", ot.PublishOn); cmd.Parameters.AddWithValue("@Views", ot.Views); cmd.Parameters.Add("@Id", SqlDbType.Int).Direction = ParameterDirection.Output; cmd.ExecuteNonQuery(); con.Close(); } catch (Exception ex) { ViewBag.Msg = "Oops! something went wrong"; ViewBag.Status = "alert-danger"; } } ViewBag.IsEdit = true; ViewBag.Id = ot.TutorialId; ViewBag.Msg = "Tutorial Updated susseccful"; ViewBag.Status = "alert-success"; } else { using (SqlConnection con = new SqlConnection(cs)) { con.Open(); SqlCommand cmd = new SqlCommand("InsertUpdateOracleTutorial", con); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@tutorialId", ot.TutorialId); cmd.Parameters.AddWithValue("@tutorialTabName", ot.TutorialTabName); cmd.Parameters.AddWithValue("@tutorialTitle", ot.TutorialTitle); cmd.Parameters.AddWithValue("@tutorialDescription", ot.TutorialDescription); cmd.Parameters.AddWithValue("@publishOn", ot.PublishOn); cmd.Parameters.AddWithValue("@Views", ot.Views); cmd.Parameters.Add("@Id", SqlDbType.Int).Direction = ParameterDirection.Output; result = cmd.ExecuteNonQuery(); con.Close(); } if (result > 0) { ViewBag.Msg = "Tutprial Added susseccful"; ViewBag.Status = "alert-success"; } else { ViewBag.Msg = "Oops! something went wrong."; ViewBag.Status = "alert-danger"; } ViewBag.IsEdit = false; } return(View()); }