public bool UpdateKVendor(K_Vendor a)
{
string sql = " Update KI_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 InsertKVendor(K_Vendor a)
{
string sql = " Insert into KI_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 ActionResult Edit(FormCollection frm)
{
var ses = sesrepo.GetSessionById((User as CustomPrincipal).UserId);
int orgid = ses.OrganizationId;
K_Vendor aCD_Class = db.GetKVendorById(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.UpdateKVendor(aCD_Class);
return(RedirectToAction("Index"));
}
ViewBag.OrganizationId = new SelectList(ddl.GetOrganizationList(), "Id", "Name", aCD_Class.OrganizationId);
return(View(aCD_Class));
}
