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); }