public bool UpdateInventoryVendor(INV_Vendor a) { string sql = " Update INV_Vendor set VendorName=@VendorName, Address=@Address,Phone=@Phone,Mobile=@Mobile,PanNo=@PanNo, " + " OrganizationId=@OrganizationId, " + " LastUpdatedBy=@LastUpdatedBy, " + " LastUpdatedDate=@LastUpdatedDate" +// IsDeleted=0, DeletedBy=0, DeletedDate=null" + " where VendorId=@VendorId"; using (var db = DbHelper.GetDBConnection()) { using (var trsn = new TransactionScope()) { //db.Execute(sql); var lst = db.Execute(sql, a); trsn.Complete(); db.Close(); if (lst > 0) { return(true); } else { return(false); } } } }
public bool InsertInventoryVendor(INV_Vendor a) { string sql = " Insert into INV_Vendor (VendorName, Address,Phone,Mobile,PanNo,OrganizationId, EnteredBy, EnteredDate," + " LastUpdatedBy, LastUpdatedDate, IsDeleted, DeletedBy, DeletedDate) " + " values " + "(@VendorName, @Address,@Phone,@Mobile,@PanNo,@OrganizationId, @EnteredBy, @EnteredDate," + " 0, null, 0, 0, null)"; using (var db = DbHelper.GetDBConnection()) { using (var trsn = new TransactionScope()) { //db.Execute(sql); var lst = db.Execute(sql, a); trsn.Complete(); db.Close(); if (lst > 0) { return(true); } else { return(false); } } } }
public int AddVendor(INV_Vendor saveVen) { string sql = "insert into INV_Vendor(VendorName,VendorCode,Address,Phone,Mobile,PanNo,EnteredBy,EnteredDate,LastUpdatedBy,LastUpdatedDate,DepartmentId,IsDeleted)" + " values(@VendorName,@VendorCode,@Address,@Phone,@Mobile,@PanNo,@EnteredBy,@EnteredDate,0,null,@DepartmentId,0)"; using (var db = DbHelper.GetDBConnection()) { int id = db.Query <int>(sql, saveVen).SingleOrDefault(); db.Close(); return(id); } }
public ActionResult Edit(FormCollection frm, int?id) { INV_Vendor updateVen = new INV_Vendor(); updateVen.VendorName = frm["VendorName"]; updateVen.VendorName = frm["Address"]; updateVen.VendorName = frm["Phone"]; updateVen.VendorName = frm["Mobile"]; updateVen.VendorName = frm["PanNo"]; updateVen.VendorCode = frm["VendorCode"].ToUpper(); updateVen.LastUpdatedDate = DateTime.Now; updateVen.LastUpdatedBy = Convert.ToInt32(frm["SesUserId"]); db.UpdateVendor(updateVen, (int)id); return(RedirectToAction("Index")); }
public ActionResult Create(FormCollection frm) { INV_Vendor saveVen = new INV_Vendor(); saveVen.VendorName = frm["VendorName"]; saveVen.VendorCode = frm["VendorCode"]; saveVen.Address = frm["Address"]; saveVen.Phone = frm["Phone"]; saveVen.Mobile = frm["Mobile"]; saveVen.PanNo = frm["PanNo"]; saveVen.EnteredDate = DateTime.Now; saveVen.EnteredBy = Convert.ToInt32(Session["UserId"]); saveVen.DepartmentId = Convert.ToInt32(Session["DepartmentId"]); db.AddVendor(saveVen); return(RedirectToAction("Index")); }
public bool UpdateVendor(INV_Vendor updateVen, int Id) { string sql = " Update INV_Vendor set VendorName=@VendorName, VendorCode=@VendorCode, Address=@Address, Phone=@Phone, Mobile=@Mobile, PanNo=@PanNo" + "LastUpdatedDate=@LastUpdatedDate, LastUpdatedBy=@LastUpdatedBy where VendorId= " + Id; using (var db = DbHelper.GetDBConnection()) { var lst = db.Execute(sql, updateVen); db.Close(); if (lst > 0) { return(true); } else { return(false); } } }
public ActionResult Edit(FormCollection frm) { var ses = sesrepo.GetSessionById((User as CustomPrincipal).UserId); int orgid = ses.OrganizationId; INV_Vendor aCD_Class = db.GetInventoryVendorById(Convert.ToInt32(frm["VendorId"])); aCD_Class.VendorName = frm["VendorName"]; aCD_Class.Address = frm["Address"]; aCD_Class.Phone = frm["Phone"]; aCD_Class.Mobile = frm["Mobile"]; aCD_Class.PanNo = frm["PanNo"]; aCD_Class.OrganizationId = orgid;// Convert.ToInt32(frm["OrganizationId"]); aCD_Class.LastUpdatedBy = (User as CustomPrincipal).UserId; aCD_Class.LastUpdatedDate = DateTime.Now; if (ModelState.IsValid) { db.UpdateInventoryVendor(aCD_Class); return(RedirectToAction("Index")); } ViewBag.OrganizationId = new SelectList(ddl.GetOrganizationList(), "Id", "Name", aCD_Class.OrganizationId); return(View(aCD_Class)); }