public void Update(string ColorsName, int id)
{
ALKPowerEntities db = new ALKPowerEntities();
try { db.usp_UpdateNewColors(ColorsName, id); }
catch { }
finally { db.Dispose(); }
}
public void Delete(int id)
{
ALKPowerEntities db = new ALKPowerEntities();
try{ db.usp_DeleteOrder(id); }
catch { }
finally{ db.Dispose(); }
}
public void Insert(string status)
{
ALKPowerEntities db = new ALKPowerEntities();
try { db.usp_InsertORderStus(status); }
catch { }
finally { db.Dispose(); }
}
public void Update(string carModel, int brandID, string motorCap, string man_Year, int id)
{
ALKPowerEntities db = new ALKPowerEntities();
try { db.usp_UpdateCarsByID(carModel, brandID, motorCap, man_Year, id); }
catch { }
finally { db.Dispose(); }
}
public void Insert(string brandName)
{
ALKPowerEntities db = new ALKPowerEntities();
try { db.usp_InsertBrandsByID(brandName); }
catch { }
finally { db.Dispose(); }
}
public void Insert(string AreaName, int cityID)
{
ALKPowerEntities db = new ALKPowerEntities();
try { db.usp_InsertNewArea(AreaName, cityID); }
catch { }
finally { db.Dispose(); }
}
public List <usp_SelectAllCars_Result> SelectAll()
{
ALKPowerEntities db = new ALKPowerEntities();
try { return(db.usp_SelectAllCars().ToList()); }
catch { return(null); }
finally { db.Dispose(); }
}
public void Update(string client_Name, string client_Mobil, string client_WhatusApp, int?clientAreaID, int?client_CatID, int?howDidYouKnowus, int?branchID, int id)
{
ALKPowerEntities db = new ALKPowerEntities();
try { db.usp_UpdateNewClient(client_Name, client_Mobil, client_WhatusApp, clientAreaID, client_CatID, howDidYouKnowus, branchID, id); }
catch { }
finally { db.Dispose(); }
}
public List <usp_SelectAllClientsByMobil_Result> SearchByMobil(string mobil)
{
ALKPowerEntities db = new ALKPowerEntities();
try { return(db.usp_SelectAllClientsByMobil(mobil).ToList()); }
catch { return(null); }
finally { db.Dispose(); }
}
public List <usp_FilterAllClientsBybRANDID_Result> SearchByBrandID(int how)
{
ALKPowerEntities db = new ALKPowerEntities();
try { return(db.usp_FilterAllClientsBybRANDID(how).ToList()); }
catch { return(null); }
finally { db.Dispose(); }
}
public int?Max()
{
ALKPowerEntities db = new ALKPowerEntities();
try { return(db.usp_SelectMaxClientID().First()); }
catch { return(null); }
finally { db.Dispose(); }
}
public void Update(string Client_CategoryName, int id)
{
ALKPowerEntities db = new ALKPowerEntities();
try { db.usp_UpdateNewClient_Category(Client_CategoryName, id); }
catch { }
finally { db.Dispose(); }
}
public void Insert(string Client_CategoryName)
{
ALKPowerEntities db = new ALKPowerEntities();
try { db.usp_InsertNewClient_Category(Client_CategoryName); }
catch { }
finally { db.Dispose(); }
}
public void Delete(int id)
{
ALKPowerEntities db = new ALKPowerEntities();
try { db.usp_DeleteAllClient_CategoryByID(id); }
catch { }
finally { db.Dispose(); }
}
public void Update(int cLientID, int carid, string carno, int colorid, string km, int id, string cc, string v)
{
ALKPowerEntities db = new ALKPowerEntities();
try { db.usp_UpdateNewClient_Car(cLientID, carid, carno, colorid, km, id, cc, v); }
catch { }
finally { db.Dispose(); }
}
public List <usp_FilterAllClientsByAreaID_Result> SearchByArea(int area)
{
ALKPowerEntities db = new ALKPowerEntities();
try { return(db.usp_FilterAllClientsByAreaID(area).ToList()); }
catch { return(null); }
finally { db.Dispose(); }
}
public void Delete(int id)
{
ALKPowerEntities db = new ALKPowerEntities();
try { db.usp_DeleteAllBranchesByID(id); }
catch { }
finally { db.Dispose(); }
}
public void Delete(int id)
{
ALKPowerEntities db = new ALKPowerEntities();
try { db.usp_DeleteAllHowDidYouKnowUSByID(id); }
catch { }
finally { db.Dispose(); }
}
public void Update(string AreaName, int id, int cityID)
{
ALKPowerEntities db = new ALKPowerEntities();
try { db.usp_UpdateNewArea(AreaName, cityID, id); }
catch { }
finally { db.Dispose(); }
}
public void Insert(string HowDidYouKnowUSByIDName)
{
ALKPowerEntities db = new ALKPowerEntities();
try { db.usp_InsertNewHowDidYouKnowUS(HowDidYouKnowUSByIDName, 1); }
catch { }
finally { db.Dispose(); }
}
public void Insert(string carModel, int brandID, string motorCap, string man_Year)
{
ALKPowerEntities db = new ALKPowerEntities();
try { db.usp_InsertCarsByID(carModel, brandID, motorCap, man_Year); }
catch { }
finally { db.Dispose(); }
}
public void Update(string HowDidYouKnowUSByIDName, int id)
{
ALKPowerEntities db = new ALKPowerEntities();
try { db.usp_UpdateNewHowDidYouKnowUS(HowDidYouKnowUSByIDName, id); }
catch { }
finally { db.Dispose(); }
}
public List <usp_SelectAllBrandsByID_Result> SelectAll(int id)
{
ALKPowerEntities db = new ALKPowerEntities();
try { return(db.usp_SelectAllBrandsByID(id).ToList()); }
catch { return(null); }
finally { db.Dispose(); }
}
public void Insert(string ServicesName, decimal fees)
{
ALKPowerEntities db = new ALKPowerEntities();
try { db.usp_InsertNewServices(ServicesName, fees); }
catch { }
finally { db.Dispose(); }
}
public void Update(string brandName, int id)
{
ALKPowerEntities db = new ALKPowerEntities();
try { db.usp_UpdateBrandsByID(brandName, id); }
catch { }
finally { db.Dispose(); }
}
public void Update(string ServicesName, int id, decimal fees)
{
ALKPowerEntities db = new ALKPowerEntities();
try { db.usp_UpdateNewServices(ServicesName, fees, id); }
catch { }
finally { db.Dispose(); }
}
public void Update(string status, int id)
{
ALKPowerEntities db = new ALKPowerEntities();
try { db.usp_UpdateOrderStatus(status, id); }
catch { }
finally { db.Dispose(); }
}
public List <usp_SelectClientCarByClient_Result> SelectAllByCar(int Modelid)
{
ALKPowerEntities db = new ALKPowerEntities();
try { return(db.usp_SelectClientCarByClient(Modelid).ToList()); }
catch { return(null); }
finally { db.Dispose(); }
}
public void InsertNewOrder(int clientID, int orderStatusID, DateTime orderDate, int branchID, decimal totalOrder, decimal discount, decimal tax, decimal finalOrder)
{
ALKPowerEntities db = new ALKPowerEntities();
try { db.usp_InsertNewOrder(clientID, orderStatusID, orderDate, branchID, totalOrder, discount, tax, finalOrder); }
catch { }
finally { db.Dispose(); }
}
public void Insert(string ColorsName)
{
ALKPowerEntities db = new ALKPowerEntities();
try { db.usp_InsertNewColors(ColorsName, 1); }
catch { }
finally { db.Dispose(); }
}
