public List <VendorObject> GetAll() { SqlConnection conn = new SqlConnection(_connstring); SqlCommand cmd = new SqlCommand(); SqlDataReader reader; if (conn.State == ConnectionState.Closed) { conn.Open(); } cmd.Connection = conn; cmd.CommandType = CommandType.StoredProcedure; cmd.CommandText = "News_GetAll"; reader = cmd.ExecuteReader(); List <VendorObject> VendorList = new List <VendorObject>(); while (reader.Read()) { VendorObject VenObj = new VendorObject(); { VenObj.MsgId = reader.GetInt32(reader.GetOrdinal("MsgId")); VenObj.DisplayMsg = reader.GetString(reader.GetOrdinal("DisplayMsg")); VenObj.Msg_Title = reader.GetString(reader.GetOrdinal("Msg_Title")); VenObj.Full_Message = reader.GetString(reader.GetOrdinal("Full_Message")); } VendorList.Add(VenObj); } if (conn.State == ConnectionState.Open) { conn.Close(); } return(VendorList); }
/// <summary> /// This method gets the list of Vendors /// </summary> /// <param name="userId"></param> /// <returns>List<VendorObject></returns> public List <VendorObject> GetVendorList(int userId) { List <VendorObject> vendorList = new List <VendorObject>(); int distillerId = _dl.GetDistillerId(userId); try { var VendorFinalResults = from vendRes in _db.Vendor join vendDetails in _db.VendorDetail on vendRes.VendorID equals vendDetails.VendorID into vendDetails_join from vendDetails in vendDetails_join.DefaultIfEmpty() where vendRes.DistillerID == distillerId select new { vendRes.VendorID, vendRes.Name, Note = (vendDetails.Note ?? string.Empty) }; foreach (var vendorRes in VendorFinalResults) { var curVendor = new VendorObject(); curVendor.VendorId = vendorRes.VendorID; curVendor.VendorName = vendorRes.Name; curVendor.Note = vendorRes.Note; vendorList.Add(curVendor); } } catch (Exception e) { Debug.WriteLine("Error getting Vendor list : " + e); } return(vendorList); }
public VendorObject GetById(int MsgId) { SqlConnection conn = new SqlConnection(_connstring); SqlCommand cmd = new SqlCommand(); SqlParameter param = new SqlParameter(); SqlDataReader reader; if (conn.State == ConnectionState.Closed) { conn.Open(); } cmd.Connection = conn; cmd.CommandType = CommandType.StoredProcedure; cmd.CommandText = "News_GetById"; param = new SqlParameter("@MsgId", SqlDbType.Int, 4, "MsgId"); param.Direction = ParameterDirection.Input; param.Value = MsgId; cmd.Parameters.Add(param); reader = cmd.ExecuteReader(); VendorObject VenObj = new VendorObject(); while (reader.Read()) { VenObj.MsgId = reader.GetInt32(reader.GetOrdinal("MsgId")); VenObj.DisplayMsg = reader.GetString(reader.GetOrdinal("DisplayMsg")); VenObj.Msg_Title = reader.GetString(reader.GetOrdinal("Msg_Title")); VenObj.Full_Message = reader.GetString(reader.GetOrdinal("Full_Message")); } if (conn.State == ConnectionState.Open) { conn.Close(); } return(VenObj); }
protected void Page_Load(object sender, EventArgs e) { // cldDateOfBirth.Visible = false; if (!IsPostBack) { int VendorId = 0; string id = Convert.ToString(Request.QueryString["VendorId"]); // if (id != null) { btnVendorUpdate.Visible = true; btnVendorAdd.Visible = false; VendorId = Convert.ToInt32(id); VendorRepository VenRep = new VendorRepository(); VendorObject VenObj = VenRep.GetById(VendorId); hdnMsgId.Value = VenObj.MsgId.ToString(); txtDisplayMsg.Text = VenObj.DisplayMsg; txtMsg_Title.Text = VenObj.Msg_Title; txtFull_Message.Text = VenObj.Full_Message; } else { btnVendorUpdate.Visible = false; btnVendorAdd.Visible = true; } } }
public ActionResult Delete(int Id) { VendorObject venobj = new VendorObject(); VendorModel vendormodel = new VendorModel(); VendorRepository venrep = new VendorRepository(); venrep.Delete(Id); return(RedirectToAction("VendorIndex", "Vendor")); }
protected void btnVendorAdd_Click(object sender, EventArgs e) { VendorObject VenObj = new VendorObject(); VenObj.DisplayMsg = txtDisplayMsg.Text; VenObj.Msg_Title = txtMsg_Title.Text; VenObj.Full_Message = Convert.ToString(txtFull_Message.Text); VendorRepository VenRep = new VendorRepository(); VenRep.Add(VenObj); Response.Redirect("VendorList.aspx"); }
public ActionResult Edit(VendorModel vendormodel) { VendorObject venobj = new VendorObject(); venobj.MsgId = vendormodel.MsgId; venobj.DisplayMsg = vendormodel.DisplayNo; venobj.Msg_Title = vendormodel.Msg_Title; venobj.Full_Message = vendormodel.Full_Message; _vendor.Update(venobj); return(RedirectToAction("vendorIndex", "Vendor")); }
public ActionResult Edit(int Id) { VendorObject venobj = new VendorObject(); VendorModel vendormodel = new VendorModel(); VendorRepository venrep = new VendorRepository(); venobj = venrep.GetById(Id); vendormodel.MsgId = venobj.MsgId; vendormodel.DisplayNo = venobj.DisplayMsg; vendormodel.Msg_Title = venobj.Msg_Title; vendormodel.Full_Message = venobj.Full_Message; return(View(vendormodel)); }
public int Update(VendorObject VenObj) { int retval = 0; SqlConnection conn = new SqlConnection(_connstring); SqlCommand cmd = new SqlCommand(); SqlParameter param = new SqlParameter(); if (conn.State == ConnectionState.Closed) { conn.Open(); } cmd.Connection = conn; cmd.CommandType = CommandType.StoredProcedure; cmd.CommandText = "News_Update"; param = new SqlParameter("@MsgId", SqlDbType.Int, 4, "MsgId"); param.Direction = ParameterDirection.Input; param.Value = VenObj.MsgId; cmd.Parameters.Add(param); param = new SqlParameter("@DisplayMsg", SqlDbType.VarChar, 1000, "DisplayMsg"); param.Direction = ParameterDirection.Input; param.Value = VenObj.DisplayMsg; cmd.Parameters.Add(param); param = new SqlParameter("@Msg_Title", SqlDbType.VarChar, 1000, "Msg_Title"); param.Direction = ParameterDirection.Input; param.Value = VenObj.Msg_Title; cmd.Parameters.Add(param); param = new SqlParameter("@Full_Message", SqlDbType.VarChar, 1000, "Full_Message"); param.Direction = ParameterDirection.Input; param.Value = VenObj.Full_Message; cmd.Parameters.Add(param); retval = cmd.ExecuteNonQuery(); if (conn.State == ConnectionState.Open) { conn.Close(); } return(retval); }
/// <summary> /// UpdateVendor method updates Vendor table and a note value in Notes table if Note hasn't been changed /// </summary> /// <param name="vendorObject"></param> /// <param name="userId"></param> /// <returns>bool</returns> public bool UpdateVendor(int userId, VendorObject vendorObject) { //define method execution return value to be false by default var retMthdExecResult = false; int distillerId = _dl.GetDistillerId(userId); if (vendorObject != null) { try { var recs = from rec in _db.Vendor where rec.VendorID == vendorObject.VendorId && rec.DistillerID == distillerId select rec; var vendorItem = recs.FirstOrDefault(); if (vendorItem.Name != vendorObject.VendorName || vendorObject.Note != string.Empty) { vendorItem.Name = vendorObject.VendorName; _db.SaveChanges(); } var recs1 = from rec1 in _db.VendorDetail where rec1.VendorID == vendorObject.VendorId select rec1; var vendorItem1 = recs1.FirstOrDefault(); if (vendorItem1.Note != vendorObject.Note || vendorObject.Note != null) { vendorItem1.Note = vendorObject.Note; _db.SaveChanges(); } retMthdExecResult = true; } catch (Exception e) { Debug.WriteLine("Failed updating vendor record: " + e); retMthdExecResult = false; } } return(retMthdExecResult); }
public ActionResult Add(VendorModel vendormodel) { if (ModelState.IsValid) { VendorObject venobj = new VendorObject(); venobj.DisplayMsg = vendormodel.DisplayNo; venobj.Msg_Title = vendormodel.Msg_Title; venobj.Full_Message = vendormodel.Full_Message; _vendor.Add(venobj); } else { return(View(vendormodel)); } return(RedirectToAction("VendorIndex", "Vendor")); }
/// <summary> /// CreateVendor Method inserts new record in Vendor table and also updates Note table if there is a note /// </summary> /// <param name="vendorObject"></param> /// <param name="userId"></param> /// <returns>int</returns> public int CreateVendor(int userId, VendorObject vendorObject) { //define method execution return value to be false by default int retMthdExecResult = 0; int distillerID = _dl.GetDistillerId(userId); if (vendorObject != null) { try { Vendor tbl = new Vendor(); tbl.Name = vendorObject.VendorName; tbl.DistillerID = distillerID; _db.Vendor.Add(tbl); _db.SaveChanges(); VendorDetail tbl1 = new VendorDetail(); if (vendorObject.Note != string.Empty && vendorObject.Note != null) { tbl1.Note = vendorObject.Note; } tbl1.VendorID = tbl.VendorID; _db.VendorDetail.Add(tbl1); _db.SaveChanges(); retMthdExecResult = tbl.VendorID; } catch (Exception e) { retMthdExecResult = 0; throw e; } } else { retMthdExecResult = 0; } return(retMthdExecResult); }
public JsonResult CreateVendor(VendorObject vendorObject) { if (vendorObject != null) { if (User.Identity.IsAuthenticated) { int userId = User.Identity.GetUserId <int>(); if (userId > 0) { int returnResult = _dictionary.CreateVendor(userId, vendorObject); if (returnResult > 0) { string message = "Vendor dictionary record created successfully."; return(Json(message)); } else { string message = "Failed to create vendor dictionary record!"; return(Json(message)); } } else { return(Json("Unable to find UserId!")); } } else { return(Json("Unauthenticated user!")); } } else { return(Json("Back End received empty or undefined Vendor Object from the client")); } }