public ActionResult InventoryAdjustment(long?id, int?inventoryType, int?consumptionStatus, string type)
{
InventoryAdjustmentModel inventoryAdjustmentModel = new InventoryAdjustmentModel();
if (UserRolePermissionForPage.Add == true || UserRolePermissionForPage.Edit == true || UserRolePermissionForPage.View == true)
{
if (id > 0)
{
ViewBag.ActionType = type;
long purchaseId = Convert.ToInt64(id);
inventoryAdjustmentModel = _inventoryAdjustmentService.GetInventoryAdjustmentById(purchaseId);
}
else
{
inventoryAdjustmentModel.Date = DateTime.UtcNow.AddMinutes(LoginInfo.Timeoffset);
inventoryAdjustmentModel.ReferenceNo = _inventoryAdjustmentService.ReferenceNumber().ToString();
inventoryAdjustmentModel.InventoryType = Convert.ToInt32(inventoryType);
inventoryAdjustmentModel.ConsumptionStatus = Convert.ToInt32(consumptionStatus);
}
inventoryAdjustmentModel.StoreList = _iDropDownService.GetStoreList();
ViewBag.SelectedStore = inventoryAdjustmentModel.StoreList.Where(x => x.Selected == true).Select(x => x.Value).SingleOrDefault();
inventoryAdjustmentModel.EmployeeList = _iDropDownService.GetEmployeeList();
inventoryAdjustmentModel.IngredientList = _iDropDownService.GetIngredientList();
inventoryAdjustmentModel.AssetItemList = _iDropDownService.GetAssetItemList();
inventoryAdjustmentModel.FoodMenuList = _iDropDownService.GetFoodMenuListByFoodmenuType(-1);
return(View(inventoryAdjustmentModel));
}
else
{
return(RedirectToAction("NotFound", "Error"));
}
}
public ActionResult GetOrderById(long Id)
{
InventoryAdjustmentModel inventoryAdjustmentModel = new InventoryAdjustmentModel();
inventoryAdjustmentModel = _inventoryAdjustmentService.GetInventoryAdjustmentById(Id);
return(View(inventoryAdjustmentModel));
}
public ActionResult View(long?id)
{
InventoryAdjustmentModel inventoryAdjustmentModel = new InventoryAdjustmentModel();
long purchaseId = Convert.ToInt64(id);
inventoryAdjustmentModel = _inventoryAdjustmentService.GetViewInventoryAdjustmentById(purchaseId);
return(View(inventoryAdjustmentModel));
}
public ActionResult InventoryAdjustment(InventoryAdjustmentModel inventoryAdjustmentModel)
{
inventoryAdjustmentModel.StoreList = _iDropDownService.GetStoreList();
inventoryAdjustmentModel.EmployeeList = _iDropDownService.GetEmployeeList();
inventoryAdjustmentModel.IngredientList = _iDropDownService.GetIngredientList();
inventoryAdjustmentModel.FoodMenuList = _iDropDownService.GetFoodMenuListByFoodmenuType(-1);
string purchaseMessage = string.Empty;
if (!ModelState.IsValid)
{
string errorString = this.ValidationInveotryAdjustment(inventoryAdjustmentModel);
if (!string.IsNullOrEmpty(errorString))
{
return(Json(new { error = true, message = errorString, status = 201 }));
}
}
if (inventoryAdjustmentModel.InventoryAdjustmentDetail != null)
{
if (inventoryAdjustmentModel.InventoryAdjustmentDetail.Count > 0)
{
if (inventoryAdjustmentModel.Id > 0)
{
int result = _inventoryAdjustmentService.UpdateInventoryAdjustment(inventoryAdjustmentModel);
if (result > 0)
{
purchaseMessage = _locService.GetLocalizedHtmlString("EditSuccss");
}
}
else
{
//inventoryAdjustmentModel.Date = DateTime.UtcNow.AddMinutes(LoginInfo.Timeoffset);
int result = _inventoryAdjustmentService.InsertInventoryAdjustment(inventoryAdjustmentModel);
if (result > 0)
{
purchaseMessage = _locService.GetLocalizedHtmlString("SaveSuccess");// + " Number is: " + result.ToString();
}
}
}
else
{
purchaseMessage = _locService.GetLocalizedHtmlString("ValidPurchaseDetails");
return(Json(new { error = true, message = purchaseMessage, status = 201 }));
}
}
else
{
purchaseMessage = _locService.GetLocalizedHtmlString("ValidPurchaseDetails");
return(Json(new { error = true, message = purchaseMessage, status = 201 }));
}
// return View(purchaseModel);
return(Json(new { error = false, message = purchaseMessage, status = 200 }));
//return View();
}
protected void Reject_Click(object sender, EventArgs e)
{
InventoryAdjustmentModel invModel = (InventoryAdjustmentModel)Session["ConfirmAdj"];
Inventory_Adjustment inventoryAdjustment = context.Inventory_Adjustment.Where(x => x.voucher_id == invModel.VoucherID).ToList().First();
inventoryAdjustment.status = "Rejected";
inventoryAdjustment.status_date = DateTime.Today;
context.SaveChanges();
Response.Redirect("~/Views/DepartmentHead/HeadDashboard.aspx");
}
//InventoryAdjustmentModel model;
protected void Page_Load(object sender, EventArgs e)
{
context = new SSISEntities();
if (!IsPostBack)
{
List <Inventory_Adjustment> invAdjList = context.Inventory_Adjustment.Where(x => x.deleted == "N" & x.status == "Pending").ToList();
List <InventoryAdjustmentModel> invModelList = new List <InventoryAdjustmentModel>();
foreach (Inventory_Adjustment i in invAdjList)
{
InventoryAdjustmentModel model = new InventoryAdjustmentModel(i);
//model = new InventoryAdjustmentModel(i);
if (User.IsInRole("Manager"))
{
foreach (AdjustmentModel j in model.AdjModel)
{
if (j.Above250())
{
invModelList.Add(model);
break;
}
}
}
else if (User.IsInRole("Supervisor"))
{
foreach (AdjustmentModel j in model.AdjModel)
{
if (!j.Above250())
{
invModelList.Add(model);
break;
}
}
}
}
Session["ViewAdj"] = invModelList;
ViewAdjustmentGV.DataSource = invModelList;
ViewAdjustmentGV.DataBind();
//invModelList.Add(model);
//GridView1.DataSource = invModelList;
//GridView1.DataBind();
}
//List<Adjustment_Details> adjList = context.Adjustment_Details.ToList();
//List<AdjustmentModel> detailList = new List<AdjustmentModel>();
//foreach (Adjustment_Details i in adjList)
//{
// AdjustmentModel model = new AdjustmentModel(i);
// detailList.Add(model);
//}
//Session["ViewAdj"] = detailList;
}
protected void detailBtn_Click(object sender, EventArgs e)
{
GridViewRow gridViewRow = (GridViewRow)(sender as Control).Parent.Parent;
Label rowIndex = (Label)gridViewRow.FindControl("rowIndex");
int index = int.Parse(rowIndex.Text) - 1;
List <InventoryAdjustmentModel> invModelList = (List <InventoryAdjustmentModel>)Session["ViewAdj"];
InventoryAdjustmentModel model = invModelList[index];
Session["ConfirmAdj"] = model;
Response.Redirect("AdjustmentDetail.aspx");
}
protected void Page_Load(object sender, EventArgs e)
{
context = new SSISEntities();
InventoryAdjustmentModel invModel = (InventoryAdjustmentModel)Session["ConfirmAdj"];
//List<InventoryAdjustmentModel> invModelList = new List<InventoryAdjustmentModel>();
//invModelList.Add(invModel);
//GridView2.DataSource = invModelList;
//GridView2.DataBind();
List <AdjustmentModel> adjList = invModel.AdjModel;
GridView1.DataSource = adjList;
GridView1.DataBind();
}
private string ValidationInveotryAdjustment(InventoryAdjustmentModel inventoryAdjustmentModel)
{
string ErrorString = string.Empty;
if (string.IsNullOrEmpty(inventoryAdjustmentModel.StoreId.ToString()) || inventoryAdjustmentModel.StoreId == 0)
{
ErrorString = _locService.GetLocalizedHtmlString("ValidStoreName");
return(ErrorString);
}
if (inventoryAdjustmentModel.InventoryAdjustmentDetail == null || inventoryAdjustmentModel.InventoryAdjustmentDetail.Count < 1)
{
ErrorString = _locService.GetLocalizedHtmlString("ValidPurchaseDetails");
return(ErrorString);
}
return(ErrorString);
}
public List <WCFInventoryAdjustmentModel> GetAllAdjustmentList(string role)
{
List <WCFInventoryAdjustmentModel> rd = new List <WCFInventoryAdjustmentModel>();
List <InventoryAdjustmentModel> invModelList = new List <InventoryAdjustmentModel>();
List <Inventory_Adjustment> invAdjList = work.GetAdjustmentList();
foreach (Inventory_Adjustment i in invAdjList)
{
InventoryAdjustmentModel s = new InventoryAdjustmentModel(i);
if (role.Equals("DeptHead"))
{
foreach (AdjustmentModel j in s.AdjModel)
{
if (j.Above250())
{
invModelList.Add(s);
break;
}
}
}
else if (role.Equals("Supervisor"))
{
foreach (AdjustmentModel j in s.AdjModel)
{
if (!j.Above250())
{
invModelList.Add(s);
break;
}
}
}
}
foreach (InventoryAdjustmentModel s in invModelList)
{
WCFInventoryAdjustmentModel item = new WCFInventoryAdjustmentModel(s.VoucherID.ToString(), s.Clerk, s.Status, s.Date.ToString(), s.HighestCost.ToString());
rd.Add(item);
}
return(rd);
}
public int UpdateInventoryAdjustment(InventoryAdjustmentModel inventoryAdjustmentModel)
{
return(_inventoryAdjustmentRepository.UpdateInventoryAdjustment(inventoryAdjustmentModel));
}
public int InsertInventoryAdjustment(InventoryAdjustmentModel inventoryAdjustmentModel)
{
return(_inventoryAdjustmentRepository.InsertInventoryAdjustment(inventoryAdjustmentModel));
}
public int UpdateInventoryAdjustment(InventoryAdjustmentModel inventoryAdjustmentModel)
{
int result = 0;
string foodMenuId = "NULL", ingredientId = "NULL", assetItemId = "NULL";
using (SqlConnection con = new SqlConnection(_ConnectionString.Value.ConnectionString))
{
con.Open();
SqlTransaction sqltrans = con.BeginTransaction();
var query = "Update InventoryAdjustment SET StoreId=@StoreId,EntryDate=@Date, ReferenceNumber=@ReferenceNo,EmployeeId=@EmployeeId,Notes = @Notes" +
",[UserIdUpdated] = " + LoginInfo.Userid + ", [DateUpdated] = GetUtcDate() where id= " + inventoryAdjustmentModel.Id + ";";
result = con.Execute(query, inventoryAdjustmentModel, sqltrans, 0, System.Data.CommandType.Text);
if (result > 0)
{
int detailResult = 0;
if (inventoryAdjustmentModel.DeletedId != null)
{
foreach (var item in inventoryAdjustmentModel.DeletedId)
{
var deleteQuery = $"update InventoryAdjustmentDetail set IsDeleted = 1, UserIdDeleted = " + LoginInfo.Userid + ", DateDeleted = GetutcDate() where id = " + item + ";";
result = con.Execute(deleteQuery, null, sqltrans, 0, System.Data.CommandType.Text);
}
}
foreach (var item in inventoryAdjustmentModel.InventoryAdjustmentDetail)
{
var queryDetails = string.Empty;
/*
* int consumptionId = 0;
* if (item.ConsumpationStatus.Value.ToString() == "StockIN")
* {
* consumptionId = 1;
* }
* else
* {
* consumptionId = 2;
* }
*/
if (item.AssetItemId == 0)
{
assetItemId = "NULL";
}
else
{
assetItemId = item.AssetItemId.ToString();
}
if (item.IngredientId == 0)
{
ingredientId = "NULL";
}
else
{
ingredientId = item.IngredientId.ToString();
}
if (item.FoodMenuId == 0)
{
foodMenuId = "NULL";
}
else
{
foodMenuId = item.FoodMenuId.ToString();
var FoodmenuPurchaePriceUpdate = "" +
" update foodmenu set PurchasePrice = " + item.Price + " Where id = " + item.FoodMenuId;
con.Execute(FoodmenuPurchaePriceUpdate, null, sqltrans, 0, System.Data.CommandType.Text);
}
if (item.InventoryAdjustmentId > 0)
{
queryDetails = "Update InventoryAdjustmentDetail SET " +
" IngredientId = " + ingredientId +
" ,FoodMenuId = " + foodMenuId +
" ,AssetItemId = " + assetItemId +
" ,Qty = " + item.Quantity +
" ,Price = " + item.Price +
" ,Total = " + item.TotalAmount +
",ConsumptionStatus= " + inventoryAdjustmentModel.ConsumptionStatus +
",UserIdUpdated = " + LoginInfo.Userid +
", DateUpdated = GetUtcDate()" +
" WHERE Id = " + item.InventoryAdjustmentId + ";";
}
else
{
queryDetails = "INSERT INTO InventoryAdjustmentDetail" +
" (InventoryAdjustmentId, IngredientId,FoodMenuId,AssetItemId,Qty,Price,Total,ConsumptionStatus,UserIdInserted,DateInserted,IsDeleted) " +
"VALUES " +
"(" + inventoryAdjustmentModel.Id + "," +
"" + ingredientId + "," +
"" + foodMenuId + "," +
"" + assetItemId + "," +
"" + item.Quantity + "," +
"" + item.Price + "," +
"" + item.TotalAmount + "," +
"" + inventoryAdjustmentModel.ConsumptionStatus + "," + LoginInfo.Userid + ",GetUTCDate(),0)";
}
detailResult = con.Execute(queryDetails, null, sqltrans, 0, System.Data.CommandType.Text);
}
if (detailResult > 0)
{
sqltrans.Commit();
}
else
{
sqltrans.Rollback();
}
}
else
{
sqltrans.Rollback();
}
}
return(result);
}
public int InsertInventoryAdjustment(InventoryAdjustmentModel inventoryAdjustmentModel)
{
int result = 0;
int detailResult = 0;
string foodMenuId = "NULL", ingredientId = "NULL", assetItemId = "NULL";
using (SqlConnection con = new SqlConnection(_ConnectionString.Value.ConnectionString))
{
if (LoginInfo.Userid == 0)
{
LoginInfo.Userid = 1;
}
con.Open();
SqlTransaction sqltrans = con.BeginTransaction();
var query = "INSERT INTO InventoryAdjustment " +
" ( StoreId, ReferenceNumber,InventoryType,ConsumptionStatus,EntryDate,EmployeeId,Notes,UserIdInserted,DateInserted,IsDeleted ) " +
" VALUES " +
" ( @StoreId, @ReferenceNo,@InventoryType,@ConsumptionStatus, @Date,@EmployeeId,@Notes," + LoginInfo.Userid + ",GetUTCDate(),0); " +
" SELECT CAST(Scope_Identity() as int); ";
result = con.ExecuteScalar <int>(query, inventoryAdjustmentModel, sqltrans, 0, System.Data.CommandType.Text);
if (result > 0)
{
foreach (var item in inventoryAdjustmentModel.InventoryAdjustmentDetail)
{
if (item.AssetItemId == 0)
{
assetItemId = "NULL";
}
else
{
assetItemId = item.AssetItemId.ToString();
}
if (item.IngredientId == 0)
{
ingredientId = "NULL";
}
else
{
ingredientId = item.IngredientId.ToString();
}
if (item.FoodMenuId == 0)
{
foodMenuId = "NULL";
}
else
{
foodMenuId = item.FoodMenuId.ToString();
var FoodmenuPurchaePriceUpdate = "" +
" update foodmenu set PurchasePrice = " + item.Price + " Where id = " + item.FoodMenuId;
}
var queryDetails = "INSERT INTO InventoryAdjustmentDetail" +
" (InventoryAdjustmentId,IngredientId,FoodMenuId,AssetItemId,Qty,Price,Total ,ConsumptionStatus,UserIdInserted,DateInserted,IsDeleted) " +
"VALUES " +
"(" + result + "," +
"" + ingredientId + "," +
"" + foodMenuId + "," +
"" + assetItemId + "," +
"" + item.Quantity + "," +
"" + item.Price + "," +
"" + item.TotalAmount + "," +
"" + inventoryAdjustmentModel.ConsumptionStatus + "," +
"" + LoginInfo.Userid + ",GetUtcDate(),0); " +
" SELECT CAST(ReferenceNumber as INT) from InventoryAdjustment where id = " + result + "; ";
detailResult = con.ExecuteScalar <int>(queryDetails, null, sqltrans, 0, System.Data.CommandType.Text);
}
if (detailResult > 0)
{
sqltrans.Commit();
if (inventoryAdjustmentModel.ConsumptionStatus == 1)
{
CommonRepository commonRepository = new CommonRepository(_ConnectionString);
string sResult = commonRepository.InventoryPush("IA", result);
}
if (inventoryAdjustmentModel.ConsumptionStatus == 2)
{
CommonRepository commonRepository = new CommonRepository(_ConnectionString);
string sResult = commonRepository.InventoryPush("IA-Out", result);
}
}
else
{
sqltrans.Rollback();
}
}
else
{
sqltrans.Rollback();
}
}
return(detailResult);
}
