public string CreateClaim(ClaimInfo claim)
{
cmd.Parameters.AddWithValue("@claimNumber", claim.ClaimNumber);
cmd.Parameters.AddWithValue("@firstName", claim.Firstname);
cmd.Parameters.AddWithValue("@lastName", claim.LastName);
cmd.Parameters.AddWithValue("@status", claim.Status);
cmd.Parameters.AddWithValue("@lossDate", claim.LossDate);
cmd.Parameters.AddWithValue("@adjusterId", claim.AdjusterId);
if (claim.lossInfo == null)
{
cmd.Parameters.AddWithValue("@lossDetails", 0);
}
else
{
cmd.Parameters.AddWithValue("@lossCause", claim.lossInfo.LossCause);
cmd.Parameters.AddWithValue("@reportedDate", claim.lossInfo.ReportedDate);
cmd.Parameters.AddWithValue("@description", claim.lossInfo.Description);
}
DataTable vehicleInfoDt = CreateVehicleInfo(claim);
if (vehicleInfoDt.Rows.Count == 0)
{
cmd.Parameters.AddWithValue("@vehicleDetails", 0);
}
cmd.Parameters.AddWithValue("@vehicleInfo", vehicleInfoDt);
return(dal.CreateClaim(cmd));
}
private DataTable CreateVehicleInfo(ClaimInfo info)
{
DataTable dt = new DataTable();
dt.Columns.Add("claimNumber", typeof(string));
dt.Columns.Add("modelYear", typeof(string));
dt.Columns.Add("make", typeof(string));
dt.Columns.Add("model", typeof(string));
dt.Columns.Add("engine", typeof(string));
dt.Columns.Add("color", typeof(string));
dt.Columns.Add("vin", typeof(string));
dt.Columns.Add("licPlate", typeof(string));
dt.Columns.Add("state", typeof(string));
dt.Columns.Add("expDate", typeof(string));
dt.Columns.Add("damage", typeof(string));
dt.Columns.Add("mileage", typeof(string));
foreach (VehicleInfo details in
info.vehicleInfoList)
{
DataRow dr = dt.NewRow();
dr[0] = info.ClaimNumber;
dr[1] = details.ModelYear;
dr[2] = details.Make;
dr[3] = details.Model;
dr[4] = details.Engine;
dr[5] = details.color;
dr[6] = details.Vin;
dr[7] = details.LicPlate;
dr[8] = details.State;
dr[9] = details.ExpDate;
dr[10] = details.Damage;
dr[11] = details.Mileage;
dt.Rows.Add(dr);
}
return(dt);
}