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); }