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