public int Update(Models.SysUserView data)
{
try
{
this.Validate(data);
data.ModifiedBy = GlobalVariant.GetAppUser().UserID;
data.ModifiedDateTime = DateTime.Now;
var olddata = GetById(data.UserID);
if (olddata.Name != data.Name || olddata.Password != data.Password)
{
data.Password = Accounting.Services.MD5.GenerateHashDigest(data.Name + data.Password);
}
SqlParameter pOriginal = ExConvert.ParseSqlParam(data, this._metaobject.GetMetaByColumnName(this._paramnameoutput), this._paramnameupdate);
var parameters = ExConvert.Data2SqlParam(data, this._metaobject, pOriginal).ToArray();
this._db.Database.ExecuteSqlCommand(this._storeNameU, parameters);
return(data.UserID);
}
catch (Exception)
{
throw;
}
}
public int Insert(Models.AppFixedAssetView data)
{
try
{
this.Validate(data);
data.CreatedBy = GlobalVariant.GetAppUser().UserID;
data.CreatedDateTime = DateTime.Now;
SqlParameter[] parameters = ExConvert.Data2SqlParam(data, this._metaobject, this._paramnameoutput).ToArray();
this._db.Database.ExecuteSqlCommand(this._storeNameI, parameters);
#region Xử lý line
this._metaobject = Services.GlobalMeta.GetMetaObject(this._metalinename);
var AppFixedAssetLineTables = data.AppFixedAssetLineTables.ToList();
var AppFixedAssetLineTablez = data.AppFixedAssetLineTablez.ToList();
for (int i = 0; i < AppFixedAssetLineTables.Count; i++)
{
var itemz = AppFixedAssetLineTablez[i];
if (itemz != -1)
{
var item = AppFixedAssetLineTables[i];
item.FixedAssetID = data.FixedAssetID;
this.InsertLine(item);
}
}
#endregion
#region Xử lý VAT
if (data.AppEquipmentTables != null)
{
this._metaobject = Services.GlobalMeta.GetMetaObject(this._metavatname);
var AppEquipmentTables = data.AppEquipmentTables.ToList();
var AppEquipmentTablez = data.AppEquipmentTablez.ToList();
for (int i = 0; i < AppEquipmentTables.Count; i++)
{
var itemz = AppEquipmentTablez[i];
if (itemz != -1)
{
var item = AppEquipmentTables[i];
item.FixedAssetID = data.FixedAssetID;
this.InsertVAT(item);
}
}
}
#endregion
return((int)parameters.GetValueSqlParam(this._paramnameoutput));
}
catch (Exception)
{
throw;
}
}
public ActionResult PayOrder(int Id, int status)
{
try
{
var _data = _dataobject.GetById2(Id);
_data.OrderStatusId = status;
_data.ModifiedBy = GlobalVariant.GetAppUser().UserID;
_data.ModifiedDateTime = DateTime.Now;
_dataobject._db.Entry(_data).State = System.Data.Entity.EntityState.Modified;
_dataobject._db.SaveChanges();
return(Json(new { ketqua = 1, tableid = _data.TableId ?? 0 }, JsonRequestBehavior.AllowGet));
}
catch (Exception)
{
return(Json(new { ketqua = 0, tableid = 0 }, JsonRequestBehavior.AllowGet));
}
}
public int Insert(Models.GapField data)
{
try
{
this.Validate(data);
data.CreatedBy = GlobalVariant.GetAppUser().UserID;
data.CreatedDateTime = DateTime.Now;
var _data = new Models.GapField();
this.MapView2Table(data, _data);
this._db.GapFields.Add(_data);
this._db.SaveChanges();
return(data.FieldId);
}
catch (Exception)
{
throw;
}
}
public int Insert(Models.AppExpenseTable data)
{
try
{
this.Validate(data);
data.CreatedBy = GlobalVariant.GetAppUser().UserID;
data.CreatedDateTime = DateTime.Now;
SqlParameter[] parameters = ExConvert.Data2SqlParam(data, this._metaobject, this._paramnameoutput).ToArray();
this._db.Database.ExecuteSqlCommand(this._storeNameI, parameters);
return((int)parameters.GetValueSqlParam(this._paramnameoutput));
}
catch (Exception)
{
throw;
}
}
public int Update(Models.AppExpenseTable data)
{
try
{
this.Validate(data);
data.ModifiedBy = GlobalVariant.GetAppUser().UserID;
data.ModifiedDateTime = DateTime.Now;
SqlParameter pOriginal = ExConvert.ParseSqlParam(data, this._metaobject.GetMetaByColumnName(this._paramnameoutput), this._paramnameupdate);
var parameters = ExConvert.Data2SqlParam(data, this._metaobject, pOriginal).ToArray();
this._db.Database.ExecuteSqlCommand(this._storeNameU, parameters);
return(data.ExpenseID);
}
catch (Exception)
{
throw;
}
}
public int Update(Models.GapField data)
{
try
{
this.Validate(data);
data.ModifiedBy = GlobalVariant.GetAppUser().UserID;
data.ModifiedDateTime = DateTime.Now;
var _data = this.GetById2(data.FieldId);
this.MapView2Table(data, _data);
this._db.Entry(_data).State = System.Data.Entity.EntityState.Modified;
this._db.SaveChanges();
return(data.FieldId);
}
catch (Exception)
{
throw;
}
}
//public string EncryptPassWord(string username,string password)
//{
// return Accounting.Services.MD5.GenerateHashDigest(username + password);
//}
public int Insert(Models.SysUserView data)
{
try
{
this.Validate(data);
data.CreatedBy = GlobalVariant.GetAppUser().UserID;
data.CreatedDateTime = DateTime.Now;
data.Password = Accounting.Services.MD5.GenerateHashDigest(data.Name + data.Password);
SqlParameter[] parameters = ExConvert.Data2SqlParam(data, this._metaobject, this._paramnameoutput).ToArray();
this._db.Database.ExecuteSqlCommand(this._storeNameI, parameters);
return((int)parameters.GetValueSqlParam(this._paramnameoutput));
}
catch (Exception)
{
throw;
}
}
public void BeginUpdate(Models.GapJournalCare data)
{
if (data.ItemID != null)
{
var measurerate = Services.Voucher.GetMeasureRate(data.UOMID, data.ItemID);
data.Quantity = Decimal.Round((Decimal)data.Quantity0 * (Decimal)measurerate, int.Parse(GlobalVariant.GetSysOption()["RoundQuantity"].ToString()));
}
//this._db.SaveChanges();
}
public int Update(Models.AppFixedAssetView data)
{
try
{
this.Validate(data);
data.ModifiedBy = GlobalVariant.GetAppUser().UserID;
data.ModifiedDateTime = DateTime.Now;
SqlParameter pOriginal = ExConvert.ParseSqlParam(data, this._metaobject.GetMetaByColumnName(this._paramnameoutput), this._paramnameupdate);
var parameters = ExConvert.Data2SqlParam(data, this._metaobject, pOriginal).ToArray();
this._db.Database.ExecuteSqlCommand(this._storeNameU, parameters);
#region Xử lý line
this._metaobject = Services.GlobalMeta.GetMetaObject(this._metalinename);
var AppFixedAssetLineTables = data.AppFixedAssetLineTables.ToList();
var AppFixedAssetLineTablez = data.AppFixedAssetLineTablez.ToList();
for (int i = 0; i < AppFixedAssetLineTables.Count; i++)
{
var itemz = AppFixedAssetLineTablez[i];
var item = AppFixedAssetLineTables[i];
if (itemz != -1)
{
//có 2 trường hợp: 1 - thêm mới thường DocumentLineID==0, 2 - sửa dữ liệu cũ DocumentLineID<>0
item.FixedAssetID = data.FixedAssetID;
if (item.FixedAssetLineID == 0)
{
this.InsertLine(item);
}
else
{
this.UpdateLine(item);
}
}
else
{
//nếu xóa có 2 trường hợp : 1 - xóa dữ liệu có trước DocumentLineID<>0, 2 - xóa dữ liệu mới thêm DocumentLineID ==0
if (item.FixedAssetLineID > 0)
{
this.DeleteLine(item.FixedAssetLineID);
}
}
}
#endregion
#region Xử lý thuế
if (data.AppEquipmentTables != null)
{
this._metaobject = Services.GlobalMeta.GetMetaObject(this._metavatname);
var AppEquipmentTables = data.AppEquipmentTables.ToList();
var AppEquipmentTablez = data.AppEquipmentTablez.ToList();
for (int i = 0; i < AppEquipmentTables.Count; i++)
{
var itemz = AppEquipmentTablez[i];
var item = AppEquipmentTables[i];
if (itemz != -1)
{
//có 2 trường hợp: 1 - thêm mới thường DocumentLineID==0, 2 - sửa dữ liệu cũ DocumentLineID<>0
item.FixedAssetID = data.FixedAssetID;
if (item.EquipmentID == 0)
{
this.InsertVAT(item);
}
else
{
this.UpdateVAT(item);
}
}
else
{
//nếu xóa có 2 trường hợp : 1 - xóa dữ liệu có trước DocumentLineID<>0, 2 - xóa dữ liệu mới thêm DocumentLineID ==0
if (item.EquipmentID > 0)
{
this.DeleteVAT(item.EquipmentID);
}
}
}
}
#endregion
return(data.FixedAssetID);
}
catch (Exception)
{
throw;
}
}
public long Update(Models.AppVPO05View data)
{
try
{
this.ValidateUpdate(data);
this.Validate(data);
data.ModifiedBy = GlobalVariant.GetAppUser().UserID;
data.ModifiedDateTime = DateTime.Now;
SqlParameter pOriginal = ExConvert.ParseSqlParam(data, this._metaobject.GetMetaByColumnName(this._paramnamemasteroutput), this._paramnamemasterupdate);
var parameters = ExConvert.Data2SqlParam(data, this._metaobject, pOriginal).ToArray();
this._db.Database.ExecuteSqlCommand(this._storeNameU, parameters);
#region X? lý line
this._metaobject = Services.GlobalMeta.GetMetaObject(this._metalinename);
var appvpo05lineviews = data.AppVPO05LineViews.ToList();
var appvpo05lineviewz = data.AppVPO05LineViewz.ToList();
for (int i = 0; i < appvpo05lineviews.Count; i++)
{
var itemz = appvpo05lineviewz[i];
var item = appvpo05lineviews[i];
if (itemz != -1)
{
//có 2 tru?ng h?p: 1 - thêm m?i thu?ng DocumentLineID==0, 2 - s?a d? li?u cu DocumentLineID<>0
item.DocumentID = data.DocumentID;
//item.AccountDebitLineID = data.AccountDebitID;
item.AccountCreditLineID = data.AccountCreditID;
item.MeasureRate = item.MeasureRate ?? 1;
item.Quantity = item.Quantity0 * item.MeasureRate;
if (data.IsoCode == Services.GlobalVariant.GetSysOption()["IsoCode"].ToString())
{
//item.Debit = 0;
//item.Credit = 0;
//item.ExchangeRateLine = 0;
item.AmountFC = 0;
}
if (item.DocumentLineID == 0)
{
this.InsertLine(item);
}
else
{
this.UpdateLine(item);
}
}
else
{
//n?u xóa có 2 tru?ng h?p : 1 - xóa d? li?u có tru?c DocumentLineID<>0, 2 - xóa d? li?u m?i thêm DocumentLineID ==0
if (item.DocumentLineID > 0)
{
this.DeleteLine(item.DocumentLineID);
}
}
}
#endregion
#region X? lý thu?
if (data.AppVPO05VATViews != null)
{
this._metaobject = Services.GlobalMeta.GetMetaObject(this._metavatname);
var appvpo05vatviews = data.AppVPO05VATViews.ToList();
var appvpo05vatviewz = data.AppVPO05VATViewz.ToList();
for (int i = 0; i < appvpo05vatviews.Count; i++)
{
var itemz = appvpo05vatviewz[i];
var item = appvpo05vatviews[i];
if (itemz != -1)
{
//có 2 tru?ng h?p: 1 - thêm m?i thu?ng DocumentLineID==0, 2 - s?a d? li?u cu DocumentLineID<>0
item.DocumentID = data.DocumentID;
//item.AccountDebitLineID = data.AccountDebitID;
//item.AccountCreditLineID = data.AccountCreditID;
if (data.IsoCode == Services.GlobalVariant.GetSysOption()["IsoCode"].ToString())
{
item.AmountFC = 0;
item.AmountVATFC = 0;
}
if (item.DocumentVATID == 0)
{
this.InsertVAT(item);
}
else
{
this.UpdateVAT(item);
}
}
else
{
//n?u xóa có 2 tru?ng h?p : 1 - xóa d? li?u có tru?c DocumentLineID<>0, 2 - xóa d? li?u m?i thêm DocumentLineID ==0
if (item.DocumentVATID > 0)
{
this.DeleteVAT(item.DocumentVATID);
}
}
}
}
#endregion
this._metaobject = Services.GlobalMeta.GetMetaObject(this._metaname);
Services.Voucher.PostStoreProcedure(data.VoucherID, data.DocumentID);
return(data.DocumentID);
}
catch (Exception)
{
throw;
}
}
public long Insert(Models.AppVPO05View data)
{
try
{
data.DocumentID = 0;
//Ki?m tra thêm m?i ch?ng t? nhu trùng s? ho?c ngày khóa s?
this.ValidateInsert(data);
//Ki?m tra ki?u nh?p d? li?u
this.Validate(data);
#region x? lý master
data.CreatedBy = GlobalVariant.GetAppUser().UserID;
data.CreatedDateTime = DateTime.Now;
SqlParameter[] parameters = ExConvert.Data2SqlParam(data, this._metaobject, this._paramnamemasteroutput).ToArray();
this._db.Database.ExecuteSqlCommand(this._storeNameI, parameters);
data.DocumentID = (long)parameters.GetValueSqlParam(this._paramnamemasteroutput);
#endregion
#region X? lý line
this._metaobject = Services.GlobalMeta.GetMetaObject(this._metalinename);
var appvpo05lineviews = data.AppVPO05LineViews.ToList();
var appvpo05lineviewz = data.AppVPO05LineViewz.ToList();
for (int i = 0; i < appvpo05lineviews.Count; i++)
{
var itemz = appvpo05lineviewz[i];
if (itemz != -1)
{
var item = appvpo05lineviews[i];
item.DocumentID = data.DocumentID;
//item.AccountDebitLineID = data.AccountDebitID;
item.AccountCreditLineID = data.AccountCreditID;
item.MeasureRate = item.MeasureRate ?? 1;
item.Quantity = item.Quantity0 * item.MeasureRate;
if (data.IsoCode == Services.GlobalVariant.GetSysOption()["IsoCode"].ToString())
{
//item.Debit = 0;
//item.Credit = 0;
//item.ExchangeRateLine = 0;
item.AmountFC = 0;
}
this.InsertLine(item);
}
}
#endregion
#region X? lý VAT
if (data.AppVPO05VATViews != null)
{
this._metaobject = Services.GlobalMeta.GetMetaObject(this._metavatname);
var appvpo05vatviews = data.AppVPO05VATViews.ToList();
var appvpo05vatviewz = data.AppVPO05VATViewz.ToList();
for (int i = 0; i < appvpo05vatviews.Count; i++)
{
var itemz = appvpo05vatviewz[i];
if (itemz != -1)
{
var item = appvpo05vatviews[i];
item.DocumentID = data.DocumentID;
//item.AccountDebitLineID = data.AccountDebitID;
//item.AccountCreditLineID = data.AccountCreditID;
if (data.IsoCode == Services.GlobalVariant.GetSysOption()["IsoCode"].ToString())
{
item.AmountFC = 0;
item.AmountVATFC = 0;
}
this.InsertVAT(item);
}
}
}
#endregion
this._metaobject = Services.GlobalMeta.GetMetaObject(this._metaname);
//Post vào sổ sách
Services.Voucher.PostStoreProcedure(data.VoucherID, data.DocumentID);
//cập nhật số chứng từ
Services.Voucher.SaveVoucherNumber(data.VoucherID, data.VoucherNumber);
return(data.DocumentID);
}
catch (Exception)
{
throw;
}
}
public ActionResult GetDataChart(string datefrom, string dateto, int userid)
{
int topproduct = 10;
var _datefrom = Convert.ToDateTime(datefrom);
var _dateto = Convert.ToDateTime(dateto).EndOfDay();
object rows = null;
object rows2 = null;
object rows3 = null;
object results = null;
if ((GlobalVariant.GetAppUser().SysRole.IsAdmin || posadmin.Contains(GlobalVariant.GetAppUser().SysRole.Name.ToLower())) && userid == 0)
{
rows = _dataobject._db.Database.SqlQuery <RpResRevenue>(string.Format("sp_RpResRevenue '{0}','{1}'", _datefrom.ToString("yyyy-MM-dd HH:mm:ss"), _dateto.ToString("yyyy-MM-dd HH:mm:ss"))).ToList();
rows2 =
(
from row in _dataobject._db.ResOrderItemViews
join master in _dataobject._db.ResOrders on row.OrderId equals master.OrderId
where master.OrderDate >= _datefrom && master.OrderDate <= _dateto && master.OrderStatusId == 0
group row by new
{
row.ItemId,
row.ItemName
} into g
select new DoughNutChart()
{
label = g.Key.ItemName,
value = g.Sum(x => x.Amount)
}
).OrderByDescending(m => m.value).Take(topproduct).ToList();
rows3 =
(
from row in _dataobject._db.ResOrderItemViews
join master in _dataobject._db.ResOrders on row.OrderId equals master.OrderId
where master.OrderDate >= _datefrom && master.OrderDate <= _dateto && master.OrderStatusId == 0
group row by new
{
row.ItemId,
row.ItemName
} into g
select new DoughNutChart()
{
label = g.Key.ItemName,
value = g.Sum(x => x.Quantity)
}
).OrderByDescending(m => m.value).Take(topproduct).ToList();
}
else
{
int _userid = GlobalVariant.GetAppUser().UserID;
if ((GlobalVariant.GetAppUser().SysRole.IsAdmin || posadmin.Contains(GlobalVariant.GetAppUser().SysRole.Name.ToLower())) && userid > 0)
{
_userid = userid;
}
rows = _dataobject._db.Database.SqlQuery <RpResRevenue>(string.Format("sp_RpResRevenueByUser '{0}','{1}',{2}", _datefrom.ToString("yyyy-MM-dd HH:mm:ss"), _dateto.ToString("yyyy-MM-dd HH:mm:ss"), _userid)).ToList();
rows2 =
(
from row in _dataobject._db.ResOrderItemViews
join master in _dataobject._db.ResOrders on row.OrderId equals master.OrderId
where master.OrderDate >= _datefrom && master.OrderDate <= _dateto && master.OrderStatusId == 0 && master.ModifiedBy.Value == _userid
group row by new
{
row.ItemId,
row.ItemName
} into g
select new DoughNutChart()
{
label = g.Key.ItemName,
value = g.Sum(x => x.Amount)
}
).OrderByDescending(m => m.value).Take(topproduct).ToList();
rows3 =
(
from row in _dataobject._db.ResOrderItemViews
join master in _dataobject._db.ResOrders on row.OrderId equals master.OrderId
where master.OrderDate >= _datefrom && master.OrderDate <= _dateto && master.OrderStatusId == 0 && master.ModifiedBy.Value == _userid
group row by new
{
row.ItemId,
row.ItemName
} into g
select new DoughNutChart()
{
label = g.Key.ItemName,
value = g.Sum(x => x.Quantity)
}
).OrderByDescending(m => m.value).Take(topproduct).ToList();
}
results = (new { rows = rows, rows2 = rows2, rows3 = rows3 });
return(Json(results, JsonRequestBehavior.AllowGet));
}
public ActionResult GetReportResItem(string datefrom, string dateto, int userid, Models.Paging page)
{
var _datefrom = Convert.ToDateTime(datefrom);
var _dateto = Convert.ToDateTime(dateto).EndOfDay();
object rows = null;
object results = null;
int _userid = GlobalVariant.GetAppUser().UserID;
if ((GlobalVariant.GetAppUser().SysRole.IsAdmin || posadmin.Contains(GlobalVariant.GetAppUser().SysRole.Name.ToLower())) && userid > 0)
{
_userid = userid;
}
var query0 = from row in _dataobject._db.ResOrderItemViews
join item in _dataobject._db.AppItemTables on row.ItemId equals item.ItemID
join master in _dataobject._db.ResOrders on row.OrderId equals master.OrderId
where master.OrderDate >= _datefrom && master.OrderDate <= _dateto && master.OrderStatusId == 0 && master.ModifiedBy == _userid
orderby item.ItemGroupID, row.ItemName
group row by new { row.ItemId, row.ItemName }
into g
select new ReportResItem()
{
ItemId = g.Key.ItemId,
ItemName = g.Key.ItemName,
Quantity = g.Sum(x => x.Quantity),
Amount = g.Sum(x => x.Amount)
};
if ((GlobalVariant.GetAppUser().SysRole.IsAdmin || posadmin.Contains(GlobalVariant.GetAppUser().SysRole.Name.ToLower())) && userid == 0)
{
query0 = from row in _dataobject._db.ResOrderItemViews
join item in _dataobject._db.AppItemTables on row.ItemId equals item.ItemID
join master in _dataobject._db.ResOrders on row.OrderId equals master.OrderId
where master.OrderDate >= _datefrom && master.OrderDate <= _dateto && master.OrderStatusId == 0
orderby item.ItemGroupID, row.ItemName
group row by new { row.ItemId, row.ItemName }
into g
select new ReportResItem()
{
ItemId = g.Key.ItemId,
ItemName = g.Key.ItemName,
Quantity = g.Sum(x => x.Quantity),
Amount = g.Sum(x => x.Amount)
};
}
var query = (from row in query0
join item in _dataobject._db.AppItemTables on row.ItemId equals item.ItemID
orderby item.ItemGroupID, row.ItemName
select row);
if (page != null)
{
page.TotalRows = query.Count();
page.SetPaging(page.TotalRows, page.PageCurrent);
rows = query.Skip(page.Skip).Take(page.PageSize).ToList();
}
else
{
page = new Models.Paging();
rows = query.ToList();
}
results = (new { rows = rows, page = page });
return(Json(results, JsonRequestBehavior.AllowGet));
}
public int Insert(Models.ResOrderView data)
{
try
{
var tablewait = this.GetTable(data.TableId ?? 0);
if (tablewait != null)
{
throw new Exception("Bàn này đã có người rồi!");
}
//if (data.ResOrderItemViewz == null) throw new Exception("Phải nhập chi tiết!");
//var countline = data.ResOrderItemViewz.Where(m => m != -1).Count();
//if (countline == 0) throw new Exception("Phải nhập chi tiết!");
this.Validate(data);
data.CreatedBy = GlobalVariant.GetAppUser().UserID;
data.CreatedDateTime = DateTime.Now;
data.ModifiedBy = GlobalVariant.GetAppUser().UserID;
data.ModifiedDateTime = DateTime.Now;
var _data = new Models.ResOrder();
this.MapView2Table(data, _data);
this._db.ResOrders.Add(_data);
this._db.SaveChanges();
if (data.ResOrderItemViewz == null)
{
return(_data.OrderId);
}
var countline = data.ResOrderItemViewz.Where(m => m != -1).Count();
if (countline == 0)
{
return(_data.OrderId);
}
var lines = data.ResOrderItemViews.ToList();
var linez = data.ResOrderItemViewz.ToList();
DateTime _curDate = DateTime.Now;
for (int i = 0; i < lines.Count; i++)
{
var itemz = linez[i];
if (itemz != -1)
{
var item = lines[i];
item.OrderId = _data.OrderId;
item.CreateDate = _curDate;
this.InsertLine(item);
}
}
return(_data.OrderId);
}
catch (Exception)
{
throw;
}
}
public bool IsDelete(int id)
{
return(Roles.IsUserInRole("Admin") || this.posadmin.Contains(GlobalVariant.GetAppUser().SysRole.Name.ToLower()));
}
public bool IsEdit(int id)
{
var data = GetById(id);
var OrderDate = data.OrderDate; //data.GetType().GetProperty("OrderDate").GetValue(data, null) ?? String.Empty;
var begindate = DateTime.Now.AddHours(-12);
var IsAdmin = Roles.IsUserInRole("Admin") || Roles.IsUserInRole("POSAdmin") || this.posadmin.Contains(GlobalVariant.GetAppUser().SysRole.Name.ToLower());
if ((DateTime)OrderDate < begindate && !IsAdmin)
{
return(false);
}
return(true);
}
public int Update(Models.ResOrderView data)
{
try
{
if (data.ResOrderItemViewz == null)
{
throw new Exception("Phải nhập chi tiết!");
}
var countline = data.ResOrderItemViewz.Where(m => m != -1).Count();
if (countline == 0)
{
throw new Exception("Phải nhập chi tiết!");
}
this.Validate(data);
var _data = this.GetById2(data.OrderId);
data.ModifiedBy = GlobalVariant.GetAppUser().UserID;
data.ModifiedDateTime = DateTime.Now;
data.CreatedBy = _data.CreatedBy;
data.CreatedDateTime = _data.CreatedDateTime;
this.MapView2Table(data, _data);
this._db.Entry(_data).State = System.Data.Entity.EntityState.Modified;
this._db.SaveChanges();
#region Xử lý line
var lines = data.ResOrderItemViews.ToList();
var linez = data.ResOrderItemViewz.ToList();
DateTime _curDate = DateTime.Now;
for (int i = 0; i < lines.Count; i++)
{
var itemz = linez[i];
var item = lines[i];
if (itemz != -1)
{
//có 2 tru?ng h?p: 1 - thêm m?i thu?ng DocumentOrderItemId==0, 2 - s?a d? li?u cu DocumentOrderItemId<>0
item.OrderId = _data.OrderId;
if (item.OrderItemId == 0)
{
item.CreateDate = _curDate;
this.InsertLine(item);
}
else
{
this.UpdateLine(item);
}
}
else
{
//n?u xóa có 2 tru?ng h?p : 1 - xóa d? li?u có tru?c DocumentOrderItemId<>0, 2 - xóa d? li?u m?i thêm DocumentOrderItemId ==0
if (item.OrderId > 0)
{
this.DeleteLine(item.OrderItemId);
}
}
}
#endregion
return(data.OrderId);
}
catch (Exception)
{
throw;
}
}
