public string AddNewClaim(ClsLibraryMitchell.claMitchellClaim.MitchellClaimType mitchellClaimType) { string result = ""; result = repository.AddNewClaim(mitchellClaimType); if (mitchellClaimType.Vehicles != null) { if (mitchellClaimType.Vehicles.VehicleDetails.Length > 0) { for (int i = 0; i < mitchellClaimType.Vehicles.VehicleDetails.Length; i++) { repository.AddNewVehicle(mitchellClaimType.Vehicles.VehicleDetails[i], mitchellClaimType.ClaimNumber); } } } return result; }
public string AddNewVehicle(ClsLibraryMitchell.claMitchellClaim.VehicleInfoType vehicle, string claimNumber) { string result = ""; SqlConnection conn = new SqlConnection(this.connectionString); try { conn.Open(); string sql = "SP_ADD_NEW_VEHICLE"; SqlCommand cmd = new SqlCommand(sql, conn); cmd.CommandType = System.Data.CommandType.StoredProcedure; SqlParameter p1 = new SqlParameter("@ClaimNumber", System.Data.SqlDbType.VarChar, 200); p1.Value = claimNumber; cmd.Parameters.Add(p1); SqlParameter p2 = new SqlParameter("@ModelYear", System.Data.SqlDbType.Int, 50); p2.Value = vehicle.ModelYear; cmd.Parameters.Add(p2); SqlParameter p3 = new SqlParameter("@MakeDescription", System.Data.SqlDbType.VarChar, 50); p3.Value = vehicle.MakeDescription; cmd.Parameters.Add(p3); SqlParameter p4 = new SqlParameter("@ModelDescription", System.Data.SqlDbType.VarChar, 50); p4.Value = vehicle.ModelDescription; cmd.Parameters.Add(p4); SqlParameter p5 = new SqlParameter("@EngineDescription", System.Data.SqlDbType.VarChar, 50); p5.Value = vehicle.EngineDescription; cmd.Parameters.Add(p5); SqlParameter p6 = new SqlParameter("@ExteriorColor", System.Data.SqlDbType.VarChar, 50); p6.Value = vehicle.ExteriorColor; cmd.Parameters.Add(p6); SqlParameter p7 = new SqlParameter("@Vin", System.Data.SqlDbType.VarChar, 50); p7.Value = vehicle.Vin; cmd.Parameters.Add(p7); SqlParameter p8 = new SqlParameter("@LicPlate", System.Data.SqlDbType.VarChar, 50); p8.Value = vehicle.LicPlate; cmd.Parameters.Add(p8); SqlParameter p9 = new SqlParameter("@LicPlateState", System.Data.SqlDbType.VarChar, 50); p9.Value = vehicle.LicPlateState; cmd.Parameters.Add(p9); SqlParameter p10 = new SqlParameter("@LicPlateExpDate", System.Data.SqlDbType.Date, 50); p10.Value = vehicle.LicPlateExpDate; cmd.Parameters.Add(p10); SqlParameter p11 = new SqlParameter("@DamageDescription", System.Data.SqlDbType.VarChar, 50); p11.Value = vehicle.DamageDescription; cmd.Parameters.Add(p11); SqlParameter p12 = new SqlParameter("@Mileage", System.Data.SqlDbType.Int, 50); p12.Value = vehicle.Mileage; cmd.Parameters.Add(p12); result = "" + cmd.ExecuteNonQuery(); } catch (Exception ex) { result = ex.Message; } finally { conn.Close(); } return result; }
public string AddNewClaim(ClsLibraryMitchell.claMitchellClaim.MitchellClaimType mitchellClaimType) { string result = ""; SqlConnection conn = new SqlConnection(this.connectionString); try { conn.Open(); string sql = "SP_ADD_NEW_CLAIM"; SqlCommand cmd = new SqlCommand(sql, conn); cmd.CommandType = System.Data.CommandType.StoredProcedure; SqlParameter p1 = new SqlParameter("@ClaimNumber", System.Data.SqlDbType.VarChar, 200); p1.Value = mitchellClaimType.ClaimNumber; cmd.Parameters.Add(p1); SqlParameter p2 = new SqlParameter("@ClaimantFirstName", System.Data.SqlDbType.VarChar, 50); p2.Value = mitchellClaimType.ClaimantFirstName; cmd.Parameters.Add(p2); SqlParameter p3 = new SqlParameter("@ClaimantLastName", System.Data.SqlDbType.VarChar, 50); p3.Value = mitchellClaimType.ClaimantLastName; cmd.Parameters.Add(p3); SqlParameter p4 = new SqlParameter("@Status", System.Data.SqlDbType.VarChar, 50); p4.Value = mitchellClaimType.Status; cmd.Parameters.Add(p4); SqlParameter p5 = new SqlParameter("@LossDate", System.Data.SqlDbType.DateTime, 50); p5.Value = mitchellClaimType.LossDate; cmd.Parameters.Add(p5); SqlParameter p6 = new SqlParameter("@CauseOfLoss", System.Data.SqlDbType.VarChar, 50); p6.Value = mitchellClaimType.LossInfo.CauseOfLoss; cmd.Parameters.Add(p6); SqlParameter p7 = new SqlParameter("@ReportedDate", System.Data.SqlDbType.DateTime, 50); p7.Value = mitchellClaimType.LossInfo.ReportedDate; cmd.Parameters.Add(p7); SqlParameter p8 = new SqlParameter("@LossDescription", System.Data.SqlDbType.VarChar, 50); p8.Value = mitchellClaimType.LossInfo.LossDescription; cmd.Parameters.Add(p8); SqlParameter p9 = new SqlParameter("@AssignedAdjusterID", System.Data.SqlDbType.BigInt, 50); p9.Value = mitchellClaimType.AssignedAdjusterID; cmd.Parameters.Add(p9); result = "" + cmd.ExecuteNonQuery(); if (mitchellClaimType.Vehicles != null) { } } catch (Exception ex) { result = ex.Message; } finally { conn.Close(); } return result; }
public bool UpdateClaim(ClsLibraryMitchell.claMitchellClaim.MitchellClaimType mct) { bool result = false; List<string> updateSQLList_tblMitchellClaim = new List<string>(); List<string> updateSQLList_tblVehicle = new List<string>(); System.Reflection.FieldInfo[] mctFields = mct.GetType().GetFields(); for (int i = 0; i < mctFields.Length; i++) { if (this.HasValidValue(mctFields[i].GetValue(mct)) && mctFields[i].Name != "Vehicles" && mctFields[i].Name != "xmlns") { updateSQLList_tblMitchellClaim.Add(mctFields[i].Name + "='" + mctFields[i].GetValue(mct).ToString() + "'"); } } if (mct.Vehicles != null) { if (mct.Vehicles.VehicleDetails.Length > 0) { for (int i = 0; i < mct.Vehicles.VehicleDetails.Length; i++) { Console.WriteLine("Vehicle :" + i); System.Reflection.FieldInfo[] vehicleFields = mct.Vehicles.VehicleDetails[i].GetType().GetFields(); for (int j = 0; j < vehicleFields.Length; j++) { if (this.HasValidValue(vehicleFields[j].GetValue(mct.Vehicles.VehicleDetails[i]))) { updateSQLList_tblVehicle.Add(vehicleFields[j].Name + "= '" + vehicleFields[j].GetValue(mct.Vehicles.VehicleDetails[i]) + "'"); } } // Update DB if (updateSQLList_tblVehicle.Count > 0) { string sql = " update tblVehicles set "; for (int k = 0; k < updateSQLList_tblVehicle.Count - 1; k++) { sql += updateSQLList_tblVehicle[k] + " , "; } sql += updateSQLList_tblVehicle[updateSQLList_tblVehicle.Count - 1]; sql += " where Vin ='" + mct.Vehicles.VehicleDetails[i].Vin + "'"; repository.ExecuteNonQuery(sql); } } } } if (updateSQLList_tblMitchellClaim.Count > 0) { string sql = " update tblMitchellClaim set "; for (int i = 0; i < updateSQLList_tblMitchellClaim.Count-1; i++) { sql += updateSQLList_tblMitchellClaim[i] + " , "; } sql += updateSQLList_tblMitchellClaim[updateSQLList_tblMitchellClaim.Count - 1]; sql += " where ClaimNumber ='" + mct.ClaimNumber + "'"; repository.ExecuteNonQuery(sql); } return result; }