// Gets
public List <WarshaOffersCriteria> GetOffersByWarsha_id(int warsha_id, Enums.OfferType offerType)
{
OfferQuery offerQuery = new OfferQuery(language);
System.Data.DataTable dataTable = new System.Data.DataTable();
if (offerType == Enums.OfferType.offerNotAccepted)
{
dataTable = conn_db.ReadTable(offerQuery.GetWorkshopOfferNotAccespted(warsha_id));
}
else if (offerType == Enums.OfferType.offerAccepted)
{
dataTable = conn_db.ReadTable(offerQuery.GetWorkshopOfferAccespted(warsha_id));
}
else if (offerType == Enums.OfferType.offerIsFixing)
{
dataTable = conn_db.ReadTable(offerQuery.GetWorkshopOfferIsFixing(warsha_id));
}
else if (offerType == Enums.OfferType.offerFinishFixing)
{
dataTable = conn_db.ReadTable(offerQuery.GetWorkshopOfferFinishFixing(warsha_id));
}
if (dataTable.Rows.Count == 0)
{
throw new EmptyViewException(language);
}
WarshaOffersCriteria warshaOffersCriteria = new WarshaOffersCriteria();
List <WarshaOffersCriteria> warshaOffersCriterias = new List <WarshaOffersCriteria>();
foreach (System.Data.DataRow row in dataTable.Rows)
{
warshaOffersCriteria = new WarshaOffersCriteria();
warshaOffersCriteria.offer_id = Convert.ToInt32(row["OFFER_ID"].ToString());
warshaOffersCriteria.workshop_id = Convert.ToInt32(row["WORKSHOP_ID"].ToString());
warshaOffersCriteria.accident_Id = Convert.ToInt32(row["accidentId"].ToString());
warshaOffersCriteria.Price = row["PRICE"].ToString();
try { warshaOffersCriteria.timeValue = Convert.ToInt32(row["timeValue"]); } catch (Exception ex) { warshaOffersCriteria.timeValue = 0; }
try { warshaOffersCriteria.timeFlag = Convert.ToInt32(row["timeFlag"]); } catch (Exception ex) { warshaOffersCriteria.timeFlag = 0; }
try { warshaOffersCriteria.offerDateTime = Convert.ToDateTime(row["offer_DateTime"].ToString()).ToString("dd-MM-yyyy"); }
catch { warshaOffersCriteria.offerDateTime = "01-01-2000"; }
//IMPORTANT
//if(offerType == Enums.OfferType.offerIsFixing)
//{
// DateTime fixingStartDate = Convert.ToDateTime(row["WAITINGFIX_DATETIME"].ToString()).AddDays( Convert.ToInt32(warshaOffersCriteria.workDays+1) );
// DateTime Nowaday = DateTime.Now ;
// TimeSpan noOfDays = fixingStartDate -Nowaday ;
// if(noOfDays.Days<0)
// {
// warshaOffersCriteria.workDays = 0;
// }
// else
// {
// DateTime age = DateTime.MinValue + noOfDays;
// int days = age.Day - 1;
// warshaOffersCriteria.workDays = days;
// }
//}
warshaOffersCriteria.plateNumber = row["plateNumber"].ToString();
warshaOffersCriteria.Status = Convert.ToInt32(row["Status"].ToString());
warshaOffersCriteria.statusNameEn = row["STATUS_NAME_EN"].ToString();
warshaOffersCriteria.statusNameAr = row["STATUS_NAME_AR"].ToString();
warshaOffersCriterias.Add(warshaOffersCriteria);
}
return(warshaOffersCriterias);
}