Пример #1
0
        public void Delete(St_WarehouseH ObjDelete)
        {
            var ObjToDelete = Context.St_WarehouseHs.SingleOrDefault(m => m.CompanyID == ObjDelete.CompanyID && m.StockCode == ObjDelete.StockCode);

            if (ObjToDelete != null)
            {
                Context.St_WarehouseHs.Remove(ObjToDelete);
            }
        }
Пример #2
0
        public JsonResult Update(St_WarehouseHVM ObjUpdate)
        {
            MsgUnit Msg = new MsgUnit();

            try
            {
                var userId              = User.Identity.GetUserId();
                var UserInfo            = _unitOfWork.User.GetMyInfo(userId);
                var ObjUpdateWarehouseH = new St_WarehouseH();
                ObjUpdateWarehouseH.InsDateTime            = DateTime.Now;
                ObjUpdateWarehouseH.InsUserID              = userId;
                ObjUpdateWarehouseH.CompanyID              = UserInfo.fCompanyId;
                ObjUpdateWarehouseH.StockCode              = ObjUpdate.StockCode;
                ObjUpdateWarehouseH.Telephone              = ObjUpdate.Telephone;
                ObjUpdateWarehouseH.Address                = ObjUpdate.Address;
                ObjUpdateWarehouseH.ArabicName             = ObjUpdate.ArabicName;
                ObjUpdateWarehouseH.ManufacturingWarehouse = ObjUpdate.ManufacturingWarehouse;
                if (String.IsNullOrEmpty(ObjUpdate.EnglishName))
                {
                    ObjUpdateWarehouseH.EnglishName = ObjUpdateWarehouseH.ArabicName;
                }
                else
                {
                    ObjUpdateWarehouseH.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_WarehouseH.Update(ObjUpdateWarehouseH);
                _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));
            }
        }
Пример #3
0
        public void Update(St_WarehouseH ObjUpdate)
        {
            var ObjToUpdate = Context.St_WarehouseHs.FirstOrDefault(m => m.CompanyID == ObjUpdate.CompanyID && m.StockCode == ObjUpdate.StockCode);

            if (ObjToUpdate != null)
            {
                ObjToUpdate.ArabicName             = ObjUpdate.ArabicName;
                ObjToUpdate.EnglishName            = ObjUpdate.EnglishName;
                ObjToUpdate.Address                = ObjUpdate.Address;
                ObjToUpdate.Telephone              = ObjUpdate.Telephone;
                ObjToUpdate.InsDateTime            = ObjUpdate.InsDateTime;
                ObjToUpdate.InsUserID              = ObjUpdate.InsUserID;
                ObjToUpdate.ManufacturingWarehouse = ObjUpdate.ManufacturingWarehouse;
            }
        }
Пример #4
0
        public JsonResult Delete(St_WarehouseHVM ObjDelete)
        {
            MsgUnit Msg = new MsgUnit();

            try
            {
                var userId   = User.Identity.GetUserId();
                var UserInfo = _unitOfWork.User.GetMyInfo(userId);

                ObjDelete.CompanyID = UserInfo.fCompanyId;
                var ObjDeleteSt_WarehouseH = new St_WarehouseH();
                ObjDeleteSt_WarehouseH.CompanyID = UserInfo.fCompanyId;
                ObjDeleteSt_WarehouseH.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_CompanyTransactionKindH(ObjDeleteSt_WarehouseH.CompanyID, ObjDeleteSt_WarehouseH.StockCode);
                _unitOfWork.NativeSql.DeleteSt_ItemWarehouseHByStockCode(ObjDeleteSt_WarehouseH.CompanyID, ObjDeleteSt_WarehouseH.StockCode);
                _unitOfWork.St_WarehouseH.Delete(ObjDeleteSt_WarehouseH);
                _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));
            }
        }
Пример #5
0
        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));
            }
        }
Пример #6
0
 public void Add(St_WarehouseH ObjSave)
 {
     Context.St_WarehouseHs.Add(ObjSave);
 }