public List <SupllierDataView> GetAllSuplliers()
{
List <SupllierDataView> supllier = new List <SupllierDataView>();
using (mydbEntities db = new mydbEntities())
{
SupllierDataView SR;
var sups = db.Suplliers.ToList();
if (sups != null)
{
foreach (Supllier s in sups)
{
SR = new SupllierDataView();
SR.SupllierID = s.SupllierID;
SR.SupllierName = s.SupllierName;
SR.SupllierPhone = s.SupllierPhone;
SR.SupllierAddress = s.SupllierAddress;
supllier.Add(SR);
}
}
}
return(supllier);
}
public List <SupllierDataView> GetAllSupplierByName(string name)
{
List <SupllierDataView> Supllier = new List <SupllierDataView>();
List <Supllier> pList = new List <Supllier>();
using (mydbEntities db = new mydbEntities())
{
SupllierDataView PSR = new SupllierDataView();
var p1 = db.Suplliers.Where(o => o.SupllierName.Contains(name));
if (p1.Any())
{
pList = p1.ToList();
foreach (Supllier p in pList)
{
SupllierDataView PR = new SupllierDataView();
PR.SupllierID = p.SupllierID;
PR.SupllierName = p.SupllierName;
PR.SupllierPhone = p.SupllierPhone;
PR.SupllierAddress = p.SupllierAddress;
Supllier.Add(PR);
}
}
}
return(Supllier);
}
public ActionResult UpdateSupllierData(int id, string sName, string sPhone, string address)
{
SupllierDataView SDV = new SupllierDataView();
SDV.SupllierID = id;
SDV.SupllierName = sName;
SDV.SupllierPhone = sPhone;
SDV.SupllierAddress = address;
UserManager UM = new UserManager();
UM.UpdateSupllier(SDV);
return(Json(new { success = true }));
}
public void AddSupllier(SupllierDataView supllier)
{
using (mydbEntities db = new mydbEntities())
{
var intIdt = db.Suplliers.Max(u => (int)u.SupllierID);
Supllier SR = new Supllier();
SR.SupllierID = intIdt + 1;
SR.SupllierName = supllier.SupllierName;
SR.SupllierPhone = supllier.SupllierPhone;
SR.SupllierAddress = supllier.SupllierAddress;
db.Suplliers.Add(SR);
db.SaveChanges();
}
}
public void UpdateSupllier(SupllierDataView supllier)
{
using (mydbEntities db = new mydbEntities())
{
using (var dbContextTransaction = db.Database.BeginTransaction())
{
try
{
Supllier SU = db.Suplliers.Find(supllier.SupllierID);
SU.SupllierName = supllier.SupllierName;
SU.SupllierPhone = supllier.SupllierPhone;
SU.SupllierAddress = supllier.SupllierAddress;
db.SaveChanges();
dbContextTransaction.Commit();
}
catch
{
dbContextTransaction.Rollback();
}
}
}
}
