//Search Claim using Claim number public claimantData SearchClaim(string Id) { claimantData newClaimData = new claimantData(); string connectionString = ConfigurationManager.ConnectionStrings["DBCS"].ConnectionString; using (SqlConnection con = new SqlConnection(connectionString)) { SqlCommand cmd = new SqlCommand("spSearchClaim", con); cmd.CommandType = CommandType.StoredProcedure; SqlDataReader reader = cmd.ExecuteReader(); SqlParameter parameterClaimNumber = new SqlParameter(); parameterClaimNumber.ParameterName = "@ClaimNumber"; parameterClaimNumber.Value = Id; cmd.Parameters.Add(parameterClaimNumber); try { con.Open(); //SqlDataReader reader = cmd.ExecuteReader(); while (reader.Read()) { newClaimData.claimNumber = reader["ClaimNumber"].ToString(); newClaimData.firstName = Convert.ToString(reader["FirstName"]); newClaimData.lastName = reader["LastName"].ToString(); newClaimData.status = reader["ClaimStatus"].ToString(); newClaimData.lossDate = Convert.ToDateTime(reader["LossDate"]); newClaimData.adjusterId = Convert.ToInt64(reader["AdjusterId"]); return newClaimData; } } catch (Exception ex) { MessageBox.Show(ex.Message); } finally { con.Close(); reader.Close(); } return newClaimData; } }
//Method to insert new claim. public void InsertClaim(claimantData newClaimantData) { string connectionString = ConfigurationManager.ConnectionStrings["DBCS"].ConnectionString; using (SqlConnection con = new SqlConnection(connectionString)) { SqlCommand cmd = new SqlCommand("spCreateClaim", con); cmd.CommandType = CommandType.StoredProcedure; SqlParameter parameterClaimNumber = new SqlParameter { ParameterName = "@ClaimNumber", Value = newClaimantData.claimNumber }; cmd.Parameters.Add(parameterClaimNumber); SqlParameter parameterFirstName = new SqlParameter { ParameterName = "@FirstName", Value = newClaimantData.firstName }; cmd.Parameters.Add(parameterFirstName); SqlParameter parameterLastName = new SqlParameter { ParameterName = "@LastName", Value = newClaimantData.lastName }; cmd.Parameters.Add(parameterLastName); SqlParameter parameterClaimStatus = new SqlParameter { ParameterName = "@ClaimStatus", Value = newClaimantData.status }; cmd.Parameters.Add(parameterClaimStatus); SqlParameter parameterLossDate = new SqlParameter { ParameterName = "@LossDate", Value = newClaimantData.lossDate }; cmd.Parameters.Add(parameterLossDate); SqlParameter parameterAdjusterId = new SqlParameter { ParameterName = "@AdjusterId", Value = newClaimantData.adjusterId }; cmd.Parameters.Add(parameterAdjusterId); SqlParameter parameterCauseOfLoss = new SqlParameter { ParameterName = "@CauseOfLoss", Value = newClaimantData.causeOfLoss }; cmd.Parameters.Add(parameterCauseOfLoss); SqlParameter parameterReportedDate = new SqlParameter { ParameterName = "@ReportedDate", Value = newClaimantData.reportedDate }; cmd.Parameters.Add(parameterReportedDate); SqlParameter parameterLossDescription = new SqlParameter { ParameterName = "@LossDescription", Value = newClaimantData.lossDescription }; cmd.Parameters.Add(parameterLossDescription); SqlParameter parameterModelYear = new SqlParameter { ParameterName = "@ModelYear", Value = newClaimantData.modelYear }; cmd.Parameters.Add(parameterModelYear); SqlParameter parameterMakeDescription = new SqlParameter { ParameterName = "@MakeDescription", Value = newClaimantData.makeDescription }; cmd.Parameters.Add(parameterMakeDescription); SqlParameter parameterModelDescription = new SqlParameter { ParameterName = "@ModelDescription", Value = newClaimantData.modelDescription }; cmd.Parameters.Add(parameterModelDescription); SqlParameter parameterEngineDescription = new SqlParameter { ParameterName = "@EngineDescription", Value = newClaimantData.engineDescription }; cmd.Parameters.Add(parameterEngineDescription); SqlParameter parameterExteriorColor = new SqlParameter { ParameterName = "@ExteriorColor", Value = newClaimantData.exteriorColor }; cmd.Parameters.Add(parameterExteriorColor); SqlParameter parameterVin = new SqlParameter { ParameterName = "@Vin", Value = newClaimantData.vin }; cmd.Parameters.Add(parameterVin); SqlParameter parameterLicensePlate = new SqlParameter { ParameterName = "@LicensePlate", Value = newClaimantData.licensePlate }; cmd.Parameters.Add(parameterLicensePlate); SqlParameter parameterLicExpDate = new SqlParameter { ParameterName = "@LicPlateExpDate", Value = newClaimantData.licPlateExpDate }; cmd.Parameters.Add(parameterLicExpDate); SqlParameter parameterDamageDescription = new SqlParameter { ParameterName = "@DamageDescription", Value = newClaimantData.damageDescription }; cmd.Parameters.Add(parameterDamageDescription); SqlParameter parameterMileage = new SqlParameter { ParameterName = "@Mileage", Value = newClaimantData.mileage }; cmd.Parameters.Add(parameterMileage); try { con.Open(); cmd.ExecuteNonQuery(); } catch (Exception ex) { MessageBox.Show(ex.Message); } finally { con.Close(); } } }