public bool check(string CardNumber)
{
_q = new QueryExecutor();
return(Convert.ToBoolean(_q.Aggregate(
string.Format("select count(*) from cardregistration where cardnumber='{0}'", CardNumber))));
}
public int getCount(string PolicyNumber)
{
_q = new QueryExecutor();
return(Convert.ToInt32(_q.Aggregate(
string.Format("select count(*) from cardregistration where policynumber='{0}'", PolicyNumber))));
}
public bool AddCategory()
{
_q = new QueryExecutor();
return(_q.Transaction(string.Format
("insert into store_categories(category) values ('{0}')", this.Category)) > 0);
}
public List <StoreInventory> getInventory()
{
_q = new QueryExecutor();
return(DataConvertor.ConvertDataTable <StoreInventory>
(_q.NonTransaction("select * from item_inventory")));
}
public List <Policy> getPolicyCollection()
{
_q = new QueryExecutor();
DataTable tab = _q.NonTransaction("Select * from policies");
return(DataConvertor.ConvertDataTable <Policy>(tab));
}
public List <BillingChild> getBillItems(int shopNumber, string invNumber)
{
_q = new QueryExecutor();
return(DataConvertor.ConvertDataTable <BillingChild>(
_q.NonTransaction("select * from billingchild where invoicenumber='" + invNumber + "' and shopnumber=" + shopNumber)));
}
public List <ShopCategory> getCategories()
{
_q = new QueryExecutor();
return(DataConvertor.ConvertDataTable <ShopCategory>(
_q.NonTransaction("select * from floordetails")));
}
public List <StoreSupplier> GetSuppliers()
{
_q = new QueryExecutor();
return(DataConvertor.ConvertDataTable <StoreSupplier>(
_q.NonTransaction("Select * from store_suppliers")));
}
public List <Package> getPackages()
{
_q = new QueryExecutor();
return(DataConvertor.ConvertDataTable <Package>
(_q.NonTransaction("select * from packages")));
}
public bool AddGST()
{
_q = new QueryExecutor();
return(_q.Transaction(string.Format
("insert into store_gst(gst) values ('{0}')", this.gst)) > 0);
}
public bool Delete(decimal id)
{
_q = new QueryExecutor();
return(_q.Transaction(string.Format
("delete from store_gst where gst={0}", id)) > 0);
}
public bool Delete(string id)
{
_q = new QueryExecutor();
return(_q.Transaction(string.Format
("delete from uom where uom='{0}'", id)) > 0);
}
public bool AddUOM()
{
_q = new QueryExecutor();
return(_q.Transaction(string.Format
("insert into uom(uom) values ('{0}')", this.Uom)) > 0);
}
public bool Delete(string id)
{
_q = new QueryExecutor();
return(_q.Transaction(string.Format
("delete from store_categories where category='{0}'", id)) > 0);
}
public bool DeleteSupplier(int Supplier_id)
{
_q = new QueryExecutor();
return(_q
.Transaction("delete from store_suppliers where supplier_id=" + Supplier_id) > 0);
}
public List <CompanyMaster> GetComapnyByName(string name)
{
_q = new QueryExecutor();
DataTable tab = _q.NonTransaction(string.Format("Select * from companymaster where company='{0}'", name));
return(DataConvertor.ConvertDataTable <CompanyMaster>(tab));
}
public List <CompanyMaster> GetComapnyById(decimal id)
{
_q = new QueryExecutor();
DataTable tab = _q.NonTransaction("Select * from companymaster where id=" + id);
return(DataConvertor.ConvertDataTable <CompanyMaster>(tab));
}
public List <offerGroup> getOffers()
{
_q = new QueryExecutor();
return(ProcessData(DataConvertor.ConvertDataTable <Offer>(
_q.NonTransaction("Select * from offers"))));
}
public List <VendorPayments> getVendorPayments_unpaid(int ShopNumber)
{
_q = new QueryExecutor();
return(DataConvertor.ConvertDataTable <VendorPayments>(
_q.NonTransaction("select * from vendor_payments where status='Unpaid' and shopnumber=" + ShopNumber)));
}
public bool RemoveOffer()
{
_q = new QueryExecutor();
return(_q.Transaction(
string.Format("delete from offers where offerid={0}", this.offerid)) > 0);
}
public bool RemoveImage(int Slno)
{
_q = new QueryExecutor();
return(_q.Transaction(
"delete from slider_images where slno=" + Slno) > 0);
}
public bool AddImage()
{
_q = new QueryExecutor();
return(_q.Transaction(
"insert into slider_images (image,sequence) values ('" + this.Image + "'," + this.sequence + ")") > 0);
}
public DataTable getCardTypesTable()
{
_q = new QueryExecutor();
DataTable tab = _q.NonTransaction("select * from cardtypes");
return(tab);
}
public List <Policy> getPolicyByNumber(string PolicyNumber)
{
_q = new QueryExecutor();
DataTable tab = _q.NonTransaction(
string.Format("Select * from policies where policynumber='{0}'", PolicyNumber));
return(DataConvertor.ConvertDataTable <Policy>(tab));
}
public bool AddOffer()
{
_q = new QueryExecutor();
return(_q.Transaction(
string.Format("insert into offers(category,valid_from,valid_till,image)" +
"values('{0}','{1}','{2}','{3}')", this.category, this.Valid_From, this.Valid_Till, this.Image)) > 0);
}
public List <Shop> getShops()
{
_q = new QueryExecutor();
return(DataConvertor
.ConvertDataTable <Shop>(_q
.NonTransaction("Select * from shopdetails")));
}
internal List <SliderImage> getImages()
{
_q = new QueryExecutor();
return(DataConvertor
.ConvertDataTable <SliderImage>(_q.NonTransaction(
"Select * from slider_images order by sequence")));
}
internal bool updatePin(string pin, string cardNumber)
{
_q = new QueryExecutor();
return(_q.Transaction(
string.Format("Update cardregistration " +
"set pin='{1}' where cardnumber='{0}'",
cardNumber, pin)) > 0);
}
public bool addMaterialInItem(int mi_number)
{
_q = new QueryExecutor();
return(_q.Transaction(
string.Format("insert into material_inword_items(minumber,particulars,quantity)" +
"values ({0},'{1}','{2}')", mi_number, this.particulars, this.Quantity)) > 0);
}
internal object acivateAccount(string cardNumber)
{
_q = new QueryExecutor();
return(_q.Transaction(
string.Format("Update cardregistration " +
"set isactive='true' where cardnumber='{0}'",
cardNumber)) > 0);
}