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.TicketsRow Get_TicketRow(string OrignalPnr)
{
CustomersAndAgents_DataSet_appData ds = new CustomersAndAgents_DataSet_appData();
Table_Adapter_Ticket.FillBy_Ticket_Row_by_PNR_StoreProcedure(ds.Tickets, OrignalPnr);
var gg = (from o in ds.Tickets
where (o.PNR == OrignalPnr)
select o).FirstOrDefault();
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 CustomersAndAgents_DataSet_appData.OtherPayableRow Get_OtherPayable_Row(long OtherPayableiD)
{
CustomersAndAgents_DataSet_appData ds = new CustomersAndAgents_DataSet_appData();
Table_Adapter_OtherPayable.FillBy_OtherPayAbleRow_By_id_StoreProcedure(ds.OtherPayable, OtherPayableiD);
var gg = (from o in ds.OtherPayable
where (o.ID == OtherPayableiD)
select o).FirstOrDefault();
return(gg);
}
internal static DB.CustomersAndAgents_DataSet_appData.SaudiViasStampRow Get_SaudiVisaStamp_Row(string OrignalVisaNo)
{
CustomersAndAgents_DataSet_appData ds = new CustomersAndAgents_DataSet_appData();
Table_Adapter_SaudiVisaStamp.FillBy_Row_SaudiVisaStamp_StoreProcedure(ds.SaudiViasStamp, OrignalVisaNo);
var gg = (from o in ds.SaudiViasStamp
where (o.VISA_NO == OrignalVisaNo)
select o).FirstOrDefault();
return(gg);
}
internal static CustomersAndAgents_DataSet_appData.DubaiVisitRow Get_DubaiVisit_Row(long OrignalVisitiD)
{
CustomersAndAgents_DataSet_appData ds = new CustomersAndAgents_DataSet_appData();
Table_Adapter_DubaiVisit.FillBy_DubaiVisit_Row_By_visitiD_StoreProcedure(ds.DubaiVisit, OrignalVisitiD);
var gg = (from o in ds.DubaiVisit
where (o.VISIT_ID == OrignalVisitiD)
select o).FirstOrDefault();
return(gg);
}
internal static CustomersAndAgents_DataSet_appData.ProtectorRow Get_Protector_Row(long OrignalProtectoriD)
{
CustomersAndAgents_DataSet_appData ds = new CustomersAndAgents_DataSet_appData();
Table_Adapter_Protector.FillBy_Protector_RowBy_Protectorid_StoreProcedure(ds.Protector, OrignalProtectoriD);
var gg = (from o in ds.Protector
where (o.PROTECTOR_ID == OrignalProtectoriD)
select o).FirstOrDefault();
return(gg);
}
