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