public DataSet GetMainMenuDetails(int MainMenuID) { Hashtable ht = new Hashtable(); ht.Add("@MainMenuID", MainMenuID); return(objUtilities.ExecuteDataSet("GetMainMenuDetails", ht)); }
public DataSet GetAllInvoices(string InvoiceNum) { Hashtable hashtable = new Hashtable(); hashtable.Add("@InvoiceNum", InvoiceNum); DataSet ds = dataUtilities.ExecuteDataSet("GetPaymentByInvoice", hashtable); return(ds); }
public DataSet GetFollowupUpdates(int ClientServiceID) { Hashtable hashtable = new Hashtable(); hashtable.Add("@ClientServiceID", ClientServiceID); DataSet ds = dataUtilities.ExecuteDataSet("GetFollowUpUpdates", hashtable); return(ds); }
public DataSet GetLeadsList(int ID) { Hashtable hashtable = new Hashtable(); hashtable.Add("@lsID", ID); DataSet ds = dataUtilities.ExecuteDataSet("usp_GetAllLeads", hashtable); return(ds); }
public DataSet GetTypeData(string Type) { Hashtable hashtable = new Hashtable(); hashtable.Add("@Type", Type); DataSet ds = dataUtilities.ExecuteDataSet("usp_GetCostType", hashtable); return(ds); }
public DataSet GetInvoice(string ClientSRNO) { Hashtable hashtable = new Hashtable(); hashtable.Add("@ClientSRNO", ClientSRNO); DataSet ds = dataUtilities.ExecuteDataSet("GetInvoiceDetails", hashtable); return(ds); }
public DataSet GetAddressDetails(string SAID, string RSAID, string UIC) { Hashtable hashtable = new Hashtable(); hashtable.Add("@SAID", SAID); hashtable.Add("@REFSAID", RSAID); hashtable.Add("@UIC", UIC); ds = dataUtilities.ExecuteDataSet("usp_ValidateAddressDetails", hashtable); return(ds); }
public DataSet GetTrustAccountant(string ReferenceSAID, int Type) { DataSet ds = new DataSet(); Hashtable htable = new Hashtable(); htable.Add("@ReferenceSAID", ReferenceSAID); htable.Add("@Type", Type); ds = dataUtilities.ExecuteDataSet("GetTrustAccountant", htable); return(ds); }
public DataSet GetCompanyList(string SAID, string UIC) { var newLead = new List <CompanyInfoEntity>(); Hashtable hashtable = new Hashtable(); hashtable.Add("@ReferenceSAID", SAID); hashtable.Add("@UIC", UIC); DataSet ds = dataUtilities.ExecuteDataSet("GetCompanyInfo", hashtable); return(ds); }
public DataSet GetBankList(string SAID, int Type, string RefUIC) { var newBank = new List <BankInfoEntity>(); Hashtable hashtable = new Hashtable(); hashtable.Add("@ReferenceSAID", SAID); hashtable.Add("@Type", Type); hashtable.Add("@RefUIC", RefUIC); DataSet ds = dataUtilities.ExecuteDataSet("usp_GetBankDetails", hashtable); return(ds); }
public DataSet GetActivitylog() { Hashtable hashtable = new Hashtable(); DataSet ds = dataUtilities.ExecuteDataSet("GetActivityLog", hashtable); return(ds); }
public DataSet GetImagesMainMenuDetails(int MainImageId) { Hashtable ht = new Hashtable(); ht.Add("@MainImageId", MainImageId); return(objUtilities.ExecuteDataSet("GetImagesForMainMenu", ht)); }
public DataSet GetLayoutDetails(int LayoutID) { Hashtable ht = new Hashtable(); ht.Add("@LayoutID", LayoutID); return(objUtilities.ExecuteDataSet("GetLayoutDetails", ht)); }
public DataSet GetImagesSubMenuDetails(int SubMenuImageId) { Hashtable ht = new Hashtable(); ht.Add("@SubMenuImageId", SubMenuImageId); return(objUtilities.ExecuteDataSet("GetImagesForSubMenu", ht)); }
public DataSet ValidateUser(string LoginId) { Hashtable hashtable = new Hashtable(); hashtable.Add("@LoginId", LoginId); ds = dataUtilities.ExecuteDataSet("ValidateUser", hashtable); return(ds); }
public DataSet GetAllGrandChild(string RefSAID, string SAID) { Hashtable hashtable = new Hashtable(); hashtable.Add("@ReferenceSAID", RefSAID); hashtable.Add("@GrandchildrenSAID", SAID); return(dataUtilities.ExecuteDataSet("GetGrandchild", hashtable)); }
public DataSet ValidateClient(string SAID) { Hashtable hashtable = new Hashtable(); hashtable.Add("@SAID", SAID); ds = dataUtilities.ExecuteDataSet("ValidateClient", hashtable); return(ds); }
public DataSet GetAllSpouse(string RefSAID, string SAID) { Hashtable hashtable = new Hashtable(); hashtable.Add("@ReferenceSAID", RefSAID); hashtable.Add("@spouseSAID", SAID); return(dataUtilities.ExecuteDataSet("GetSpouse", hashtable)); }
public DataSet GetAllParent(string RefSAID, string SAID) { Hashtable hashtable = new Hashtable(); hashtable.Add("@ReferenceSAID", RefSAID); hashtable.Add("@ParentSAID", SAID); return(dataUtilities.ExecuteDataSet("GetParent", hashtable)); }
public DataSet GetCustomerList(int ID) { Hashtable hashtable = new Hashtable(); hashtable.Add("@TravellerId", ID); DataSet ds = dataUtilities.ExecuteDataSet("usp_GetAllCustomers", hashtable); return(ds); }
public DataSet GetPrivateBank(string ReferenceSAID) { DataSet ds = new DataSet(); Hashtable htable = new Hashtable(); htable.Add("@ReferenceSAID", ReferenceSAID); ds = dataUtilities.ExecuteDataSet("GetPrivateBank", htable); return(ds); }
public string GetData(string strMonth, string type) { Hashtable hsparams = new Hashtable(); hsparams.Add("@inMonth", strMonth); hsparams.Add("@type", type); DataSet ds = dataUtilities.ExecuteDataSet("GetReportsBydate", hsparams); return(ConvertDataTabletoJSON(ds.Tables[0])); }
public DataSet GetClientPersonal(string SAId) { DataUtilities datautilities = new DataUtilities(); Hashtable htParams = new Hashtable { { "@inSAID", SAId }, }; return(datautilities.ExecuteDataSet("GetClientPersonal", htParams)); }
public DataSet GetAllChilds(string RSAID, string SAID) { Hashtable hashtable = new Hashtable(); hashtable.Add("@ReferenceSAID", RSAID); hashtable.Add("@SAID", SAID); DataSet ds = dataUtilities.ExecuteDataSet("GetChildDetails", hashtable); return(ds); }
public DataSet GetClientRegisteredList() { Hashtable hashtable = new Hashtable(); hashtable.Add("@SAID", 0); DataSet ds = dataUtilities.ExecuteDataSet("GetAllClients", hashtable); return(ds); }
public DataSet GetServiceRequestmaster() { ds = dataUtilities.ExecuteDataSet("GetClientService"); return(ds); }
public DataSet GetClientService() { Hashtable hashtable = new Hashtable(); return(dataUtilities.ExecuteDataSet("GetClientService", hashtable)); }
public DataSet GetCountry() { ds = dataUtilities.ExecuteDataSet("GetCountry"); return(ds); }
public DataSet GetLocation() { DataSet ds = dataUtilities.ExecuteDataSet("GetLocation"); return(ds); }
public DataSet GetLeadsCount() { DataSet ds = dataUtilities.ExecuteDataSet("usp_GetLeadsCount"); return(ds); }