internal static string[] Get_CompanyName_And_ID_Coloumn(bool _origNalStatus)
{
DB.CustomersAndAgents_DataSet_appData aa = new CustomersAndAgents_DataSet_appData();
Table_Adapter_Main_comp.FillBy_ID_andCompanyName_Column_by_Status(aa.MainCompany, _origNalStatus);
var gg = (from o in aa.MainCompany
select string.Concat(o.COMPANY_NAME, '-', o.ID)).ToArray();
return(gg);
}
internal static CustomersAndAgents_DataSet_appData.MainCompanyRow Get_CompanyRow(long companyid)
{
CustomersAndAgents_DataSet_appData ds = new CustomersAndAgents_DataSet_appData();
Table_Adapter_Main_comp.FillBy_CompanyRow_By_Id_StoreProcedure(ds.MainCompany, companyid);
var gg = (from o in ds.MainCompany
where (o.ID == companyid)
select o).FirstOrDefault();
return(gg);
}
internal static bool Get_CompanyStatus(long orignalId)
{
bool status = (bool)Table_Adapter_Main_comp.ScalarQuery_Get_Company_Status_By_Id_StoreProcedure_Func(orignalId);
return(status);
}
internal static void UpdateCompanyStatus(bool newstatus, long orignalId)
{
Table_Adapter_Main_comp.UpdateQuery_Company_Status_StoreProcedure_Func(newstatus, orignalId);
}
internal static void UpdateCompany_Info(string CompanyName, string ownerName, string address, string company_mobile, string ownerMobile, string extraMobile, string email, string extraEmail, string extraDetails, long orignalId)
{
Table_Adapter_Main_comp.UpdateQuery_Company_info_StoreProcedure_Func(CompanyName, ownerName, address, company_mobile, ownerMobile, extraMobile, email, extraEmail, extraDetails, orignalId);
}
internal static void NewCompany(string CompanyName, string ownerName, string address, string company_mobile, string ownerMobile, string extraMobile, string email, string extraEmail, string extraDetails)
{
Table_Adapter_Main_comp.Insert(CompanyName, ownerName, address, company_mobile, ownerMobile, extraMobile, email, extraEmail, DateTime.Today, extraDetails, true);
}
