public int AddVendor(A_Vendor saveVendor)
{
string sql = "insert into A_Vendor(VendorName,VendorAddress,VendorPhone,VendorMobile,PanNo,EnteredBy,EnteredDate,LastUpdatedBy,LastUpdatedDate," +
"IsDeleted,DeletedBy,DeletedDate)" +
" values(@VendorName,@VendorAddress,@VendorPhone,@VendorMobile,@PanNo,@EnteredBy,@EnteredDate,0,null," +
"0,0,null)";
using (var db = DbHelper.GetDBConnection())
{
int id = db.Query <int>(sql, saveVendor).SingleOrDefault();
db.Close();
return(id);
}
}
public ActionResult Create(FormCollection frm)
{
A_Vendor saveVendor = new A_Vendor();
saveVendor.VendorName = frm["VendorName"];
saveVendor.VendorAddress = frm["VendorAddress"];
saveVendor.VendorPhone = frm["VendorPhone"];
saveVendor.VendorMobile = frm["VendorMobile"];
saveVendor.PanNo = frm["PanNo"];
saveVendor.EnteredDate = DateTime.Now;
saveVendor.EnteredBy = Convert.ToInt32(Session["UserId"]);
db.AddVendor(saveVendor);
return(RedirectToAction("Index"));
}
public ActionResult Edit(FormCollection frm, int?id)
{
A_Vendor updateVendor = new A_Vendor();
updateVendor.VendorName = frm["VendorName"];
updateVendor.VendorAddress = frm["VendorAddress"];
updateVendor.VendorPhone = frm["VendorPhone"];
updateVendor.VendorMobile = frm["VendorMobile"];
updateVendor.PanNo = frm["PanNo"];
updateVendor.LastUpdatedDate = DateTime.Now;
updateVendor.LastUpdatedBy = Convert.ToInt32(Session["UserId"]);
db.UpdateVendor(updateVendor, (int)id);
return(RedirectToAction("Index"));
}
public bool UpdateVendor(A_Vendor updateVendor, int Id)
{
string sql = " Update A_Vendor set VendorName=@VendorName, VendorAddress=@VendorAddress,VendorPhone=@VendorPhone,VendorMobile=@VendorMobile,PanNo=@PanNo," +
"LastUpdatedDate=@LastUpdatedDate, LastUpdatedBy=@LastUpdatedBy where IsDeleted=0 and VendorId= " + Id;
using (var db = DbHelper.GetDBConnection())
{
var lst = db.Execute(sql, updateVendor);
db.Close();
if (lst > 0)
{
return(true);
}
else
{
return(false);
}
}
}
