// GET: Waste/Create
public ActionResult Waste(long?id, string type)
{
WasteModel wasteModel = new WasteModel();
if (UserRolePermissionForPage.Add == true || UserRolePermissionForPage.Edit == true || UserRolePermissionForPage.View == true)
{
if (id > 0)
{
long wasteId = Convert.ToInt64(id);
wasteModel = _iWasteService.GetWasteById(wasteId);
ViewBag.ActionType = type;
}
else
{
wasteModel.WasteDateTime = DateTime.UtcNow.AddMinutes(LoginInfo.Timeoffset);
wasteModel.ReferenceNumber = _iWasteService.ReferenceNumber().ToString();
}
wasteModel.StoreList = _iDropDownService.GetStoreList();
wasteModel.FoodMenuList = _iDropDownService.GetFoodMenuListByFoodmenuType(-1);
wasteModel.IngredientList = _iDropDownService.GetIngredientList();
wasteModel.FoodMenuListForLostAmount = _iWasteService.FoodMenuListForLostAmount();
wasteModel.IngredientListForLostAmount = _iWasteService.IngredientListForLostAmount();
return(View(wasteModel));
}
else
{
return(RedirectToAction("NotFound", "Error"));
}
}
public ActionResult Waste(WasteModel model)
{
if (ModelState.IsValid)
{
int recordsCreated = CreateWaste(model.TypeName);
return(RedirectToAction("Waste"));
}
return(View());
}
public ActionResult Waste(WasteModel wasteModel)
{
//wasteModel.FoodMenuList = _iDropDownService.GetFoodMenuList();
//wasteModel.IngredientList = _iDropDownService.GetIngredientList();
//wasteModel.EmployeeList = _iDropDownService.GetEmployeeList();
//wasteModel.StoreList = _iDropDownService.GetStoreList();
string wasteMessage = string.Empty;
if (!ModelState.IsValid)
{
string errorString = this.ValidationWaste(wasteModel);
if (!string.IsNullOrEmpty(errorString))
{
return(Json(new { error = true, message = errorString, status = 201 }));
}
}
if (wasteModel.WasteDetail != null)
{
if (wasteModel.WasteDetail.Count > 0)
{
if (wasteModel.Id > 0)
{
int result = _iWasteService.UpdateWaste(wasteModel);
if (result > 0)
{
wasteMessage = _locService.GetLocalizedHtmlString("EditSuccss");
}
}
else
{
int result = _iWasteService.InsertWaste(wasteModel);
if (result > 0)
{
wasteMessage = _locService.GetLocalizedHtmlString("SaveSuccess") + " Reference No is: " + result.ToString();
}
}
}
else
{
wasteMessage = _locService.GetLocalizedHtmlString("ValidWasteDetails");
return(Json(new { error = true, message = wasteMessage, status = 201 }));
}
}
else
{
wasteMessage = _locService.GetLocalizedHtmlString("ValidWasteDetails");
return(Json(new { error = true, message = wasteMessage, status = 201 }));
}
// return View(wasteModel);
return(Json(new { error = false, message = wasteMessage, status = 200 }));
//return View();
}
public WasteModel GetWasteById(long wasteId)
{
List <WasteModel> wasteModel = new List <WasteModel>();
WasteModel model = new WasteModel();
model = _iWasteRepository.GetWasteById(wasteId).ToList().SingleOrDefault();
if (model != null)
{
model.WasteDetail = _iWasteRepository.GetWasteDetails(wasteId);
}
return(model);
}
public static int CreateWaste(string TypeName)
{
WasteModel data = new WasteModel
{
TypeName = TypeName,
};
string sql = @"insert into dbo.Waste (TypeName)
values (@TypeName);";
return(SqlDataAccess.SaveData(sql, data));
}
public ActionResult View(long?id)
{
WasteModel wasteModel = new WasteModel();
if (UserRolePermissionForPage.View == true)
{
long wasteId = Convert.ToInt64(id);
wasteModel = _iWasteService.GetViewWasteById(wasteId);
return(View(wasteModel));
}
else
{
return(RedirectToAction("NotFound", "Error"));
}
}
public ActionResult GetOrderById(long wasteId)
{
WasteModel wasteModel = new WasteModel()
{
StoreList = _iDropDownService.GetStoreList(),
FoodMenuList = _iDropDownService.GetFoodMenuList(),
IngredientList = _iDropDownService.GetIngredientList(),
//EmployeeList = _iDropDownService.GetEmployeeList(),
FoodMenuListForLostAmount = _iWasteService.FoodMenuListForLostAmount(),
IngredientListForLostAmount = _iWasteService.IngredientListForLostAmount(),
};
wasteModel = _iWasteService.GetWasteById(wasteId);
return(View(wasteModel));
}
private string ValidationWaste(WasteModel wasteModel)
{
string ErrorString = string.Empty;
//if (string.IsNullOrEmpty(wasteModel.EmployeeId.ToString()) || wasteModel.EmployeeId == 0)
//{
// ErrorString = _locService.GetLocalizedHtmlString("ValidEmployee");
// return ErrorString;
//}
if (string.IsNullOrEmpty(wasteModel.StoreId.ToString()) || wasteModel.StoreId == 0)
{
ErrorString = _locService.GetLocalizedHtmlString("ValidStore");
return(ErrorString);
}
if (wasteModel.WasteDetail == null || wasteModel.WasteDetail.Count < 1)
{
ErrorString = _locService.GetLocalizedHtmlString("ValidWasteDetails");
return(ErrorString);
}
return(ErrorString);
}
public int UpdateWaste(WasteModel wasteModel)
{
return(_iWasteRepository.UpdateWaste(wasteModel));
}
public int InsertWaste(WasteModel wasteModel)
{
return(_iWasteRepository.InsertWaste(wasteModel));
}
private void Minus_Click(object sender, RoutedEventArgs e)
{
WasteModel Waste = new WasteModel();
MainContent.DataContext = Waste;
}
public int InsertWaste(WasteModel wasteModel)
{
int result = 0;
int detailResult = 0;
using (SqlConnection con = new SqlConnection(_ConnectionString.Value.ConnectionString))
{
con.Open();
SqlTransaction sqltrans = con.BeginTransaction();
var query = "INSERT INTO Waste " +
"(StoreId, " +
"ReferenceNumber, " +
"WasteDateTime, " +
"EmployeeId, " +
"TotalLossAmount, " +
"ReasonForWaste, " +
"WasteStatus," +
"UserIdInserted ," +
"[DateInserted], " +
"CreatedUserId ," +
"[CreatedDatetime], " +
"[IsDeleted]) " +
" VALUES " +
" (@StoreId, " +
"@ReferenceNumber, " +
"@WasteDateTime, " +
"@EmployeeId, " +
"@TotalLossAmount, " +
"@ReasonForWaste, " +
"@WasteStatus, " +
"" + LoginInfo.Userid + "," +
"GetUtcDate(), " +
"" + LoginInfo.Userid + "," +
"GetUtcDate(), " +
"0); SELECT CAST(SCOPE_IDENTITY() as int); ";
result = con.ExecuteScalar <int>(query, wasteModel, sqltrans, 0, System.Data.CommandType.Text);
if (result > 0)
{
var queryDetails = string.Empty;
foreach (var item in wasteModel.WasteDetail)
{
if (item.FoodMenuId == 0)
{
queryDetails = "INSERT INTO WasteIngredient ([WasteId],FoodMenuId,[IngredientId] ,IngredientQty, LossAmount, [UserIdInserted],DateInserted,[IsDeleted]) " +
"VALUES " +
"(" + result + ",NULL," + item.IngredientId + "," + item.Qty + "," + item.LossAmount +
"," + LoginInfo.Userid + "," + "GetUtcDate(),0);" +
" SELECT CAST(ReferenceNumber as INT) from waste where id = " + result + "; ";
}
else
{
queryDetails = "INSERT INTO WasteIngredient ([WasteId],FoodMenuId,[IngredientId] ,IngredientQty, LossAmount, [UserIdInserted],DateInserted,[IsDeleted]) " +
"VALUES " +
"(" + result + "," + item.FoodMenuId + ",NULL," + item.Qty + "," + item.LossAmount +
"," + LoginInfo.Userid + "," + "GetUtcDate(),0);" +
" SELECT CAST(ReferenceNumber as INT) from waste where id = " + result + "; ";
}
detailResult = con.ExecuteScalar <int>(queryDetails, null, sqltrans, 0, System.Data.CommandType.Text);
}
if (detailResult > 0)
{
sqltrans.Commit();
if ((int)wasteModel.WasteStatus == 2)
{
CommonRepository commonRepository = new CommonRepository(_ConnectionString);
string sResult = commonRepository.InventoryPush("Waste", result);
}
}
else
{
sqltrans.Rollback();
}
}
else
{
sqltrans.Rollback();
}
}
return(detailResult);
}
public int UpdateWaste(WasteModel wasteModel)
{
int result = 0;
using (SqlConnection con = new SqlConnection(_ConnectionString.Value.ConnectionString))
{
con.Open();
SqlTransaction sqltrans = con.BeginTransaction();
var query = "Update Waste set " +
"StoreId=@StoreId, ReferenceNumber=@ReferenceNumber, WasteDateTime=@WasteDateTime, EmployeeId=@EmployeeId, " +
" TotalLossAmount=@TotalLossAmount, ReasonForWaste=@ReasonForWaste, WasteStatus=@WasteStatus ";
if ((int)wasteModel.WasteStatus == 2)
{
query += ",ApprovedUserId = " + LoginInfo.Userid + ",ApprovedDateTime=GetUtcDate()";
}
query += " ,UserIdUpdated = " + LoginInfo.Userid + ",DateUpdated = GetUtcDate() where id= " + wasteModel.Id + ";";
result = con.Execute(query, wasteModel, sqltrans, 0, System.Data.CommandType.Text);
if (result > 0)
{
int detailResult = 0;
if (wasteModel.DeletedId != null)
{
foreach (var item in wasteModel.DeletedId)
{
var obj = item.Split('|');
var deleteQuery = string.Empty;
if (Convert.ToInt32(obj[2]) == 0)
{
deleteQuery = $"update WasteIngredient set IsDeleted = 1, UserIdDeleted = " + LoginInfo.Userid + ", DateDeleted = GetutcDate() where wasteid = " + Convert.ToInt32(obj[0]) + " and FoodMenuId = " + Convert.ToInt32(obj[1]) + " ;";
}
else
{
deleteQuery = $"update WasteIngredient set IsDeleted = 1, UserIdDeleted = " + LoginInfo.Userid + ", DateDeleted = GetutcDate() where wasteid = " + Convert.ToInt32(obj[0]) + " and " + " IngredientId=" + Convert.ToInt32(obj[2]) + " and FoodMenuId = 0;";
}
result = con.Execute(deleteQuery, null, sqltrans, 0, System.Data.CommandType.Text);
}
}
foreach (var item in wasteModel.WasteDetail)
{
var queryDetails = string.Empty;
if (item.WasteIngredientId > 0)
{
if (item.FoodMenuId > 0)
{
queryDetails = "Update [dbo].[WasteIngredient] set " +
" [IngredientQty] = " + item.Qty + "," +
" [LossAmount] = " + item.LossAmount + "," +
" UserIdUpdated = " + LoginInfo.Userid + "," +
" DateUpdated = GetUtcDate()" +
" where Id = " + item.WasteIngredientId + ";";
}
else if (item.IngredientId > 0)
{
queryDetails = "Update [dbo].[WasteIngredient] set " +
" [IngredientQty] = " + item.Qty + "," +
" [LossAmount] = " + item.LossAmount + "," +
" UserIdUpdated = " + LoginInfo.Userid + "," +
" DateUpdated = GetUtcDate()" +
" where Id = " + item.WasteIngredientId + ";";
}
}
else
{
if (item.FoodMenuId == 0)
{
queryDetails = "INSERT INTO WasteIngredient ([WasteId],FoodMenuId,[IngredientId] ,IngredientQty, LossAmount, [UserIdInserted],DateInserted,[IsDeleted]) " +
"VALUES " +
"(" + wasteModel.Id + ",NULL," + item.IngredientId + "," + item.Qty + "," + item.LossAmount +
"," + LoginInfo.Userid + "," + "GetUtcDate(),0);" +
" SELECT CAST(ReferenceNumber as INT) from waste where id = " + result + "; ";
}
else
{
queryDetails = "INSERT INTO WasteIngredient ([WasteId],FoodMenuId,[IngredientId] ,IngredientQty, LossAmount, [UserIdInserted],DateInserted,[IsDeleted]) " +
"VALUES " +
"(" + wasteModel.Id + "," + item.FoodMenuId + ",NULL," + item.Qty + "," + item.LossAmount +
"," + LoginInfo.Userid + "," + "GetUtcDate(),0);" +
" SELECT CAST(ReferenceNumber as INT) from waste where id = " + result + "; ";
}
}
detailResult = con.Execute(queryDetails, null, sqltrans, 0, System.Data.CommandType.Text);
}
if (detailResult > 0)
{
sqltrans.Commit();
if ((int)wasteModel.WasteStatus == 2)
{
CommonRepository commonRepository = new CommonRepository(_ConnectionString);
string sResult = commonRepository.InventoryPush("Waste", wasteModel.Id);
}
}
else
{
sqltrans.Rollback();
}
}
else
{
sqltrans.Rollback();
}
}
return(result);
}
