internal bool ReadList(out List <RawMaterialsModel> data) { bool flag = true; data = new List <RawMaterialsModel>(); string sql = "select a.*,b.Number SupplierNumber,b.Name SupplierName " + "from T_ProductInfo_RawMaterials a Left Join T_UserInfo_Supplier b On a.Supplier=b.Guid " + "Where a.DeleteMark is null order by a.AddTime"; DataSet ds = new DataSet(); flag = new Helper.SQLite.DBHelper().QueryData(sql, out ds); if (flag) { int id = 1; foreach (DataRow dr in ds.Tables[0].Rows) { RawMaterialsModel d = new RawMaterialsModel(); d.Guid = (Guid)dr["GUID"]; d.Id = id++; d.Number = dr["Number"].ToString(); d.Name = dr["Name"].ToString(); d.Weight = dr["Weight"].ToString(); d.Material = dr["Material"].ToString(); d.SupplierName = dr["SupplierName"].ToString(); d.Sp1 = dr["Sp1"].ToString(); d.Sp2 = dr["Sp2"].ToString(); d.Remark = dr["Remark"].ToString(); d.AddTime = Convert.ToDateTime(dr["AddTime"]); data.Add(d); } } return(flag); }
private bool CheckRepeat(RawMaterialsModel d) { object oTemp; string sql_Repeat = "select 1 from T_ProductInfo_RawMaterials where (Number='" + d.Number + "' OR Name='" + d.Name + "') AND DeleteMark IS NULL AND Guid <> '" + d.Guid + "'"; return(new Helper.SQLite.DBHelper().QuerySingleResult(sql_Repeat, out oTemp)); }
public ActionResult Create(RawMaterialsModel model) { var Data = obj.SaveRawMaterial(model); TempData["Error"] = Data; return(RedirectToAction("Index")); }
internal bool MarkDelete(RawMaterialsModel d) { bool flag = true; string sql = "Update T_ProductInfo_RawMaterials Set DeleteMark='" + DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss") + "' Where GUID='" + d.Guid + "'"; flag = new Helper.SQLite.DBHelper().SingleExecution(sql); return(flag); }
public string SaveRawMaterial(RawMaterialsModel model) { tbl_RawMaterials tb = new tbl_RawMaterials(); tblOpStckRate tb1 = new tblOpStckRate(); tbl_KitchenStock tb2 = new tbl_KitchenStock(); var duplicate = _entities.tbl_RawMaterials.Where(o => o.Name.Equals(model.Name) && o.units.Equals(model.Units) && o.rawcategoryId.Equals(model.RawCategoryId)).SingleOrDefault(); if (duplicate == null) { try { if (model.RawMaterialId != 0) { tb = _entities.tbl_RawMaterials.Where(x => x.RawMaterialId == model.RawMaterialId).SingleOrDefault(); tb2 = _entities.tbl_KitchenStock.Where(x => x.RawMaterialId == model.RawMaterialId).SingleOrDefault(); tb.Name = model.Name; tb.units = model.Units; tb.reorder = model.reorder; tb.rawcategoryId = model.RawCategoryId; tb2.Unit = model.Units; _entities.SaveChanges(); return("Record Updated Successfully..."); } else { tb.Name = model.Name; tb.units = model.Units; tb.reorder = model.reorder; tb.rawcategoryId = model.RawCategoryId; tb1.MaterialId = model.RawMaterialId; tb2.RawMaterialId = model.RawMaterialId; tb1.Rate = Convert.ToDecimal("0.00"); tb1.Date = Convert.ToDateTime("2017/09/30"); tb1.Qty = Convert.ToDecimal("0.00"); tb1.IssQty = Convert.ToDecimal("0.00"); tb2.Quantity = Convert.ToDecimal("0.00"); tb2.Unit = model.Units; tb2.OutletId = Convert.ToInt32("99"); _entities.tbl_RawMaterials.Add(tb); _entities.tblOpStckRates.Add(tb1); _entities.tbl_KitchenStock.Add(tb2); _entities.SaveChanges(); return("Record Saved Successfully..."); } } catch { return("something Wrong try Agian !"); } } else { return(model.Name + " Already Exits"); } }
internal bool Add(RawMaterialsModel d) { if (CheckRepeat(d)) { return(false); } bool flag = true; string sql = "Insert Into T_ProductInfo_RawMaterials (GUID,Number,Name,Weight,Material,Supplier,Sp1,Sp2,Remark,AddTime) " + " values('" + d.Guid + "','" + d.Number + "','" + d.Name + "','" + d.Weight + "','" + d.Material + "','" + d.Supplier + "','" + d.Sp1 + "','" + d.Sp2 + "','" + d.Remark + "','" + d.AddTime.ToString("yyyy-MM-dd HH:mm:ss") + "')"; flag = new Helper.SQLite.DBHelper().SingleExecution(sql); return(flag); }
internal bool Update(RawMaterialsModel d) { if (CheckRepeat(d)) { return(false); } string sql_Update = "Update T_ProductInfo_RawMaterials " + " SET Number='" + d.Number + "',Name='" + d.Name + "',Weight='" + d.Weight + "',Material='" + d.Material + "',Supplier='" + d.Supplier + "',Sp1='" + d.Sp1 + "',Sp2='" + d.Sp2 + "',Remark='" + d.Remark + "' Where GUID='" + d.Guid + "'"; return(new Helper.SQLite.DBHelper().SingleExecution(sql_Update)); }
public RawMaterialsModel EditRawMaterial(int Id) { RawMaterialsModel model = new RawMaterialsModel(); if (Id != 0) { var data = _entities.tbl_RawMaterials.Where(x => x.RawMaterialId == Id).SingleOrDefault(); model.RawMaterialId = data.RawMaterialId; model.Name = data.Name; model.RawCategoryName = data.RawCategory.Name; model.RawCategoryId = data.rawcategoryId; model.Units = data.units; model.reorder = Convert.ToDecimal(data.reorder); return(model); } else { return(model); } }
// Kitchen Raw Material #region public List <RawMaterialsModel> ShowAllRawMaterialsList() { List <RawMaterialsModel> List = new List <RawMaterialsModel>(); var data = _entities.tbl_RawMaterials.ToList(); foreach (var item in data) { RawMaterialsModel model = new RawMaterialsModel(); model.RawMaterialId = item.RawMaterialId; model.Name = item.Name; model.RawCategoryId = item.rawcategoryId; model.RawCategoryName = item.RawCategory.Name; model.Units = item.units; model.reorder = Convert.ToDecimal(item.reorder); model.Barcode = item.barcode; List.Add(model); } return(List); }