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));
}
