/// <summary>
/// POSToAmadeusDefaultSegmentMapTbl entity list get by query
/// </summary>
/// <param name="query"></param>
/// <param name="connectionString"></param>
/// <returns></returns>
public static List <POSToAmadeusDefaultSegmentMapTbl> POSTADSMtblsGet(string query, string connectionString)
{
List <POSToAmadeusDefaultSegmentMapTbl> tbls = new List <POSToAmadeusDefaultSegmentMapTbl>();
using (SqlConnection conn = new SqlConnection(connectionString))
{
SqlCommand cmd = conn.CreateCommand();
conn.Open();
cmd.CommandText = query;
cmd.CommandTimeout = 0;
SqlDataReader reader = cmd.ExecuteReader();
POSToAmadeusDefaultSegmentMapTbl tbl;
while (reader.Read())
{
tbl = new POSToAmadeusDefaultSegmentMapTbl();
tbl.jurisdictionCode = reader["jurisdictionCode"].ToString();
tbl.companyCode = reader["companyCode"].ToString();
tbl.managementUnitCode = reader["managementUnitCode"].ToString();
tbl.OfficeID = reader["OfficeID"].ToString();
tbl.CreateDate = Convert.ToDateTime(reader["CreateDate"].ToString());
tbl.CreatedBy = reader["CreatedBy"].ToString();
tbl.UpdateDate = Convert.ToDateTime(reader["UpdateDate"].ToString());
tbl.LastUpdatedBy = reader["LastUpdatedBy"].ToString();
tbls.Add(tbl);
}
conn.Close();
}
return(tbls);
}
/// <summary>
/// db query get
/// </summary>
/// <param name="searchTbl"></param>
/// <returns></returns>
public static string TBLQueryGet(POSToAmadeusDefaultSegmentMapTbl searchTbl)
{
return(string.Format("select * from PoSToAmadeusDefaultSegmentMap where 1=1 {0} {1} {2} {3}"
, CarSCSCommonHelper.SubConditionQueryGet <string>(searchTbl.OfficeID, "and OfficeID", noReturnIfNoValue: true)
, CarSCSCommonHelper.SubConditionQueryGet <string>(searchTbl.jurisdictionCode, "and jurisdictionCode", noReturnIfNoValue: true)
, CarSCSCommonHelper.SubConditionQueryGet <string>(searchTbl.companyCode, "and companyCode", noReturnIfNoValue: true)
, CarSCSCommonHelper.SubConditionQueryGet <string>(searchTbl.managementUnitCode, "and managementUnitCode", noReturnIfNoValue: true)));
}
/// <summary>
/// check if POSConfiguration info exists
/// </summary>
/// <param name="jurisdictionCode"></param>
/// <param name="companyCode"></param>
/// <param name="managementUnitCode"></param>
/// <returns></returns>
public bool isEgenciaPOS(string jurisdictionCode, string companyCode, string managementUnitCode)
{
bool isEgenciaPOS = false;
POSToAmadeusDefaultSegmentMapTbl searchTbl = new POSToAmadeusDefaultSegmentMapTbl(jCode: jurisdictionCode, cCode: companyCode, mUnitCode: managementUnitCode);
List <POSToAmadeusDefaultSegmentMapTbl> tbls = POSTADSMtblsGet(TBLQueryGet(searchTbl), this.ConnectionString);
if (tbls.Count > 0)
{
isEgenciaPOS = true;
}
return(isEgenciaPOS);
}
/// <summary>
/// get POSConfiguration info by officeid
/// </summary>
/// <param name="officeID"></param>
/// <param name="jurisdictionCode"></param>
/// <param name="companyCode"></param>
/// <param name="managementUnitCode"></param>
public void POSByOfficeIDGet(string officeID, out string jurisdictionCode, out string companyCode, out string managementUnitCode)
{
jurisdictionCode = "";
companyCode = "";
managementUnitCode = "";
POSToAmadeusDefaultSegmentMapTbl searchTbl = new POSToAmadeusDefaultSegmentMapTbl(officeID: officeID);
List <POSToAmadeusDefaultSegmentMapTbl> tbls = POSTADSMtblsGet(TBLQueryGet(searchTbl), this.ConnectionString);
if (tbls.Count > 0)
{
int lastIndex = tbls.Count - 1;
jurisdictionCode = tbls[lastIndex].jurisdictionCode;
companyCode = tbls[lastIndex].companyCode;
managementUnitCode = tbls[lastIndex].managementUnitCode;
}
}
