public List <Policy> getPolicyCollection()
{
_q = new QueryExecutor();
DataTable tab = _q.NonTransaction("Select * from policies");
return(DataConvertor.ConvertDataTable <Policy>(tab));
}
public List <ShopCategory> getCategories()
{
_q = new QueryExecutor();
return(DataConvertor.ConvertDataTable <ShopCategory>(
_q.NonTransaction("select * from floordetails")));
}
public List <StoreInventory> getInventory()
{
_q = new QueryExecutor();
return(DataConvertor.ConvertDataTable <StoreInventory>
(_q.NonTransaction("select * from item_inventory")));
}
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 <Material_In_Items> getMaterialInItems(int mi_number)
{
_q = new QueryExecutor();
return(DataConvertor.ConvertDataTable <Material_In_Items>(
_q.NonTransaction("select * from material_inword_items where minumber=" + mi_number)));
}
public List <StoreSupplier> GetSuppliers()
{
_q = new QueryExecutor();
return(DataConvertor.ConvertDataTable <StoreSupplier>(
_q.NonTransaction("Select * from store_suppliers")));
}
public Material_In getMaterialIn(int Min)
{
_q = new QueryExecutor();
return(DataConvertor.ConvertDataTable <Material_In>(
_q.NonTransaction("select * from material_inword where mi_number=" + Min))[0]);
}
public List <Material_In> getMaterialIn()
{
_q = new QueryExecutor();
return(DataConvertor.ConvertDataTable <Material_In>(
_q.NonTransaction("select * from material_inword")));
}
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 List <Testimonials> getTesimonials()
{
_q = new QueryExecutor();
return(DataConvertor.ConvertDataTable <Testimonials>
(_q.NonTransaction("select * from testimonials")));
}
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 <Package> getPackages()
{
_q = new QueryExecutor();
return(DataConvertor.ConvertDataTable <Package>
(_q.NonTransaction("select * from packages")));
}
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 <offerGroup> getOffers()
{
_q = new QueryExecutor();
return(ProcessData(DataConvertor.ConvertDataTable <Offer>(
_q.NonTransaction("Select * from offers"))));
}
public List <Package> getPackageDescription(int Amount)
{
_q = new QueryExecutor();
return(DataConvertor.ConvertDataTable <Package>
(_q.NonTransaction(
string.Format("select * from packages where amount='{0}'", Amount))));
}
public List <Package> getPackages_cardType(string cardType)
{
_q = new QueryExecutor();
return(DataConvertor.ConvertDataTable <Package>
(_q.NonTransaction(
string.Format("select * from packages where cardtype='{0}'", cardType))));
}
public Package getPackageByAmount(int id)
{
_q = new QueryExecutor();
return(DataConvertor.ConvertDataTable <Package>
(_q.NonTransaction(
string.Format("select * from packages where amount='{0}'", id)))[0]);
}
internal List <SliderImage> getImages()
{
_q = new QueryExecutor();
return(DataConvertor
.ConvertDataTable <SliderImage>(_q.NonTransaction(
"Select * from slider_images order by sequence")));
}
public List <CompanyProfile> GetCompanyProfiles(string cmpny)
{
_q = new QueryExecutor();
DataTable tabProfile = _q.NonTransaction(string.Format(
"Select * from companyprofile where company='{0}'", cmpny));
return(DataConvertor.ConvertDataTable <CompanyProfile>(tabProfile));
}
public List <Shop> getShops()
{
_q = new QueryExecutor();
return(DataConvertor
.ConvertDataTable <Shop>(_q
.NonTransaction("Select * from shopdetails")));
}
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));
}
internal StoreInventory getInventory_ItemCode(string id)
{
_q = new QueryExecutor();
return(DataConvertor.ConvertDataTable <StoreInventory>
(_q.NonTransaction(
string.Format("select * from item_inventory where item_code='{0}'", id)))[0]);
}
public List <UserTransaction> getUserTransactions(string CardNumber)
{
_q = new QueryExecutor();
return(DataConvertor.ConvertDataTable <UserTransaction>
(_q.NonTransaction("SELECT * FROM mis_trans_customer_cardtransaction_details " +
"where cardnumber='" + CardNumber + "' " +
"ORDER BY trans_date DESC LIMIT 90 ")));
}
public List <CardRegistration> getPolicyCards(string policyNumber)
{
_q = new QueryExecutor();
return(DataConvertor
.ConvertDataTable <CardRegistration>(_q
.NonTransaction(string
.Format("select * from cardregistration where policynumber='{0}'", policyNumber))));
}
public List <CardType> getCardTypes()
{
_q = new QueryExecutor();
DataTable tab = _q.NonTransaction("select * from cardtypes");
CardTypesCollection = new List <CardType>();
CardTypesCollection = DataConvertor.ConvertDataTable <CardType>(tab);
return(CardTypesCollection);
}
public CardType getCardTypeById(int id)
{
_q = new QueryExecutor();
DataTable tab = _q.NonTransaction("select * from cardtypes where cardTypeid=" + id);
CardTypesCollection = new List <CardType>();
CardTypesCollection = DataConvertor.ConvertDataTable <CardType>(tab);
return(CardTypesCollection[0]);
}
public WebContent getWhatsNewContent()
{
_q = new QueryExecutor();
DataTable tab = _q.NonTransaction(
string.Format("select * from web_contents where content_type='WhatsNew'"));
return(tab.Rows.Count != 0 ?
DataConvertor.ConvertDataTable <WebContent>(tab)[0] : new WebContent());
}
public CardType getCardTypeByName(string card)
{
_q = new QueryExecutor();
DataTable tab = _q.NonTransaction(
string.Format("select * from cardtypes where type='{0}'", card));
CardTypesCollection = new List <CardType>();
CardTypesCollection = DataConvertor.ConvertDataTable <CardType>(tab);
return(CardTypesCollection[0]);
}
public Shop getShopById(int id)
{
_q = new QueryExecutor();
List <Shop> result = DataConvertor
.ConvertDataTable <Shop>(_q
.NonTransaction("Select * from shopdetails where shopnumber=" + id));
return(result.Count != 0 ? result[0] : null);
}
public Shop getShopByEmail(string Email)
{
_q = new QueryExecutor();
List <Shop> result = DataConvertor
.ConvertDataTable <Shop>(_q
.NonTransaction(string.Format("Select * from shopdetails where email='{0}' or mobilenumber='{0}'", Email)));
return(result.Count != 0 ? result[0] : null);
}