public int createClaim(MitchellClaimType createClaimobjDO)
{
SqlParameter[] parameters = new SqlParameter[20];
parameters[0] = new SqlParameter("@ClaimNumber", createClaimobjDO.ClaimNumber);
parameters[1] = new SqlParameter("@ClaimantFirstName", createClaimobjDO.ClaimantFirstName);
parameters[2] = new SqlParameter("@ClaimantLastName", createClaimobjDO.ClaimantLastName);
parameters[3] = new SqlParameter("@Status", createClaimobjDO.Status.ToString());
parameters[4] = new SqlParameter("@LossDate", createClaimobjDO.LossDate.ToString());
parameters[5] = new SqlParameter("@AssignedAdjusterID", createClaimobjDO.AssignedAdjusterID);
parameters[6] = new SqlParameter("@CauseOfLoss", createClaimobjDO.LossInfo.CauseOfLoss.ToString());
parameters[7] = new SqlParameter("@ReportedDate", createClaimobjDO.LossInfo.ReportedDate.ToString());
parameters[8] = new SqlParameter("@LossDescription", createClaimobjDO.LossInfo.LossDescription);
parameters[9] = new SqlParameter("@Vin", createClaimobjDO.Vehicles[0].Vin);
parameters[10] = new SqlParameter("@ModelYear", createClaimobjDO.Vehicles[0].ModelYear);
parameters[11] = new SqlParameter("@MakeDescription", createClaimobjDO.Vehicles[0].MakeDescription);
parameters[12] = new SqlParameter("@ModelDescription", createClaimobjDO.Vehicles[0].ModelDescription);
parameters[13] = new SqlParameter("@EngineDescription", createClaimobjDO.Vehicles[0].EngineDescription);
parameters[14] = new SqlParameter("@ExteriorColor", createClaimobjDO.Vehicles[0].ExteriorColor);
parameters[15] = new SqlParameter("@LicPlate", createClaimobjDO.Vehicles[0].LicPlate);
parameters[16] = new SqlParameter("@LicPlateState", createClaimobjDO.Vehicles[0].LicPlateState);
parameters[17] = new SqlParameter("@LicPlateExpDate", createClaimobjDO.Vehicles[0].LicPlateExpDate.ToString());
parameters[18] = new SqlParameter("@DamageDescription", createClaimobjDO.Vehicles[0].DamageDescription);
parameters[19] = new SqlParameter("@Mileage", createClaimobjDO.Vehicles[0].Mileage);
foreach (SqlParameter p in parameters)
{
if (p.Value == null)
{
p.Value = DBNull.Value;
}
}
return connection.ExecuteNonQuery("spi_createClaim", parameters);
}
public List<MitchellClaimType> readClaim(MitchellClaimType readClaimobjDO)
{
DataTable dt = objMitchellClaimDAL.readClaim(readClaimobjDO);
if (dt.Rows.Count >= 1)
{
ClaimType.ClaimantFirstName = dt.Rows[0]["ClaimantFirstName"].ToString();
ClaimType.ClaimantLastName = dt.Rows[0]["ClaimantLastName"].ToString();
string status = dt.Rows[0]["Status"].ToString();
ClaimType.Status = (StatusCode)Enum.Parse(typeof(StatusCode), status);
ClaimType.LossDate = Convert.ToDateTime(dt.Rows[0]["LossDate"].ToString());
ClaimType.AssignedAdjusterID = Convert.ToInt64(dt.Rows[0]["AssignedAdjusterID"].ToString());
string causeOfLoss = dt.Rows[0]["CauseOfLoss"].ToString();
lossInfo.CauseOfLoss = (CauseOfLossCode)Enum.Parse(typeof(CauseOfLossCode), causeOfLoss);
lossInfo.ReportedDate = Convert.ToDateTime(dt.Rows[0]["ReportedDate"].ToString());
lossInfo.LossDescription = dt.Rows[0]["LossDescription"].ToString();
ClaimType.LossInfo = lossInfo;
vehicleDetails.Vin = dt.Rows[0]["Vin"].ToString();
vehicleDetails.ModelYear = Convert.ToInt32(dt.Rows[0]["ModelYear"].ToString());
vehicleDetails.MakeDescription = dt.Rows[0]["MakeDescription"].ToString();
vehicleDetails.ModelDescription = dt.Rows[0]["ModelDescription"].ToString();
vehicleDetails.EngineDescription = dt.Rows[0]["EngineDescription"].ToString();
vehicleDetails.ExteriorColor = dt.Rows[0]["ExteriorColor"].ToString();
vehicleDetails.LicPlate = dt.Rows[0]["LicPlate"].ToString();
vehicleDetails.LicPlateState = dt.Rows[0]["LicPlateState"].ToString();
vehicleDetails.LicPlateExpDate = Convert.ToDateTime(dt.Rows[0]["LicPlateExpDate"].ToString());
vehicleDetails.DamageDescription = dt.Rows[0]["DamageDescription"].ToString();
vehicleDetails.Mileage = Convert.ToInt32(dt.Rows[0]["Mileage"].ToString());
vehicleInfoTypeList.Add(vehicleDetails);
ClaimType.Vehicles = vehicleInfoTypeList.ToArray();
collection.Add(ClaimType);
}
return collection;
}
public List<VehicleInfoType> readSpecificVehicle(MitchellClaimType readSpecificVehicleobjDO)
{
return objMitchellClaimBLL.readSpecificVehicle(readSpecificVehicleobjDO);
}
public List<MitchellClaimType> readClaim(MitchellClaimType readClaimobjDO)
{
return objMitchellClaimBLL.readClaim(readClaimobjDO);
}
public int deleteClaim(MitchellClaimType deleteClaimobjDO)
{
return objMitchellClaimBLL.deleteClaim(deleteClaimobjDO);
}
public int deleteClaim(MitchellClaimType deleteClaimobjDO)
{
int result = objMitchellClaimDAL.deleteClaim(deleteClaimobjDO);
return result;
}
public List<VehicleInfoType> readSpecificVehicle(MitchellClaimType readSpecificVehicleobjDO)
{
DataTable dt = objMitchellClaimDAL.readSpecificVehicle(readSpecificVehicleobjDO);
if (dt.Rows.Count >= 1)
{
vehicleDetails.Vin = dt.Rows[0]["Vin"].ToString();
vehicleDetails.ModelYear = Convert.ToInt32(dt.Rows[0]["ModelYear"].ToString());
vehicleDetails.MakeDescription = dt.Rows[0]["MakeDescription"].ToString();
vehicleDetails.ModelDescription = dt.Rows[0]["ModelDescription"].ToString();
vehicleDetails.EngineDescription = dt.Rows[0]["EngineDescription"].ToString();
vehicleDetails.ExteriorColor = dt.Rows[0]["ExteriorColor"].ToString();
vehicleDetails.LicPlate = dt.Rows[0]["LicPlate"].ToString();
vehicleDetails.LicPlateState = dt.Rows[0]["LicPlateState"].ToString();
vehicleDetails.LicPlateExpDate = Convert.ToDateTime(dt.Rows[0]["LicPlateExpDate"].ToString());
vehicleDetails.DamageDescription = dt.Rows[0]["DamageDescription"].ToString();
vehicleDetails.Mileage = Convert.ToInt32(dt.Rows[0]["Mileage"].ToString());
vehicleInfoTypeList.Add(vehicleDetails);
}
return vehicleInfoTypeList;
}
public DataTable readSpecificVehicle(MitchellClaimType readSpecificVehicleobjDO)
{
SqlParameter[] paramaters = new SqlParameter[1];
paramaters[0] = new SqlParameter("@claimNumber", readSpecificVehicleobjDO.ClaimNumber);
return connection.ExecuteReader("sps_readSpecificVehicle", paramaters);
}
public int deleteClaim(MitchellClaimType deleteClaimobjDO)
{
SqlParameter[] paramaters = new SqlParameter[1];
paramaters[0] = new SqlParameter("@claimNumber", deleteClaimobjDO.ClaimNumber);
return connection.ExecuteNonQuery("sps_deleteClaim", paramaters);
}
