public bool UpdateItem(MS_Item Item)
{
string sql = " Update MS_Item set ItemName=@ItemName, ItemCode=@ItemCode,ItemDescription=@ItemDescription, " +
" OrganizationId=@OrganizationId,CategoryId=@CategoryId, " +
" EnteredBy=@EnteredBy, EnteredDate=@EnteredDate,LastUpdatedBy=@LastUpdatedBy, " +
" LastUpdatedDate=@LastUpdatedDate, IsDeleted=0, DeletedBy=0, DeletedDate=null" +
" where ItemId=@ItemId";
using (var db = DbHelper.GetDBConnection())
{
using (var trsn = new TransactionScope())
{
//db.Execute(sql);
var lst = db.Execute(sql, Item);
trsn.Complete();
db.Close();
if (lst > 0)
{
return(true);
}
else
{
return(false);
}
}
}
}
public int InsertItem(MS_Item Item)
{
try
{
string sql = " Insert into MS_Item (ItemName, ItemCode,ItemDescription,CategoryId,OrganizationId, EnteredBy, EnteredDate," +
" LastUpdatedBy, LastUpdatedDate, IsDeleted, DeletedBy, DeletedDate) " +
" values " +
"(@ItemName, @ItemCode,@ItemDescription,@CategoryId,@OrganizationId, @EnteredBy, @EnteredDate," +
" 0, null, 0, 0, null) SELECT CAST(SCOPE_IDENTITY() as int)";
using (var db = DbHelper.GetDBConnection())
{
using (var trsn = new TransactionScope())
{
//db.Execute(sql);
var lst = db.Query <int>(sql, Item).SingleOrDefault();
trsn.Complete();
db.Close();
return(lst);
}
}
}
catch
{
return(0);
}
}
public ActionResult Create(FormCollection frm, string[] hddrowpindex)
{
var ses = sesrepo.GetSessionById((User as CustomPrincipal).UserId);
int orgid = ses.OrganizationId;
try
{
MS_Item item = new MS_Item();
item.ItemName = frm["ItemName"];
//item.ItemCode = frm["ItemCode"];
//item.ItemDescription = frm["ItemDescription"];
item.OrganizationId = orgid;// Convert.ToInt32(frm["OrganizationId"]);
item.CategoryId = Convert.ToInt32(frm["CategoryId"]);
item.EnteredBy = (User as CustomPrincipal).UserId;
item.EnteredDate = DateTime.Now;
int itemid = db.InsertItem(item);
MS_ItemUnit uitem;
if (hddrowpindex != null && hddrowpindex.Count() > 0)
{
foreach (var unititem in hddrowpindex)
{
uitem = new MS_ItemUnit();
uitem.UnitId = Convert.ToInt32(frm["UnitId-" + unititem]);
uitem.UnitSellingPrice = Convert.ToDecimal(frm["SellingPrice-" + unititem]);
uitem.QuantityInPiece = Convert.ToInt32(frm["QuantityPer-" + unititem]);
if (frm["IsDefault-" + unititem] != null)
{
uitem.IsDefault = true;
}
else
{
uitem.IsDefault = false;
}
uitem.OrganizationId = item.OrganizationId;
uitem.ItemId = itemid;
iu.InsertItemUnit(uitem);
}
}
}catch (Exception ex)
{
return(View());
}
ViewBag.UnitList = udb.GetUnitList(orgid, "", "");
ViewBag.CategoryId = new SelectList(ddl.GetCategoryList(orgid), "Id", "Name");
ViewBag.OrganizationId = new SelectList(ddl.GetOrganizationList(), "Id", "Name");
return(RedirectToAction("Index"));
}
