public static Boolean CreateSupply(Supplier supply) { Boolean flag = false; if (!(IsExistingSupply(supply))) { using (TransactionScope scope = new TransactionScope()) { using (var context = new SycousCon()) { try { context.Suppliers.AddObject(supply); context.SaveChanges(); scope.Complete(); context.AcceptAllChanges(); flag = true; } catch (Exception ex) { context.Dispose(); throw; } } } } return flag; }
public IHttpActionResult PostSupplier(Supplier supplier) { DAL.Supplier model = new DAL.Supplier(); // model = db.Suppliers.Where(s => s.Id == supplier.Id).FirstOrDefault(); model.Code = supplier.Code; model.ContactNumber = supplier.ContactNumber; model.CorrespondanceAddress1 = supplier.CorrespondanceAddress1; model.CorrespondanceAddress2 = supplier.CorrespondanceAddress2; model.CorrespondanceAddress3 = supplier.CorrespondanceAddress3; model.CorrespondanceCity = supplier.CorrespondanceCity; model.CorrespondanceCountry = supplier.CorrespondanceCountry; model.CorrespondancePostalCode = supplier.CorrespondancePostalCode; model.FaxNumber = supplier.FaxNumber; model.Id = supplier.Id; model.Limit = supplier.Limit; model.LogId = supplier.LogId; model.Name = supplier.Name; model.PermanentAddress1 = supplier.PermanentAddress1; model.PermanentAddress2 = supplier.PermanentAddress2; model.PermanentAddress3 = supplier.PermanentAddress3; model.PermanentCity = supplier.PermanentCity; model.PermanentCountry = supplier.PermanentCountry; model.PermanentPostalCode = supplier.PermanentPostalCode; model.RegistrationDate = supplier.RegistrationDate; model.CreatedOn = System.DateTime.UtcNow; model.UpdatedOn = System.DateTime.UtcNow; model.IsActive = true; db.Suppliers.Add(model); db.SaveChanges(); return(Ok(true)); }
public bool deleteSupplier(Supplier sDel) { try { Supplier s = getSupplier(sDel).First(); ContextDB.Suppliers.DeleteObject(s); ContextDB.SaveChanges(); return true; } catch (Exception e) { return false; } }
public static Supplier EditSupply(Int64 SupplyId) { Supplier supply = new Supplier(); using (var context = new SycousCon()) { try { supply = context.Suppliers.SingleOrDefault(s => s.ID == SupplyId); } catch (Exception ex) { context.Dispose(); throw; } } return supply; }
public static bool IsExistingSupply(Supplier supply) { using (var context = new SycousCon()) { try { Supplier objsupply = context.Suppliers.SingleOrDefault(p => p.ClientID == supply.ClientID && p.IsDeleted == 0 && p.SiteID == supply.SiteID && p.EnergyID == supply.EnergyID && p.UnitID == supply.UnitID); if (objsupply != null) { return true; } else { return false; } } catch (Exception ex) { context.Dispose(); throw; } } }
public static Boolean UpdateSupply(Supplier supply) { using (TransactionScope scope = new TransactionScope()) { Boolean bol = false; using (var context = new SycousCon()) { try { var Update = context.Suppliers.Where(c => c.ID == supply.ID); foreach (Supplier p in Update) { if (supply.ClientID != null) { p.ClientID = supply.ClientID; } if (supply.SiteID != null) { p.SiteID = supply.SiteID; } if (supply.EnergyID != null) { p.EnergyID = supply.EnergyID; } if (supply.UnitID != null) { p.UnitID = supply.UnitID; } if (supply.Volume != null) { p.Volume = supply.Volume; } else { p.Volume = null; } p.ModifyDate = DateTime.Now; p.ModifyBy = supply.ModifyBy; }// context.SaveChanges(); context.AcceptAllChanges(); scope.Complete(); context.Dispose(); bol = true; } catch (Exception ex) { context.Dispose(); throw; } }// using return bol; } //trans }
public List<Supplier> getSupplier(Supplier supplierVal) { var sp = from s in ContextDB.Suppliers where (s.Supplier_ID == supplierVal.Supplier_ID || supplierVal.Supplier_ID == null) && (s.Supplier_Name == supplierVal.Supplier_Name || supplierVal.Supplier_Name == null) && (s.Context_Name == supplierVal.Context_Name || supplierVal.Context_Name == null) && (s.Phone_No == supplierVal.Phone_No || supplierVal.Phone_No == null) && (s.Fax_No == supplierVal.Fax_No || supplierVal.Fax_No == null) && (s.Address == supplierVal.Address || supplierVal.Address == null) &&(s.Email==supplierVal.Email||supplierVal.Email==null) select s; return sp.ToList<Supplier>(); }
public void createSupplier(Supplier s) { ContextDB.Suppliers.AddObject(s); ContextDB.SaveChanges(); }
//public Supplier getSupplier(Supplier supplierVal) //{ // var sp = from s in ContextDB.Suppliers // where (s.Supplier_ID == supplierVal.Supplier_ID || supplierVal.Supplier_ID == null) // && (s.Supplier_Name == supplierVal.Supplier_Name || supplierVal.Supplier_Name == null) // && (s.Context_Name == supplierVal.Context_Name || supplierVal.Context_Name == null) // && (s.Phone_No == supplierVal.Phone_No || supplierVal.Phone_No == null) // && (s.Fax_No == supplierVal.Fax_No || supplierVal.Fax_No == null) // && (s.Address == supplierVal.Address || supplierVal.Address == null) // select s; // return sp.First(); //} public bool updateSupplierData(Supplier supplier) { Supplier sp = ContextDB.Suppliers.SingleOrDefault(p => p.Supplier_ID == supplier.Supplier_ID); sp.Supplier_ID = supplier.Supplier_ID; sp.Supplier_Name = supplier.Supplier_Name; sp.Phone_No = supplier.Phone_No; sp.Fax_No = supplier.Fax_No; sp.Address = supplier.Address; sp.Email = sp.Email; ContextDB.SaveChanges(); return true; }
public void Add(Supplier supplier) { context.Suppliers.Add(supplier); context.SaveChanges(); }
/// <summary> /// 新增信息 /// </summary> /// <param name="supplier">模型</param> /// <returns>受影响行数</returns> public int InsSupplier(Supplier supplier) { string sql = @"INSERT INTO T_Supplier(Su_Name , Su_Phone , Su_Address , Su_fax , Su_Email , Su_Bankaccounts , Su_Bank , Su_Profession , Su_ProCode , Su_Credit , Su_Money , Su_Surplus , Su_Reckoning , Su_Empname , Su_EmpPhone , Su_Remark , Su_Enable , Su_Clear , Su_Code , Su_Area) VALUES(@Su_Name , @Su_Phone , @Su_Address , @Su_fax , @Su_Email , @Su_Bankaccounts , @Su_Bank , @Su_Profession , @Su_ProCode , @Su_Credit , @Su_Money , @Su_Surplus , @Su_Reckoning , @Su_Empname , @Su_EmpPhone , @Su_Remark , @Su_Enable , @Su_Clear , @Su_Code , @Su_Area)"; SqlParameter[] sps = { new SqlParameter("@Su_Name", XYEEncoding.strCodeHex(supplier.Su_Name)), new SqlParameter("@Su_Phone", XYEEncoding.strCodeHex(supplier.Su_Phone)), new SqlParameter("@Su_Address", XYEEncoding.strCodeHex(supplier.Su_Address)), new SqlParameter("@Su_fax", XYEEncoding.strCodeHex(supplier.Su_fax)), new SqlParameter("@Su_Email", XYEEncoding.strCodeHex(supplier.Su_Email)), new SqlParameter("@Su_Bankaccounts", XYEEncoding.strCodeHex(supplier.Su_Bankaccounts)), new SqlParameter("@Su_Bank", XYEEncoding.strCodeHex(supplier.Su_Bank)), new SqlParameter("@Su_Profession", XYEEncoding.strCodeHex(supplier.Su_Profession)), new SqlParameter("@Su_ProCode", XYEEncoding.strCodeHex(supplier.Su_ProCode)), new SqlParameter("@Su_Credit", XYEEncoding.strCodeHex(supplier.Su_Credit)), new SqlParameter("@Su_Money", XYEEncoding.strCodeHex(supplier.Su_Money)), new SqlParameter("@Su_Surplus", XYEEncoding.strCodeHex(supplier.Su_Surplus)), new SqlParameter("@Su_Reckoning", XYEEncoding.strCodeHex(supplier.Su_Reckoning)), new SqlParameter("@Su_Empname", XYEEncoding.strCodeHex(supplier.Su_Empname)), new SqlParameter("@Su_EmpPhone", XYEEncoding.strCodeHex(supplier.Su_EmpPhone)), new SqlParameter("@Su_Remark", XYEEncoding.strCodeHex(supplier.Su_Remark)), new SqlParameter("@Su_Enable", supplier.Su_Enable), new SqlParameter("@Su_Clear", supplier.Su_Clear), new SqlParameter("@Su_Code", XYEEncoding.strCodeHex(supplier.Su_Code)), new SqlParameter("@Su_Area", XYEEncoding.strCodeHex(supplier.Su_Area)) }; return(DbHelperSQL.ExecuteSql(sql, sps)); }
/// <summary> /// Deprecated Method for adding a new object to the Suppliers EntitySet. Consider using the .Add method of the associated ObjectSet<T> property instead. /// </summary> public void AddToSuppliers(Supplier supplier) { base.AddObject("Suppliers", supplier); }
/// <summary> /// Create a new Supplier object. /// </summary> /// <param name="supplier_ID">Initial value of the Supplier_ID property.</param> public static Supplier CreateSupplier(global::System.String supplier_ID) { Supplier supplier = new Supplier(); supplier.Supplier_ID = supplier_ID; return supplier; }
/// <summary> /// Create a new Supplier object. /// </summary> /// <param name="id">Initial value of the ID property.</param> /// <param name="isDeleted">Initial value of the IsDeleted property.</param> public static Supplier CreateSupplier(global::System.Int64 id, global::System.Int32 isDeleted) { Supplier supplier = new Supplier(); supplier.ID = id; supplier.IsDeleted = isDeleted; return supplier; }
public void Update(Supplier supplier) { context.Suppliers.Update(supplier); context.SaveChanges(); }
public Supplier getSupplierSingle(Supplier supplierVal) { var sp = from s in ContextDB.Suppliers where (s.Supplier_ID == supplierVal.Supplier_ID || supplierVal.Supplier_ID == null) && (s.Supplier_Name == supplierVal.Supplier_Name || supplierVal.Supplier_Name == null) && (s.Context_Name == supplierVal.Context_Name || supplierVal.Context_Name == null) && (s.Phone_No == supplierVal.Phone_No || supplierVal.Phone_No == null) && (s.Fax_No == supplierVal.Fax_No || supplierVal.Fax_No == null) && (s.Address == supplierVal.Address || supplierVal.Address == null) select s; return sp.First(); }
public bool updateSupplier(Supplier supplierUpdate) { try { //Supplier s = getSupplierSingle(supplierUpdate); Supplier s = new Supplier(); s.Supplier_ID = supplierUpdate.Supplier_ID; s.Supplier_Name = supplierUpdate.Supplier_Name; s.Context_Name = supplierUpdate.Context_Name; s.Phone_No = supplierUpdate.Phone_No; s.Fax_No = supplierUpdate.Fax_No; s.Address = supplierUpdate.Address; s.Email = supplierUpdate.Email; ContextDB.SaveChanges(); return true; } catch (Exception e) { return false; } }
public bool UpdateRecord(Object supplyobj) { Boolean flag = false; SupplyMaster supply = (SupplyMaster)supplyobj; try { Supplier _supply = new Supplier(); if (supply.ClientID != null) { _supply.ClientID = supply.ClientID; } if (supply.SiteID != null) { _supply.SiteID = supply.SiteID; } if (supply.UnitID != null) { _supply.UnitID = supply.UnitID; } if (supply.EnergyID != null) { _supply.EnergyID = supply.EnergyID; } if (supply.ID != null) { _supply.ID = Convert.ToInt64(supply.ID); } if (supply.Multiplier != null) { _supply.Volume = Convert.ToDecimal(supply.Multiplier); } _supply.ModifyBy = supply.ModifyBy; _supply.ModifyDate = DateTime.Now; if (_supply.ID != null) { flag = DAL.DALSupplier.UpdateSupply(_supply); } } catch (Exception ex) { throw; } return flag; }
public bool Save(Supplier obj) { return(database.ExecuteNonQuery("SaveSupplier", obj.Name, obj.Email, obj.Tel, obj.AttachmentId, obj.WardId, obj.Address, obj.TaxCode) > 0); }