public override bool LoadProparties2params(string typeOfOperation)
{
SortedList sL = new SortedList();
sL.Add("@check", typeOfOperation);
sL.Add("@username", _username);
sL.Add("@passowrd", _password);
sL.Add("@name", _name);
sL.Add("@email", _email);
sL.Add("@phone", _phone);
sL.Add("@company", _company);
sL.Add("@gender", _gender);
sL.Add("@birth_date", _birth_date);
sL.Add("@answer", _answer);
sL.Add("@quastiion", _quastion);
procedureName = "ManageUser";
if (db.RunProcedure(procedureName, sL) == 1)
{
return(true);
}
else
{
return(false);
}
}
public override bool LoadProparties2params(string typeOfOperation)
{
SortedList sL = new SortedList();
sL.Add("@check", typeOfOperation);
sL.Add("@catNo", Catno);
//sL.Add("@proID", Proid);
sL.Add("@proName", Proname);
sL.Add("@price", Price);
sL.Add("@AvQty", Avqty);
sL.Add("@proImg", ProImg);
sL.Add("@WrittingDate", Creatontime1);
sL.Add("@descrp", Description);
procedureName = "ManageProduct";
if (db.RunProcedure(procedureName, sL) == 1)
{
return(true);
}
else
{
return(false);
}
}
public override bool LoadProparties2params(string typeOfOperation)
{
SortedList sL2 = new SortedList();
sL2.Add("@check", typeOfOperation);
sL2.Add("@CatName", CatName);
sL2.Add("@des", CatDescription);
procedureName = "ManageCategory";
if (db.RunProcedure(procedureName, sL2) == 1)
{
return(true);
}
else
{
return(false);
}
}
public override bool LoadProparties2params(string typeOfOperation)
{
SortedList sL = new SortedList();
sL.Add("@check", typeOfOperation);
sL.Add("@CatNo", _CatNo);
sL.Add("@ProId", _proid);
sL.Add("@OrderNo", _orderno);
sL.Add("@quantity", _quantity);
sL.Add("@SellPrice", _sellprice);
sL.Add("@Discount", _discount);
procedureName = "ManageOrderDetailes";
if (db.RunProcedure(procedureName, sL) == 1)
{
return(true);
}
else
{
return(false);
}
}
public override bool LoadProparties2params(string typeOfOperation)
{
SortedList sL = new SortedList();
sL.Add("@check", typeOfOperation);
sL.Add("@OrderDate", Orderdate);
sL.Add("@ShipName", Shipname);
sL.Add("@ShipCity", Shipcity);
sL.Add("@ShipArea", Shiparea);
sL.Add("@shepAdress", Shipaddress);
sL.Add("@member", Username);
sL.Add("@user_id", UserID);
procedureName = "ManageOrders";
if (db.RunProcedure(procedureName, sL) == 1)
{
return(true);
}
else
{
return(false);
}
}