public AccountVinHold GetAccountVinHoldByID(int hid)
{
AccountVinHold hold = new AccountVinHold();
string queryString = "SELECT * FROM dbo.Absences WHERE HID = @hid";
using (SqlConnection connection = new SqlConnection(GlobalVars.DBConnection["Conn"].ToString()))
{
SqlCommand command = new SqlCommand(queryString, connection);
command.Parameters.AddWithValue("@hid", hid);
try
{
connection.Open();
DataTable dt = new DataTable();
dt.Load(command.ExecuteReader());
hold = Setup(dt.Rows[0]);
}
catch (Exception ex)
{
}
finally
{
connection.Close();
}
return(hold);
}
}
public string AccountVinOnHoldReason(Absence absence)
{
string holdReason = "";
AccountVinHold _holdsRepo = new AccountVinHold();
if (absence.CustomerID != null)
{
List <AccountVinHold> holds = _holdsRepo.GetAccountVinHoldsByAccountID(absence.CustomerID);
if (holds != null && holds.Count() > 0 && absence.Type != 4001)
{
return(holds[0].Description.ToString() + " [" + GetUserByHRESID(holds[0].RequestedByID) + " " + holds[0].RequestedOn + "]");
foreach (AccountVinHold hold in holds)
{
//Dealer Account on Hold
if (hold.HoldType == 1)
{
return("Account on hold");
if (absence.CustomerID == hold.AccountNum)
{
holdReason = hold.Notes;
break;
}
}
//VIN on hold
else if (hold.HoldType == 2)
{
return("VIN on hold");
if (absence.VIN == hold.VIN)
{
holdReason = hold.Notes;
break;
}
}
//VRA on hold
else if (hold.HoldType == 3)
{
return("VRA on hold");
//might have to add VRA to absences in future?
}
}
}
}
return(holdReason);
}
public bool IsAccountVinOnHold(Absence absence)
{
bool isOnHold = false;
AccountVinHold _holdsRepo = new AccountVinHold();
if (absence.CustomerID != null)
{
List <AccountVinHold> holds = _holdsRepo.GetAccountVinHoldsByAccountID(absence.CustomerID);
if (holds != null && holds.Count > 0 && absence.Type != 4001)
{
foreach (AccountVinHold hold in holds)
{
//check to see if status is not 'released'
if (hold.Status == 1 && absence.Status != 3 /* closed */ && absence.Status != 2 /* rejected */)
{
//Dealer Account on Hold
if (hold.HoldType == 1)
{
if (absence.CustomerID == hold.AccountNum)
{
return(true);
}
}
//VIN on hold
else if (hold.HoldType == 2)
{
if (absence.VIN == hold.VIN)
{
return(true);
}
}
//VRA on hold
else if (hold.HoldType == 3)
{
//might have to add VRA to absences in future?
//return true
}
}
}
}
}
return(isOnHold);
}
} //1 = hold 3 = released
public AccountVinHold Setup(DataRow r)
{
AccountVinHold hold = new AccountVinHold();
hold.HID = Convert.ToInt32(r["HID"]);
hold.Type = Convert.ToInt32(r["Type"]);
hold.RequestedByID = Convert.ToInt32(r["EmpID"]);
hold.RequestedOn = DBNull.Value.Equals(r["StartDate"]) ? Convert.ToDateTime(r["syscreated"]) : Convert.ToDateTime(r["StartDate"]);
hold.Description = DBNull.Value.Equals(r["Description"]) ? null : r["Description"].ToString();
hold.HoldType = Convert.ToInt32(r["FreeTextField_02"]);
hold.HoldReason = r["FreeTextField_03"].ToString();
hold.AccountNum = r["CustomerID"].ToString();
hold.VIN = DBNull.Value.Equals(r["FreeTextField_01"]) ? null : r["FreeTextField_01"].ToString();
hold.VRA = DBNull.Value.Equals(r["FreeNumberField_01"]) ? -1 : Convert.ToInt32(r["FreeNumberField_01"]);
hold.Notes = DBNull.Value.Equals(r["WorkflowComments"]) ? null : r["WorkflowComments"].ToString();
hold.Status = Convert.ToInt32(r["Status"]);
return(hold);
}