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 ActionResult Add()
{
var userId = User.Identity.GetUserId();
var UserInfo = _unitOfWork.User.GetMyInfo(userId);
var Company = _unitOfWork.Company.GetMyCompany(UserInfo.fCompanyId);
int RegisterCase = _unitOfWork.NativeSql.GetSt_RegisterValueByRegisterID(UserInfo.fCompanyId, 1);
St_WarehouseVM Obj = new St_WarehouseVM
{
WorkWithCostCenter = Company.WorkWithCostCenter,
InventoryType = RegisterCase
};
return(PartialView(Obj));
}
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 ActionResult Delete(string id)
{
try
{
if (id != "")
{
var userId = User.Identity.GetUserId();
var UserInfo = _unitOfWork.User.GetUserByID(userId);
var Company = _unitOfWork.Company.GetMyCompany(UserInfo.fCompanyId);
int RegisterCase = _unitOfWork.NativeSql.GetSt_RegisterValueByRegisterID(UserInfo.fCompanyId, 1);
if (UserInfo == null)
{
RedirectToAction("", "");
}
var Obj = _unitOfWork.St_Warehouse.GetSt_WarehouseByID(UserInfo.fCompanyId, id);
var St_WarehouseObj = new St_WarehouseVM {
};
St_WarehouseObj.StockCode = Obj.StockCode;
St_WarehouseObj.ArabicName = Obj.ArabicName;
St_WarehouseObj.EnglishName = Obj.EnglishName;
St_WarehouseObj.Telephone = Obj.Telephone;
St_WarehouseObj.Address = Obj.Address;
St_WarehouseObj.AccountNumber = Obj.AccountNumber;
St_WarehouseObj.AccountName = _unitOfWork.NativeSql.GetAccountName(UserInfo.fCompanyId, St_WarehouseObj.AccountNumber);
St_WarehouseObj.CostCenterNumber = Obj.CostCenterNumber;
St_WarehouseObj.CostCenterName = _unitOfWork.NativeSql.GetCostCenterName(UserInfo.fCompanyId, St_WarehouseObj.CostCenterNumber);
St_WarehouseObj.WorkWithCostCenter = Company.WorkWithCostCenter;
St_WarehouseObj.InventoryType = RegisterCase;
return(PartialView("Delete", St_WarehouseObj));
}
return(PartialView("Delete", new St_WarehouseVM()));
}
catch (Exception ex)
{
ViewBag.Error = ex.Message.ToString();
return(View("Error"));
}
}
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));
}
}
