public void UpdateFileDiscrepancies(List <WCF_FileDiscrepancy> fileDiscrepancies, string username)
{
Inventory_Adjustment invAdjustmentSup = new Inventory_Adjustment();
invAdjustmentSup.deleted = "N";
invAdjustmentSup.clerk_user = username;
invAdjustmentSup.status = "Pending";
invAdjustmentSup.date = DateTime.Today;
invAdjustmentSup.status_date = DateTime.Today;
Inventory_Adjustment invAdjustmentMan = new Inventory_Adjustment();
invAdjustmentMan.deleted = "N";
invAdjustmentMan.clerk_user = username;
invAdjustmentMan.status = "Pending";
invAdjustmentMan.date = DateTime.Today;
invAdjustmentMan.status_date = DateTime.Today;
foreach (WCF_FileDiscrepancy i in fileDiscrepancies)
{
int adjusted = int.Parse(i.adjustedQty);
Stock_Inventory inventory = context.Stock_Inventory.Where(x => x.item_code == i.itemCode).ToList().First();
inventory.current_qty += adjusted;
MonthlyCheckModel itemModel = new MonthlyCheckModel(inventory);
double cost = Math.Abs(adjusted) * itemModel.AveragePrice;
Adjustment_Details adjDetails = new Adjustment_Details();
adjDetails.deleted = "N";
adjDetails.item_code = inventory.item_code;
adjDetails.quantity_adjusted = adjusted;
adjDetails.reason = i.reason;
if (cost < 250)
{
invAdjustmentSup.Adjustment_Details.Add(adjDetails);
}
if (cost >= 250)
{
invAdjustmentMan.Adjustment_Details.Add(adjDetails);
}
context.Adjustment_Details.Add(adjDetails);
}
if (invAdjustmentSup.Adjustment_Details.Count != 0)
{
context.Inventory_Adjustment.Add(invAdjustmentSup);
context.SaveChanges();
}
if (invAdjustmentMan.Adjustment_Details.Count != 0)
{
context.Inventory_Adjustment.Add(invAdjustmentMan);
context.SaveChanges();
}
}
public void UpdateMonthlyCheck(List <MonthlyCheckModel> list, string username)
{
Inventory_Adjustment inventoryAdjMan = new Inventory_Adjustment();
inventoryAdjMan.clerk_user = username;
inventoryAdjMan.deleted = "N";
inventoryAdjMan.status = "Pending";
inventoryAdjMan.date = DateTime.Today;
inventoryAdjMan.status_date = DateTime.Today;
Inventory_Adjustment inventoryAdjSup = new Inventory_Adjustment();
inventoryAdjMan.clerk_user = username;
inventoryAdjMan.deleted = "N";
inventoryAdjMan.status = "Pending";
inventoryAdjMan.date = DateTime.Today;
inventoryAdjMan.status_date = DateTime.Today;
foreach (MonthlyCheckModel i in list)
{
int adjusted = i.CurrentQuantity - i.ActualQuantity;
Stock_Inventory inventory = context.Stock_Inventory.Where(x => x.item_code == i.ItemCode).ToList().First();
MonthlyCheckModel itemModel = new MonthlyCheckModel(inventory);
double cost = Math.Abs(adjusted) * itemModel.AveragePrice;
Adjustment_Details adjustmentDetail = new Adjustment_Details();
adjustmentDetail.item_code = i.ItemCode;
adjustmentDetail.quantity_adjusted = adjusted;
adjustmentDetail.reason = i.Reason;
adjustmentDetail.deleted = "N";
if (cost >= 250)
{
inventoryAdjMan.Adjustment_Details.Add(adjustmentDetail);
}
else if (cost < 250)
{
inventoryAdjSup.Adjustment_Details.Add(adjustmentDetail);
}
context.Adjustment_Details.Add(adjustmentDetail);
}
if (inventoryAdjMan.Adjustment_Details.Count != 0)
{
context.Inventory_Adjustment.Add(inventoryAdjMan);
context.SaveChanges();
}
if (inventoryAdjSup.Adjustment_Details.Count != 0)
{
context.Inventory_Adjustment.Add(inventoryAdjSup);
context.SaveChanges();
}
}
public List <MonthlyCheckModel> GetAllMonthlyCheck()
{
List <MonthlyCheckModel> modelList = new List <MonthlyCheckModel>();
List <Stock_Inventory> inventoryList = context.Stock_Inventory.Where(x => x.deleted == "N").ToList();
foreach (Stock_Inventory i in inventoryList)
{
MonthlyCheckModel model = new MonthlyCheckModel(i);
modelList.Add(model);
}
return(modelList);
}
protected void Page_Load(object sender, EventArgs e)
{
context = new SSISEntities();
if (!IsPostBack)
{
checkDone = CheckIfMonthlyDone();
List <MonthlyCheckModel> itemList = (List <MonthlyCheckModel>)Session["Monthly"];
if (itemList == null)
{
itemList = new List <MonthlyCheckModel>();
List <Stock_Inventory> stockList = context.Stock_Inventory.Where(x => x.deleted == "N").ToList();
foreach (Stock_Inventory i in stockList)
{
MonthlyCheckModel item = new MonthlyCheckModel(i);
itemList.Add(item);
}
Session["Monthly"] = itemList;
}
MonthlyCheckGV.DataSource = itemList;
MonthlyCheckGV.DataBind();
UserModel user = new UserModel(HttpContext.Current.User.Identity.Name);
UserModel depthead = user.FindDelegateOrDeptHead();
//CheckLabel.Text = depthead.Username;
//today = DateTime.Today;
//DateTB.Text = today.Date.ToString("dd/MM/yyyy");
itemList = (List <MonthlyCheckModel>)Session["Monthly"];
//Session["Monthly"] = itemList;
MonthlyCheckGV.DataSource = itemList;
MonthlyCheckGV.DataBind();
}
}
protected void Page_Load(object sender, EventArgs e)
{
context = new SSISEntities();
List <MonthlyCheckModel> modelList;
Dictionary <string, int> SessionInfo;
if (!IsPostBack)
{
modelList = new List <MonthlyCheckModel>();
SessionInfo = (Dictionary <string, int>)Session[PUBLIC_SESSION_DISCREPANCY_DICT];
// Early quit if no session
if (SessionInfo == null)
{
lblWarning.Text = "No discrepancies to be filed.";
ConfirmBtn.Visible = false;
return;
}
lblWarning.Visible = false;
foreach (KeyValuePair <string, int> pair in SessionInfo)
{
string itemCode = pair.Key;
int qtyAdjusted = pair.Value;
Stock_Inventory inventory = context.Stock_Inventory.Where(x => x.item_code == itemCode).ToList().First();
MonthlyCheckModel model = new MonthlyCheckModel(inventory);
model.ActualQuantity = model.CurrentQuantity - qtyAdjusted;
modelList.Add(model);
}
Session["DisDetail"] = modelList;
FileDiscrepencyGV.DataSource = modelList;
FileDiscrepencyGV.DataBind();
}
}
public bool UpdateMonthlyCheck(List <WCF_MonthlyCheck> monthlyChecks, string username)
{
Inventory_Adjustment invAdjustmentSup = new Inventory_Adjustment();
invAdjustmentSup.deleted = "N";
invAdjustmentSup.clerk_user = username;
invAdjustmentSup.status = "Pending";
invAdjustmentSup.date = DateTime.Today;
invAdjustmentSup.status_date = DateTime.Today;
Inventory_Adjustment invAdjustmentMan = new Inventory_Adjustment();
invAdjustmentMan.deleted = "N";
invAdjustmentMan.clerk_user = username;
invAdjustmentMan.status = "Pending";
invAdjustmentMan.date = DateTime.Today;
invAdjustmentMan.status_date = DateTime.Today;
foreach (WCF_MonthlyCheck i in monthlyChecks)
{
int actual = int.Parse(i.actualQuantity);
int current = int.Parse(i.CurrentQuantity);
int adjusted = current - actual;
if (adjusted == 0)
{
continue;
}
Stock_Inventory inventory = context.Stock_Inventory.Where(x => x.item_code == i.ItemCode).ToList().First();
inventory.current_qty = actual;
MonthlyCheckModel itemModel = new MonthlyCheckModel(inventory);
double cost = Math.Abs(adjusted) * itemModel.AveragePrice;
Adjustment_Details adjDetails = new Adjustment_Details();
adjDetails.deleted = "N";
adjDetails.item_code = i.ItemCode;
adjDetails.quantity_adjusted = adjusted;
adjDetails.reason = i.Reason;
if (cost < 250)
{
invAdjustmentSup.Adjustment_Details.Add(adjDetails);
}
if (cost >= 250)
{
invAdjustmentMan.Adjustment_Details.Add(adjDetails);
}
context.Adjustment_Details.Add(adjDetails);
}
if (invAdjustmentSup.Adjustment_Details.Count != 0)
{
context.Inventory_Adjustment.Add(invAdjustmentSup);
context.SaveChanges();
}
if (invAdjustmentMan.Adjustment_Details.Count != 0)
{
context.Inventory_Adjustment.Add(invAdjustmentMan);
context.SaveChanges();
}
if (invAdjustmentSup.Adjustment_Details.Count != 0 || invAdjustmentMan.Adjustment_Details.Count != 0)
{
return(true);
}
else
{
return(false);
}
}
