public int Update(Models.MInvoiceItems model) { Common.Logger l = new Common.Logger(); string ClassName = "CInvoicedetailId"; try { var query = from o in obj.InvoiceItems where Convert.ToString(o.id) == model.id select o; foreach (var item in query) { item.InvoicedetailId = Convert.ToInt32(model.InvoiceDetailId); item.ProductId = Convert.ToInt32(model.ProductId); item.ProductCost = model.ProductCost; } l.Print(ClassName, Common.LogPointer.Info.ToString(), "Model Values id[" + model.id + "] InvoicedetailId[" + model.InvoiceDetailId + "] ProductId[" + model.ProductId + "] ProductCost[" + model.ProductCost + "]"); obj.SubmitChanges(); l.Print(ClassName, Common.LogPointer.Info.ToString(), "Record Updated Successfully"); return(1); } catch (Exception ex) { l.Print(ClassName, Common.LogPointer.Error.ToString(), ex.ToString()); return(-1); } }
public int Save(Models.MInvoiceItems model) { Common.Logger l = new Common.Logger(); string ClassName = "CInvoicedetailId"; try { DB.InvoiceItem bs = new DB.InvoiceItem(); bs.id = Convert.ToInt32(model.id); bs.InvoicedetailId = Convert.ToInt32(model.InvoiceDetailId); bs.ProductId = Convert.ToInt32(model.ProductId); bs.ProductCost = model.ProductCost; l.Print(ClassName, Common.LogPointer.Info.ToString(), "Model Values id[" + model.id + "] InvoicedetailId[" + model.InvoiceDetailId + "] ProductId[" + model.ProductId + "] ProductCost[" + model.ProductCost + "]"); obj.InvoiceItems.InsertOnSubmit(bs); obj.SubmitChanges(); l.Print(ClassName, Common.LogPointer.Info.ToString(), "Record Inserted Successfully"); return(1); } catch (Exception ex) { l.Print(ClassName, Common.LogPointer.Error.ToString(), ex.ToString()); return(-1); } }
public List <Models.MInvoiceItems> GetAll() { List <Models.MInvoiceItems> model = new List <Models.MInvoiceItems>(); var query = from o in obj.InvoiceItems select o; foreach (var item in query) { Models.MInvoiceItems m = new Models.MInvoiceItems(); m.id = Convert.ToString(item.id); m.InvoiceDetailId = Convert.ToString(item.InvoicedetailId); m.ProductId = Convert.ToString(item.ProductId); m.ProductCost = item.ProductCost; model.Add(m); } return(model); }