public bool AddGST()
{
_q = new QueryExecutor();
return(_q.Transaction(string.Format
("insert into store_gst(gst) values ('{0}')", this.gst)) > 0);
}
public bool SaveWhatsNew()
{
bool res = false;
if (getWhatsNewContent().slno == 0)
{
_q = new QueryExecutor();
res = _q.Transaction(
string.Format("insert into web_contents(" +
"title,short_description,detailed_description,image,content_type)" +
"Values('{0}','{1}','{2}','{3}','WhatsNew')", this.title, this.short_description,
this.detailed_description, this.Image)) > 0;
}
else
{
_q = new QueryExecutor();
res = _q.Transaction(
string.Format("update web_contents set title='{0}', short_description='{1}'," +
"detailed_description='{2}',image='{3}' where content_type='WhatsNew'", this.title,
this.short_description, this.detailed_description, this.Image)) > 0;
}
return(res);
}
public bool AddUOM()
{
_q = new QueryExecutor();
return(_q.Transaction(string.Format
("insert into uom(uom) values ('{0}')", this.Uom)) > 0);
}
public bool AddImage()
{
_q = new QueryExecutor();
return(_q.Transaction(
"insert into slider_images (image,sequence) values ('" + this.Image + "'," + this.sequence + ")") > 0);
}
public bool Delete(string id)
{
_q = new QueryExecutor();
return(_q.Transaction(string.Format
("delete from uom where uom='{0}'", id)) > 0);
}
public bool RemoveImage(int Slno)
{
_q = new QueryExecutor();
return(_q.Transaction(
"delete from slider_images where slno=" + Slno) > 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 bool RemoveOffer()
{
_q = new QueryExecutor();
return(_q.Transaction(
string.Format("delete from offers where offerid={0}", this.offerid)) > 0);
}
public bool removeMaterialInItem(int slno)
{
_q = new QueryExecutor();
return(_q.Transaction(
string.Format("delete from material_inword_items where slno={0}", slno)) > 0);
}
public bool AddCategory()
{
_q = new QueryExecutor();
return(_q.Transaction(string.Format
("insert into store_categories(category) values ('{0}')", this.Category)) > 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 updatePackageStatus(bool status)
{
_q = new QueryExecutor();
return(Convert.ToBoolean
(_q.Transaction(
string.Format("Update packages set isactive='{0}' where slno={1}", status, this.slno))));
}
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);
}
internal object acivateAccount(string cardNumber)
{
_q = new QueryExecutor();
return(_q.Transaction(
string.Format("Update cardregistration " +
"set isactive='true' where cardnumber='{0}'",
cardNumber)) > 0);
}
public bool UpdateBalanceDebit(decimal amount)
{
_q = new QueryExecutor();
return(_q.Transaction(
string.Format("Update cardregistration " +
"set balance=balance-{0} where cardnumber='{1}'",
amount, this.CardNumber)) > 0);
}
public bool DeletePackage(int id)
{
_q = new QueryExecutor();
return(_q.Transaction
(string.Format(
"delete from packages where slno={0}", id)) > 0);
}
public bool Update(decimal id)
{
_q = new QueryExecutor();
return(_q.Transaction(
string.Format
("Update companyprofile set branchname=")) > 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);
}
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 bool AddPackage()
{
_q = new QueryExecutor();
return(_q.Transaction
(string.Format(
"insert into packages(cardtype,amount,\"desc\",type,payableamt)" +
"values ('{0}',{1},'{2}','{3}',{4})", this.CardType, this.Amount, this.Desc, this.Type, this.payAbleAmt)) > 0);
}
internal bool updateProfile()
{
_q = new QueryExecutor();
return(_q.Transaction(
string.Format("Update cardregistration " +
"set name='{0}',email='{1}',birthdate='{2}',address='{3}' " +
"where cardnumber='{4}'", this.Name,
this.Email, this.birthDate, this.Address, this.CardNumber)) > 0);
}
public bool updateCardType(int id)
{
_q = new QueryExecutor();
return(_q.Transaction(
string.Format(
"Update cardtypes set type='{0}' , value={1}, discount={2} where cardtypeid={3}"
, this.Type.ToUpper(), this.value, this.discount, id)) > 0);
}
public bool deleteCardType(int id)
{
_q = new QueryExecutor();
return(_q.Transaction(
string.Format(
"Delete from cardtypes where cardtypeid={0}"
, id)) > 0);
}
public bool UpdatePackage(int id)
{
_q = new QueryExecutor();
return(_q.Transaction
(string.Format(
"Update packages set cardtype='{0}',amount={1}," +
"\"desc\"='{2}',payableamt='{3}' where slno={4}", this.CardType, this.Amount, this.Desc, this.payAbleAmt, id)) > 0);
}
public bool Save()
{
_q = new QueryExecutor();
return(_q.Transaction(
string.Format(
"insert into cardtypes (type,value,discount)" +
"values ('{0}',{1},{2})"
, this.Type.ToUpper(), this.value, this.discount)) > 0);
}
public bool AddSupplier()
{
_q = new QueryExecutor();
return(_q.Transaction(
string.Format("insert into store_suppliers(" +
"name,mobile_number,address,pincode,gstin)VALUES(" +
"'{0}','{1}','{2}','{3}','{4}')", this.Name, this.Mobile_Number,
this.Address, this.pinCode, this.GSTIN)) > 0);
}
public bool AddRefundRequest()
{
_q = new QueryExecutor();
return(_q.Transaction(
string.Format(
"insert into refunds (refunddate,bank,acc_number,acc_name,ifsc,branch,reason,cardtype,cardnumber)" +
"values ('{0}','{1}','{2}','{3}','{4}','{5}','{6}','{7}','{8}')",
this.refundDate, this.Bank, this.acc_number, this.acc_name, this.ifsc, this.Branch, this.Reason, cardType, this.cardNumber)) > 0);
}
public bool makeRecharge()
{
_q = new QueryExecutor();
return(_q.Transaction(
string.Format("INSERT INTO public.recharges(" +
"cardnumber, amount, rechargedate, cardtype, description, rechargetime, rechargedby)" +
"VALUES ('{0}', '{1}', '{2}', '{3}','{4}', '{5}', '{6}')", this.CardNumber, this.Amount, this.RechargeDate,
this.CardType, this.Description, this.RechargeTime, this.RechargedBy)) > 0);
}
public bool Save()
{
_q = new QueryExecutor();
return(_q.Transaction(
string.Format
("insert into companymaster (company,headoffice,state,city,logo,pincode,website)" +
"values('{0}','{1}','{2}','{3}','{4}','{5}','{6}')"
, this.company.Trim().ToUpper(), this.headOffice, this.State, this.City, this.Logo, this.PinCode, this.Website)) > 0);
}
