internal static DB.CustomersAndAgents_DataSet_appData.OurComoanyProfileRow Get_Select_Row_OurCompanyProfile()
{
DB.CustomersAndAgents_DataSet_appData ds = new DB.CustomersAndAgents_DataSet_appData();
Table_Adapter_OUrCompProfile.FillBy_OurCompanyProfile_Row_StoreProcedure(ds.OurComoanyProfile, 1);
var CustrowQuery = (from o in ds.OurComoanyProfile
where (o.ID == 1)
select o).FirstOrDefault();
return(CustrowQuery);
}
internal static DB.CustomersAndAgents_DataSet_appData.AgentsRow Select_Row_Agent(long Orignal_iD)
{
DB.CustomersAndAgents_DataSet_appData ds = new DB.CustomersAndAgents_DataSet_appData();
Table_Adapter_Agent.FillBy_Agent_ID(ds.Agents, Orignal_iD);
var AgenttrowQuery = (from o in ds.Agents
where (o.ID == Orignal_iD)
select o).FirstOrDefault();
return(AgenttrowQuery);
}
internal static DB.CustomersAndAgents_DataSet_appData.PassportRow Get_Select_FOrWidgetRowByPassportNo_Passport(string OrignalPassportNo)
{
DB.CustomersAndAgents_DataSet_appData ds = new DB.CustomersAndAgents_DataSet_appData();
Table_Adapter_Passport.FillBy_PassportRowByPassportNoForWidgetStoreProcedure(ds.Passport, OrignalPassportNo);
var CustrowQuery = (from o in ds.Passport
where (o.PASSPORT_NO.ToLower() == OrignalPassportNo.ToLower())
select o).FirstOrDefault();
return(CustrowQuery);
}
internal static DB.CustomersAndAgents_DataSet_appData.PassportRow Get_Select_Row_Passport(long Orignal_iD)
{
DB.CustomersAndAgents_DataSet_appData ds = new DB.CustomersAndAgents_DataSet_appData();
Table_Adapter_Passport.FillBy_Passport_Row_ByCustomerid_StoreProcedure(ds.Passport, Orignal_iD);
var CustrowQuery = (from o in ds.Passport
where (o.CUSTOMER_ID == Orignal_iD)
select o).FirstOrDefault();
return(CustrowQuery);
}
internal static DB.CustomersAndAgents_DataSet_appData.CustomersRow Select_Row_Customer(long Orignal_iD)
{
DB.CustomersAndAgents_DataSet_appData ds = new DB.CustomersAndAgents_DataSet_appData();
Table_Adapter_Cust.FillBy_Customer_ID(ds.Customers,Orignal_iD);
var CustrowQuery = (from o in ds.Customers
where (o.ID == Orignal_iD)
select o).FirstOrDefault();
return CustrowQuery;
}
internal static string[] GetCategories_Coloumn()
{
DB.CustomersAndAgents_DataSet_appData aa = new DB.CustomersAndAgents_DataSet_appData();
// var aa = Table_Adapter_Packages.SelectQuery_Packages_Names_Coloumn_StoreProcedure_Func();
Table_Adapter_OtherPayable.FillBy_OtherPayable_CategoryColoum_StoreProcedure(aa.OtherPayable);
var PackagerowQuery = (from o in aa.OtherPayable
select o.CATEGORY).ToArray();
return(PackagerowQuery);
}
