public void Delete(St_Warehouse ObjDelete)
{
var ObjToDelete = Context.St_Warehouses.SingleOrDefault(m => m.CompanyID == ObjDelete.CompanyID && m.StockCode == ObjDelete.StockCode);
if (ObjToDelete != null)
{
Context.St_Warehouses.Remove(ObjToDelete);
}
}
public JsonResult Update(St_WarehouseVM ObjUpdate)
{
MsgUnit Msg = new MsgUnit();
try
{
var userId = User.Identity.GetUserId();
var UserInfo = _unitOfWork.User.GetMyInfo(userId);
var ObjUpdateWarehouse = new St_Warehouse();
ObjUpdateWarehouse.InsDateTime = DateTime.Now;
ObjUpdateWarehouse.InsUserID = userId;
ObjUpdateWarehouse.CompanyID = UserInfo.fCompanyId;
ObjUpdateWarehouse.StockCode = ObjUpdate.StockCode;
ObjUpdateWarehouse.AccountNumber = ObjUpdate.AccountNumber;
ObjUpdateWarehouse.CostCenterNumber = ObjUpdate.CostCenterNumber;
ObjUpdateWarehouse.Telephone = ObjUpdate.Telephone;
ObjUpdateWarehouse.Address = ObjUpdate.Address;
ObjUpdateWarehouse.ArabicName = ObjUpdate.ArabicName;
if (String.IsNullOrEmpty(ObjUpdate.EnglishName))
{
ObjUpdateWarehouse.EnglishName = ObjUpdateWarehouse.ArabicName;
}
else
{
ObjUpdateWarehouse.EnglishName = ObjUpdate.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));
}
_unitOfWork.St_Warehouse.Update(ObjUpdateWarehouse);
_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 Update(St_Warehouse ObjUpdate)
{
var ObjToUpdate = Context.St_Warehouses.FirstOrDefault(m => m.CompanyID == ObjUpdate.CompanyID && m.StockCode == ObjUpdate.StockCode);
if (ObjToUpdate != null)
{
ObjToUpdate.ArabicName = ObjUpdate.ArabicName;
ObjToUpdate.EnglishName = ObjUpdate.EnglishName;
ObjToUpdate.AccountNumber = ObjUpdate.AccountNumber;
ObjToUpdate.CostCenterNumber = ObjUpdate.CostCenterNumber;
ObjToUpdate.Address = ObjUpdate.Address;
ObjToUpdate.Telephone = ObjUpdate.Telephone;
ObjToUpdate.InsDateTime = ObjUpdate.InsDateTime;
ObjToUpdate.InsUserID = ObjUpdate.InsUserID;
}
}
public JsonResult Delete(St_WarehouseVM ObjDelete)
{
MsgUnit Msg = new MsgUnit();
try
{
var userId = User.Identity.GetUserId();
var UserInfo = _unitOfWork.User.GetMyInfo(userId);
ObjDelete.CompanyID = UserInfo.fCompanyId;
var ObjDeleteSt_Warehouse = new St_Warehouse();
ObjDeleteSt_Warehouse.CompanyID = UserInfo.fCompanyId;
ObjDeleteSt_Warehouse.StockCode = ObjDelete.StockCode;
var ObjDeleteSt_WarehouseAccount = new St_WarehouseAccount();
ObjDeleteSt_Warehouse.CompanyID = UserInfo.fCompanyId;
ObjDeleteSt_Warehouse.StockCode = ObjDelete.StockCode;
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));
}
_unitOfWork.NativeSql.DeleteSt_CompanyTransactionKind(ObjDeleteSt_Warehouse.CompanyID, ObjDeleteSt_Warehouse.StockCode);
_unitOfWork.NativeSql.DeleteSt_ItemWarehouseByStockCode(ObjDeleteSt_Warehouse.CompanyID, ObjDeleteSt_Warehouse.StockCode);
_unitOfWork.St_WarehouseAccount.Delete(ObjDeleteSt_WarehouseAccount);
_unitOfWork.St_Warehouse.Delete(ObjDeleteSt_Warehouse);
_unitOfWork.Complete();
Msg.Code = 1;
Msg.Msg = Resources.Resource.DeletedSuccessfully;
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 Save(St_WarehouseVM ObjSave)
{
MsgUnit Msg = new MsgUnit();
try
{
var userId = User.Identity.GetUserId();
var UserInfo = _unitOfWork.User.GetMyInfo(userId);
var ObjSaveWarehouse = new St_Warehouse();
ObjSaveWarehouse.InsDateTime = DateTime.Now;
ObjSaveWarehouse.InsUserID = userId;
ObjSaveWarehouse.CompanyID = UserInfo.fCompanyId;
ObjSaveWarehouse.StockCode = ObjSave.StockCode;
ObjSaveWarehouse.AccountNumber = ObjSave.AccountNumber;
ObjSaveWarehouse.CostCenterNumber = ObjSave.CostCenterNumber;
ObjSaveWarehouse.Telephone = ObjSave.Telephone;
ObjSaveWarehouse.Address = ObjSave.Address;
ObjSaveWarehouse.ArabicName = ObjSave.ArabicName;
if (String.IsNullOrEmpty(ObjSave.EnglishName))
{
ObjSaveWarehouse.EnglishName = ObjSaveWarehouse.ArabicName;
}
else
{
ObjSaveWarehouse.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_TransactionKindAllStockTransaction(UserInfo.fCompanyId);
if (St_TransactionAllStockTransaction.Count() == 0)
{
St_TransactionAllStockTransaction = _unitOfWork.NativeSql.GetSt_TransactionKind();
foreach (var SaveSt_TransactionAllStockTransaction in St_TransactionAllStockTransaction)
{
var St_CompanyTransationKindObj = new St_CompanyTransactionKind();
St_CompanyTransationKindObj.CompanyID = UserInfo.fCompanyId;
St_CompanyTransationKindObj.St_CompanyTransactionKindID = _unitOfWork.St_CompanyTransactionKind.GetMaxSerial(UserInfo.fCompanyId);
St_CompanyTransationKindObj.St_TransactionKindID = SaveSt_TransactionAllStockTransaction.St_TransactionKindID;
St_CompanyTransationKindObj.StockCode = "*";
St_CompanyTransationKindObj.AutoSerial = true;
St_CompanyTransationKindObj.SymbolSerial = false;
St_CompanyTransationKindObj.Symbol = "";
St_CompanyTransationKindObj.Serial = 0;
St_CompanyTransationKindObj.InsUserID = userId;
St_CompanyTransationKindObj.InsDateTime = DateTime.Now;
_unitOfWork.St_CompanyTransactionKind.Add(St_CompanyTransationKindObj);
_unitOfWork.Complete();
}
}
var St_TransactionAllWithoutStockTransaction = _unitOfWork.NativeSql.GetSt_TransactionKindWithoutAllStockTransaction();
foreach (var SaveSt_TransactionWithoutAllStockTransaction in St_TransactionAllWithoutStockTransaction)
{
var St_CompanyTransationKindObj = new St_CompanyTransactionKind();
St_CompanyTransationKindObj.CompanyID = UserInfo.fCompanyId;
St_CompanyTransationKindObj.St_CompanyTransactionKindID = _unitOfWork.St_CompanyTransactionKind.GetMaxSerial(UserInfo.fCompanyId);
St_CompanyTransationKindObj.St_TransactionKindID = SaveSt_TransactionWithoutAllStockTransaction.St_TransactionKindID;
St_CompanyTransationKindObj.StockCode = ObjSaveWarehouse.StockCode;
St_CompanyTransationKindObj.AutoSerial = true;
St_CompanyTransationKindObj.SymbolSerial = false;
St_CompanyTransationKindObj.Symbol = "";
St_CompanyTransationKindObj.Serial = 0;
St_CompanyTransationKindObj.InsUserID = userId;
St_CompanyTransationKindObj.InsDateTime = DateTime.Now;
_unitOfWork.St_CompanyTransactionKind.Add(St_CompanyTransationKindObj);
_unitOfWork.Complete();
}
_unitOfWork.St_Warehouse.Add(ObjSaveWarehouse);
_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 void Add(St_Warehouse ObjSave)
{
Context.St_Warehouses.Add(ObjSave);
}
