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);
}
