public void Update(St_CompanyTransactionKindH ObjUpdate)
{
var ObjToUpdate = _context.St_CompanyTransactionKindHs.FirstOrDefault(m => m.CompanyID == ObjUpdate.CompanyID && m.St_CompanyTransactionKindID == ObjUpdate.St_CompanyTransactionKindID);
if (ObjToUpdate != null)
{
ObjToUpdate.AutoSerial = ObjUpdate.AutoSerial;
ObjToUpdate.SymbolSerial = ObjUpdate.SymbolSerial;
ObjToUpdate.Symbol = ObjUpdate.Symbol;
ObjToUpdate.Serial = ObjUpdate.Serial;
ObjToUpdate.StockCode = ObjUpdate.StockCode;
ObjToUpdate.InsDateTime = ObjUpdate.InsDateTime;
ObjToUpdate.InsUserID = ObjUpdate.InsUserID;
}
}
public JsonResult Save(St_WarehouseHVM ObjSave)
{
MsgUnit Msg = new MsgUnit();
try
{
var userId = User.Identity.GetUserId();
var UserInfo = _unitOfWork.User.GetMyInfo(userId);
var ObjSaveWarehouseH = new St_WarehouseH();
ObjSaveWarehouseH.InsDateTime = DateTime.Now;
ObjSaveWarehouseH.InsUserID = userId;
ObjSaveWarehouseH.CompanyID = UserInfo.fCompanyId;
ObjSaveWarehouseH.StockCode = ObjSave.StockCode;
ObjSaveWarehouseH.Telephone = ObjSave.Telephone;
ObjSaveWarehouseH.Address = ObjSave.Address;
ObjSaveWarehouseH.ArabicName = ObjSave.ArabicName;
ObjSaveWarehouseH.ManufacturingWarehouse = ObjSave.ManufacturingWarehouse;
if (String.IsNullOrEmpty(ObjSave.EnglishName))
{
ObjSaveWarehouseH.EnglishName = ObjSaveWarehouseH.ArabicName;
}
else
{
ObjSaveWarehouseH.EnglishName = ObjSave.EnglishName;
}
if (!ModelState.IsValid)
{
string Err = " ";
var errors = ModelState.Values.SelectMany(v => v.Errors);
foreach (ModelError error in errors)
{
Err = Err + error.ErrorMessage + " * ";
}
Msg.Msg = Resources.Resource.SomthingWentWrong + " : " + Err;
Msg.Code = 0;
return(Json(Msg, JsonRequestBehavior.AllowGet));
}
var St_TransactionAllStockTransaction = _unitOfWork.NativeSql.GetSt_TransactionKindHAllStockTransaction(UserInfo.fCompanyId);
if (St_TransactionAllStockTransaction.Count() == 0)
{
St_TransactionAllStockTransaction = _unitOfWork.NativeSql.GetSt_TransactionKindH();
foreach (var SaveSt_TransactionAllStockTransaction in St_TransactionAllStockTransaction)
{
var St_CompanyTransationKindHObj = new St_CompanyTransactionKindH();
St_CompanyTransationKindHObj.CompanyID = UserInfo.fCompanyId;
St_CompanyTransationKindHObj.St_CompanyTransactionKindID = _unitOfWork.St_CompanyTransactionKindH.GetMaxSerial(UserInfo.fCompanyId);
St_CompanyTransationKindHObj.St_TransactionKindID = SaveSt_TransactionAllStockTransaction.St_TransactionKindID;
St_CompanyTransationKindHObj.StockCode = "*";
St_CompanyTransationKindHObj.AutoSerial = true;
St_CompanyTransationKindHObj.SymbolSerial = false;
St_CompanyTransationKindHObj.Symbol = "";
St_CompanyTransationKindHObj.Serial = 0;
St_CompanyTransationKindHObj.InsUserID = userId;
St_CompanyTransationKindHObj.InsDateTime = DateTime.Now;
_unitOfWork.St_CompanyTransactionKindH.Add(St_CompanyTransationKindHObj);
_unitOfWork.Complete();
}
}
var St_TransactionAllWithoutStockTransaction = _unitOfWork.NativeSql.GetSt_TransactionKindHWithoutAllStockTransaction();
foreach (var SaveSt_TransactionWithoutAllStockTransaction in St_TransactionAllWithoutStockTransaction)
{
var St_CompanyTransationKindHObj = new St_CompanyTransactionKindH();
St_CompanyTransationKindHObj.CompanyID = UserInfo.fCompanyId;
St_CompanyTransationKindHObj.St_CompanyTransactionKindID = _unitOfWork.St_CompanyTransactionKindH.GetMaxSerial(UserInfo.fCompanyId);
St_CompanyTransationKindHObj.St_TransactionKindID = SaveSt_TransactionWithoutAllStockTransaction.St_TransactionKindID;
St_CompanyTransationKindHObj.StockCode = ObjSaveWarehouseH.StockCode;
St_CompanyTransationKindHObj.AutoSerial = true;
St_CompanyTransationKindHObj.SymbolSerial = false;
St_CompanyTransationKindHObj.Symbol = "";
St_CompanyTransationKindHObj.Serial = 0;
St_CompanyTransationKindHObj.InsUserID = userId;
St_CompanyTransationKindHObj.InsDateTime = DateTime.Now;
_unitOfWork.St_CompanyTransactionKindH.Add(St_CompanyTransationKindHObj);
_unitOfWork.Complete();
}
var St_ItemWarehouse = _unitOfWork.NativeSql.GetSt_ItemWarehouseH(UserInfo.fCompanyId);
foreach (var SaveSt_ItemWarehouse in St_ItemWarehouse)
{
var St_ItemWarehouseHObj = new St_ItemWarehouseH();
St_ItemWarehouseHObj.CompanyID = UserInfo.fCompanyId;
St_ItemWarehouseHObj.ItemCode = SaveSt_ItemWarehouse.ItemCode;
St_ItemWarehouseHObj.StockCode = ObjSaveWarehouseH.StockCode;
St_ItemWarehouseHObj.RowNumber = SaveSt_ItemWarehouse.ItemWarehouseRowNumber + 1;
_unitOfWork.St_ItemCardH.AddItemWarehous(St_ItemWarehouseHObj);
_unitOfWork.Complete();
}
_unitOfWork.St_WarehouseH.Add(ObjSaveWarehouseH);
_unitOfWork.Complete();
Msg.Code = 1;
Msg.Msg = Resources.Resource.AddedSuccessfully;
return(Json(Msg, JsonRequestBehavior.AllowGet));
}
catch (Exception ex)
{
Msg.Msg = Resources.Resource.SomthingWentWrong + " : " + ex.Message.ToString();
Msg.Code = 0;
return(Json(Msg, JsonRequestBehavior.AllowGet));
}
}
public JsonResult UpdateSt_CompanyTransactionKindH(St_CompanyTransactionKindH ObjUpdate)
{
MsgUnit Msg = new MsgUnit();
try
{
var userId = User.Identity.GetUserId();
var UserInfo = _unitOfWork.User.GetMyInfo(userId);
ObjUpdate.CompanyID = UserInfo.fCompanyId;
ObjUpdate.InsDateTime = DateTime.Now;
ObjUpdate.InsUserID = userId;
if (!ModelState.IsValid)
{
string Err = " ";
var errors = ModelState.Values.SelectMany(v => v.Errors);
foreach (ModelError error in errors)
{
Err = Err + error.ErrorMessage + " * ";
}
Msg.Msg = Resources.Resource.SomthingWentWrong + " : " + Err;
Msg.Code = 0;
return(Json(Msg, JsonRequestBehavior.AllowGet));
}
if (ObjUpdate.SymbolSerial)
{
var Obj = new St_CompanyTransactionKindSymbolSerialH();
var CheckIfSave = _unitOfWork.St_CompanyTransactionKindSymbolSerialH.CheckIfSave(ObjUpdate.CompanyID, ObjUpdate.St_CompanyTransactionKindID);
if (CheckIfSave == null)
{
_unitOfWork.St_CompanyTransactionKindSymbolSerialH.Delete(ObjUpdate.CompanyID, ObjUpdate.St_CompanyTransactionKindID);
_unitOfWork.Complete();
Obj.CompanyID = ObjUpdate.CompanyID;
Obj.StockCode = ObjUpdate.StockCode;
Obj.St_CompanyTransactionKindID = ObjUpdate.St_CompanyTransactionKindID;
Obj.LastSerial = 0;
_unitOfWork.St_CompanyTransactionKindSymbolSerialH.Add(Obj);
_unitOfWork.Complete();
}
}
else
{
var Obj = new St_CompanyTransactionKindSymbolSerialH();
var CheckIfSave = _unitOfWork.St_CompanyTransactionKindSymbolSerialH.CheckIfSave(ObjUpdate.CompanyID, ObjUpdate.St_CompanyTransactionKindID);
if (CheckIfSave != null)
{
_unitOfWork.St_CompanyTransactionKindSymbolSerialH.Delete(ObjUpdate.CompanyID, ObjUpdate.St_CompanyTransactionKindID);
_unitOfWork.Complete();
}
}
_unitOfWork.St_CompanyTransactionKindH.Update(ObjUpdate);
_unitOfWork.Complete();
Msg.Code = 1;
Msg.Msg = Resources.Resource.UpdatedSuccessfully;
return(Json(Msg, JsonRequestBehavior.AllowGet));
}
catch (Exception ex)
{
Msg.Msg = Resources.Resource.SomthingWentWrong + " : " + ex.Message.ToString();
Msg.Code = 0;
return(Json(Msg, JsonRequestBehavior.AllowGet));
}
}
public void Add(St_CompanyTransactionKindH ObjSave)
{
_context.St_CompanyTransactionKindHs.Add(ObjSave);
}
