public ActionResult CommentsEdit(FormCollection form) { if (!string.IsNullOrEmpty(Session["username"] as string)) { try { List <SalesComments> lst = new List <SalesComments>(); for (int i = 1; i <= 2; i++) { SalesComments obj = new SalesComments(); obj.comment = form["comment" + i]; obj.sector = form["sector" + i]; obj.commentid = i + 2; lst.Add(obj); } Salesdata sd = new Salesdata(); foreach (SalesComments obj in lst) { sd.UpdateCommentSales(obj); } return(RedirectToAction("Index")); } catch (Exception ex) { return(View("Error", ex)); } } else { return(RedirectToAction("Index", "Login")); } }
public List <SalesComments> GetSalesComments() { List <SalesComments> lst = new List <SalesComments>(); DataSet data = DBConnection.GetData("getSalesComments"); foreach (DataRow row in data.Tables[0].Rows) { SalesComments Obj = new SalesComments(); Obj.commentid = Convert.ToInt32(row["commentid"].ToString()); Obj.sector = !String.IsNullOrEmpty(row["sector"].ToString()) ? row["sector"].ToString() : string.Empty; Obj.comment = !String.IsNullOrEmpty(row["comments"].ToString()) ? row["comments"].ToString() : string.Empty; lst.Add(Obj); } return(lst); }
public void UpdateCommentSales(SalesComments obj) { using (SqlConnection con = new SqlConnection(DBConnection.GetConnectionString())) { using (SqlCommand cmd = new SqlCommand("UpdatesalesComment", con)) { cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@commentid", obj.commentid); cmd.Parameters.AddWithValue("@comments", obj.comment); cmd.Parameters.AddWithValue("@sector", obj.sector); con.Open(); cmd.ExecuteNonQuery(); } } }