public ActionResult Delete(string id)
{
string UserID = User.Identity.GetUserId();
var UserInfo = _unitOfWork.User.GetMyInfo(UserID);
var Company = _unitOfWork.Company.GetMyCompany(UserInfo.fCompanyId);
var St_ItemCardObj = _unitOfWork.St_ItemCardH.GetSt_ItemCardById(id, UserInfo.fCompanyId);
var St_ItemCardHVMObj = new St_ItemCardHVM
{
St_FactoryH = _unitOfWork.St_FactoryH.GetAllSt_FactoryH(UserInfo.fCompanyId),
St_ItemGroupH = _unitOfWork.St_ItemGroupH.GetAllSt_ItemGroupH(UserInfo.fCompanyId),
St_ItemUnitH = _unitOfWork.St_ItemUnitH.GetAllSt_ItemUnitH(UserInfo.fCompanyId),
TheDecimalPointForTheLocalCurrency = Company.TheDecimalPointForTheLocalCurrency,
ItemSerial = St_ItemCardObj.ItemSerial,
ItemCode = St_ItemCardObj.ItemCode,
GroupCode = St_ItemCardObj.GroupCode,
ArabicName = St_ItemCardObj.ArabicName,
EnglishName = St_ItemCardObj.EnglishName,
NumberOfPieces = St_ItemCardObj.NumberOfPieces,
ReOrderLimit = St_ItemCardObj.ReOrderLimit,
OrderQuantity = St_ItemCardObj.OrderQuantity,
CBM = St_ItemCardObj.CBM,
ItemUnitNo = St_ItemCardObj.ItemUnitNo,
StyleNo = St_ItemCardObj.StyleNo,
ItemLevelNo = St_ItemCardObj.ItemLevelNo,
ItemTypeNo = St_ItemCardObj.ItemTypeNo,
SupplierAccountNumber = St_ItemCardObj.SupplierAccountNumber,
SupplierAccountName = _unitOfWork.NativeSql.GetAccountName(UserInfo.fCompanyId, St_ItemCardObj.SupplierAccountNumber),
ShowOnline = St_ItemCardObj.ShowOnline,
QuantityOnline = St_ItemCardObj.QuantityOnline,
StopItem = St_ItemCardObj.StopItem,
SaleOfOfferedArticleIsPermitted = St_ItemCardObj.SaleOfOfferedArticleIsPermitted,
FabricChangeIsAllowed = St_ItemCardObj.FabricChangeIsAllowed,
AllowWoodToChangeColor = St_ItemCardObj.AllowWoodToChangeColor,
ApprovingTheWarehouseQuantityLessThan = St_ItemCardObj.ApprovingTheWarehouseQuantityLessThan,
QuantityManufacturing = St_ItemCardObj.QuantityManufacturing,
SalePrice = St_ItemCardObj.SalePrice,
TaxTypeNo = St_ItemCardObj.TaxTypeNo,
TaxRate = St_ItemCardObj.TaxRate,
LocalCost = St_ItemCardObj.LocalCost,
ForeignCost = St_ItemCardObj.ForeignCost,
CostRate = St_ItemCardObj.CostRate,
TheTargetMonthlyAmount = St_ItemCardObj.TheTargetMonthlyAmount,
TheNumberOfDaysTheCardIsOpened = _unitOfWork.NativeSql.GetOpeningDateH(UserInfo.fCompanyId, St_ItemCardObj.ItemCode),
LastLocalPurchasePrice = 0,
LastForeignPurchasePrice = 0,
TotalQuantitySold = 0,
TotalValueSold = 0,
FactoryNo = St_ItemCardObj.FactoryNo,
FactoryNotes = St_ItemCardObj.FactoryNotes,
WageRate = St_ItemCardObj.WageRate,
NumberOfWorkingDays = St_ItemCardObj.NumberOfWorkingDays,
NumberOfStages = St_ItemCardObj.NumberOfStages,
NetTotal = St_ItemCardObj.NetTotal,
TotalQuantity = St_ItemCardObj.TotalQuantity,
TotalCost = St_ItemCardObj.TotalCost,
ItemLogo = St_ItemCardObj.ItemLogo
};
return(View(St_ItemCardHVMObj));
}
public JsonResult DeleteSt_ItemCardH(St_ItemCardHVM ObjToDelete)
{
MsgUnit Msg = new MsgUnit();
try
{
var userId = User.Identity.GetUserId();
var UserInfo = _unitOfWork.User.GetMyInfo(userId);
var deleteSt_ItemCard = new St_ItemCardH();
deleteSt_ItemCard.ItemCode = ObjToDelete.ItemCode;
_unitOfWork.NativeSql.DeleteSt_ItemCardH(UserInfo.fCompanyId, deleteSt_ItemCard.ItemCode);
_unitOfWork.NativeSql.DeleteSt_SimilarItemH(UserInfo.fCompanyId, deleteSt_ItemCard.ItemCode);
_unitOfWork.NativeSql.DeleteSt_RelatedItemH(UserInfo.fCompanyId, deleteSt_ItemCard.ItemCode);
_unitOfWork.NativeSql.DeleteSt_ManufacturingStageH(UserInfo.fCompanyId, deleteSt_ItemCard.ItemCode);
_unitOfWork.NativeSql.DeleteSt_RawMaterialH(UserInfo.fCompanyId, deleteSt_ItemCard.ItemCode);
_unitOfWork.NativeSql.DeleteSt_SubColorsItemH(UserInfo.fCompanyId, deleteSt_ItemCard.ItemCode);
_unitOfWork.NativeSql.DeleteSt_ItemWarehouseH(UserInfo.fCompanyId, deleteSt_ItemCard.ItemCode);
_unitOfWork.NativeSql.DeleteSt_ItemGallary(UserInfo.fCompanyId, deleteSt_ItemCard.ItemCode);
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.Complete();
string path = Path.Combine(new DirectoryInfo(string.Format(@"{0}ItemGallary\{1}", base.Server.MapPath(@"\"), deleteSt_ItemCard.ItemCode)).ToString());
string[] files = Directory.GetFiles(path);
foreach (string file in files)
{
System.IO.File.Delete(file);
}
Msg.Code = 1;
Msg.Msg = Resources.Resource.DeletedSuccessfully;
Msg.LastID = deleteSt_ItemCard.ItemCode;
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 Index()
{
var userId = User.Identity.GetUserId();
var UserInfo = _unitOfWork.User.GetMyInfo(userId);
var Company = _unitOfWork.Company.GetMyCompany(UserInfo.fCompanyId);
var St_ItemCardHObj = new St_ItemCardHVM
{
St_ItemGroupH = _unitOfWork.St_ItemGroupH.GetAllSt_ItemGroupH(UserInfo.fCompanyId),
TheDecimalPointForTheLocalCurrency = Company.TheDecimalPointForTheLocalCurrency
};
return(View(St_ItemCardHObj));
}
public ActionResult Add()
{
string UserID = User.Identity.GetUserId();
var UserInfo = _unitOfWork.User.GetMyInfo(UserID);
var Company = _unitOfWork.Company.GetMyCompany(UserInfo.fCompanyId);
var St_ItemCardHVMObj = new St_ItemCardHVM
{
St_FactoryH = _unitOfWork.St_FactoryH.GetAllSt_FactoryH(UserInfo.fCompanyId),
St_ItemGroupH = _unitOfWork.St_ItemGroupH.GetAllSt_ItemGroupH(UserInfo.fCompanyId),
St_ItemUnitH = _unitOfWork.St_ItemUnitH.GetAllSt_ItemUnitH(UserInfo.fCompanyId),
TheDecimalPointForTheLocalCurrency = Company.TheDecimalPointForTheLocalCurrency
};
return(View(St_ItemCardHVMObj));
}
public JsonResult GetAllSt_ItemCardH(St_ItemCardHVM Obj)
{
try
{
var userId = User.Identity.GetUserId();
var UserInfo = _unitOfWork.User.GetMyInfo(userId);
var AllSt_ItemCardH = _unitOfWork.NativeSql.GetAllSt_ItemCardHFilter(UserInfo.fCompanyId);
if (AllSt_ItemCardH == null)
{
return(Json(new List <St_ItemCardHVM>(), JsonRequestBehavior.AllowGet));
}
if (!String.IsNullOrEmpty(Obj.ItemCode))
{
AllSt_ItemCardH = AllSt_ItemCardH.Where(m => m.ItemCode.Contains(Obj.ItemCode)).ToList();
}
if (!String.IsNullOrEmpty(Obj.ItemName))
{
AllSt_ItemCardH = AllSt_ItemCardH.Where(m => m.ItemName.Contains(Obj.ItemName)).ToList();
}
if (!String.IsNullOrEmpty(Obj.SupplierAccountNumber))
{
AllSt_ItemCardH = AllSt_ItemCardH.Where(m => m.SupplierAccountNumber == Obj.SupplierAccountNumber).ToList();
}
if (!String.IsNullOrEmpty(Obj.GroupCode))
{
AllSt_ItemCardH = AllSt_ItemCardH.Where(m => m.GroupCode == Obj.GroupCode).ToList();
}
if (Obj.ItemCaseInt != 0)
{
AllSt_ItemCardH = AllSt_ItemCardH.Where(m => m.StopItem == Convert.ToBoolean(Obj.ItemCaseInt - 1)).ToList();
}
if (Obj.ItemTypeNo != 0)
{
AllSt_ItemCardH = AllSt_ItemCardH.Where(m => m.ItemTypeNo == Obj.ItemTypeNo).ToList();
}
return(Json(AllSt_ItemCardH, JsonRequestBehavior.AllowGet));
}
catch (Exception ex)
{
ViewBag.Error = ex.Message.ToString();
return(Json(new List <St_ItemCardHVM>(), JsonRequestBehavior.AllowGet));
}
}
public JsonResult UpdateSt_ItemCardH(St_ItemCardHVM ObjToUpdate)
{
MsgUnit Msg = new MsgUnit();
try
{
var userId = User.Identity.GetUserId();
var UserInfo = _unitOfWork.User.GetMyInfo(userId);
var updateSt_ItemCard = new St_ItemCardH();
updateSt_ItemCard.InsDateTime = DateTime.Now;
updateSt_ItemCard.OpeningDate = DateTime.Now;
updateSt_ItemCard.InsUserID = userId;
updateSt_ItemCard.CompanyID = UserInfo.fCompanyId;
updateSt_ItemCard.ArabicName = ObjToUpdate.ArabicName;
if (String.IsNullOrEmpty(ObjToUpdate.EnglishName))
{
updateSt_ItemCard.EnglishName = ObjToUpdate.ArabicName;
}
else
{
updateSt_ItemCard.EnglishName = ObjToUpdate.EnglishName;
}
updateSt_ItemCard.GroupCode = ObjToUpdate.GroupCode;
updateSt_ItemCard.NumberOfPieces = ObjToUpdate.NumberOfPieces;
updateSt_ItemCard.ReOrderLimit = ObjToUpdate.ReOrderLimit;
updateSt_ItemCard.OrderQuantity = ObjToUpdate.OrderQuantity;
updateSt_ItemCard.CBM = ObjToUpdate.CBM;
updateSt_ItemCard.ItemUnitNo = ObjToUpdate.ItemUnitNo;
updateSt_ItemCard.SupplierAccountNumber = ObjToUpdate.SupplierAccountNumber;
updateSt_ItemCard.StyleNo = ObjToUpdate.StyleNo;
updateSt_ItemCard.ItemLevelNo = ObjToUpdate.ItemLevelNo;
updateSt_ItemCard.StopItem = ObjToUpdate.StopItem;
updateSt_ItemCard.ShowOnline = ObjToUpdate.ShowOnline;
updateSt_ItemCard.QuantityOnline = ObjToUpdate.QuantityOnline;
updateSt_ItemCard.SaleOfOfferedArticleIsPermitted = ObjToUpdate.SaleOfOfferedArticleIsPermitted;
updateSt_ItemCard.ItemTypeNo = ObjToUpdate.ItemTypeNo;
updateSt_ItemCard.FactoryNo = ObjToUpdate.FactoryNo;
updateSt_ItemCard.NumberOfWorkingDays = ObjToUpdate.NumberOfWorkingDays;
updateSt_ItemCard.NumberOfStages = ObjToUpdate.NumberOfStages;
updateSt_ItemCard.WageRate = ObjToUpdate.WageRate;
updateSt_ItemCard.ApprovingTheWarehouseQuantityLessThan = ObjToUpdate.ApprovingTheWarehouseQuantityLessThan;
updateSt_ItemCard.QuantityManufacturing = ObjToUpdate.QuantityManufacturing;
updateSt_ItemCard.FabricChangeIsAllowed = ObjToUpdate.FabricChangeIsAllowed;
updateSt_ItemCard.AllowWoodToChangeColor = ObjToUpdate.AllowWoodToChangeColor;
updateSt_ItemCard.FactoryNotes = ObjToUpdate.FactoryNotes;
updateSt_ItemCard.SalePrice = ObjToUpdate.SalePrice;
updateSt_ItemCard.TaxRate = ObjToUpdate.TaxRate;
updateSt_ItemCard.TaxTypeNo = ObjToUpdate.TaxTypeNo;
updateSt_ItemCard.LocalCost = ObjToUpdate.LocalCost;
updateSt_ItemCard.ForeignCost = ObjToUpdate.ForeignCost;
updateSt_ItemCard.TotalCost = ObjToUpdate.TotalCost;
updateSt_ItemCard.TotalQuantity = ObjToUpdate.TotalQuantity;
updateSt_ItemCard.NetTotal = ObjToUpdate.NetTotal;
updateSt_ItemCard.TheTargetMonthlyAmount = ObjToUpdate.TheTargetMonthlyAmount;
updateSt_ItemCard.ItemSerial = ObjToUpdate.ItemSerial;
updateSt_ItemCard.ItemLogo = ObjToUpdate.ItemLogo;
updateSt_ItemCard.ItemCode = ObjToUpdate.ItemCode;
_unitOfWork.NativeSql.DeleteSt_ItemCardH(UserInfo.fCompanyId, updateSt_ItemCard.ItemCode);
_unitOfWork.NativeSql.DeleteSt_SimilarItemH(UserInfo.fCompanyId, updateSt_ItemCard.ItemCode);
_unitOfWork.NativeSql.DeleteSt_RelatedItemH(UserInfo.fCompanyId, updateSt_ItemCard.ItemCode);
_unitOfWork.NativeSql.DeleteSt_ManufacturingStageH(UserInfo.fCompanyId, updateSt_ItemCard.ItemCode);
_unitOfWork.NativeSql.DeleteSt_RawMaterialH(UserInfo.fCompanyId, updateSt_ItemCard.ItemCode);
_unitOfWork.NativeSql.DeleteSt_SubColorsItemH(UserInfo.fCompanyId, updateSt_ItemCard.ItemCode);
_unitOfWork.NativeSql.DeleteSt_ItemWarehouseH(UserInfo.fCompanyId, updateSt_ItemCard.ItemCode);
_unitOfWork.Complete();
if (ObjToUpdate.St_RelatedItemH != null)
{
foreach (var UpdateSt_RelatedItem in ObjToUpdate.St_RelatedItemH)
{
UpdateSt_RelatedItem.CompanyID = UserInfo.fCompanyId;
UpdateSt_RelatedItem.ItemCode = updateSt_ItemCard.ItemCode;
UpdateSt_RelatedItem.RelatedItemCode = UpdateSt_RelatedItem.RelatedItemCode;
UpdateSt_RelatedItem.RowNumber = UpdateSt_RelatedItem.RowNumber;
_unitOfWork.St_ItemCardH.AddRelatedItem(UpdateSt_RelatedItem);
}
}
if (ObjToUpdate.St_SimilarItemH != null)
{
foreach (var UpdateSt_SimilarItem in ObjToUpdate.St_SimilarItemH)
{
UpdateSt_SimilarItem.CompanyID = UserInfo.fCompanyId;
UpdateSt_SimilarItem.ItemCode = updateSt_ItemCard.ItemCode;
UpdateSt_SimilarItem.SimilarItemCode = UpdateSt_SimilarItem.SimilarItemCode;
UpdateSt_SimilarItem.RowNumber = UpdateSt_SimilarItem.RowNumber;
_unitOfWork.St_ItemCardH.AddSimilarItem(UpdateSt_SimilarItem);
}
}
if (updateSt_ItemCard.ItemTypeNo == 3)
{
foreach (var UpdateSt_ManufacturingStage in ObjToUpdate.St_ManufacturingStageH)
{
UpdateSt_ManufacturingStage.CompanyID = UserInfo.fCompanyId;
UpdateSt_ManufacturingStage.ItemCode = updateSt_ItemCard.ItemCode;
UpdateSt_ManufacturingStage.FactoryNo = UpdateSt_ManufacturingStage.FactoryNo;
UpdateSt_ManufacturingStage.RowNumber = UpdateSt_ManufacturingStage.RowNumber;
UpdateSt_ManufacturingStage.NumberOfDays = UpdateSt_ManufacturingStage.NumberOfDays;
_unitOfWork.St_ItemCardH.AddManufacturingStage(UpdateSt_ManufacturingStage);
}
if (ObjToUpdate.St_RawMaterialH != null)
{
foreach (var UpdateSt_RawMaterial in ObjToUpdate.St_RawMaterialH)
{
UpdateSt_RawMaterial.CompanyID = UserInfo.fCompanyId;
UpdateSt_RawMaterial.ItemCode = updateSt_ItemCard.ItemCode;
UpdateSt_RawMaterial.RawMaterialCode = UpdateSt_RawMaterial.RawMaterialCode;
UpdateSt_RawMaterial.RowNumber = UpdateSt_RawMaterial.RowNumber;
UpdateSt_RawMaterial.Quantity = UpdateSt_RawMaterial.Quantity;
UpdateSt_RawMaterial.Cost = UpdateSt_RawMaterial.Cost;
UpdateSt_RawMaterial.Total = UpdateSt_RawMaterial.Total;
_unitOfWork.St_ItemCardH.AddRawMaterial(UpdateSt_RawMaterial);
}
}
}
int iRow = 0;
if (ObjToUpdate.ItemTypeNo == 1)
{
if (ObjToUpdate.St_SubColorsItemH != null)
{
foreach (var UpdateSubColorsItem in ObjToUpdate.St_SubColorsItemH)
{
iRow = iRow + 1;
UpdateSubColorsItem.CompanyID = UserInfo.fCompanyId;
UpdateSubColorsItem.ItemCode = updateSt_ItemCard.ItemCode;
UpdateSubColorsItem.SubItemColorCode = UpdateSubColorsItem.SubItemColorCode;
UpdateSubColorsItem.RowNumber = iRow;
_unitOfWork.St_ItemCardH.AddSubColorsItem(UpdateSubColorsItem);
}
}
}
iRow = 0;
if (ObjToUpdate.St_ItemWarehouseH != null)
{
foreach (var UpdateItemWarehouse in ObjToUpdate.St_ItemWarehouseH)
{
iRow = iRow + 1;
UpdateItemWarehouse.CompanyID = UserInfo.fCompanyId;
UpdateItemWarehouse.ItemCode = updateSt_ItemCard.ItemCode;
UpdateItemWarehouse.StockCode = UpdateItemWarehouse.StockCode;
UpdateItemWarehouse.RowNumber = iRow;
_unitOfWork.St_ItemCardH.AddItemWarehous(UpdateItemWarehouse);
}
}
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_ItemCardH.AddItemCard(updateSt_ItemCard);
_unitOfWork.Complete();
Msg.Code = 1;
Msg.Msg = Resources.Resource.UpdatedSuccessfully;
Msg.LastID = updateSt_ItemCard.ItemCode;
return(Json(Msg, JsonRequestBehavior.AllowGet));
}
catch (Exception ex)
{
Msg.Msg = Resources.Resource.SomthingWentWrong + " : " + ex.Message.ToString();
Msg.Code = 0;
return(Json(Msg, JsonRequestBehavior.AllowGet));
}
}
