public static int AddClaimType(MitchellClaim ClaimInfo, int vehicleInfoID, int lossInfoID)
{
//string ConnectionString = ConfigurationManager.ConnectionStrings["ClaimsConn"].ConnectionString;// "Data Source=(localdb)\\Projects;Initial Catalog=CFN_CCE_ServiceBroker_TRACING;Integrated Security=true;";
string ConnectionString = @"Data Source=(localdb)\ProjectsV12;Initial Catalog=MTL_ClaimData;Integrated Security=true;";
int ClaimTypeID = -1;
try
{
using (SqlConnection connection = new SqlConnection(ConnectionString))
using (SqlCommand command = new SqlCommand("dbo.[AddClaimType]", connection))
{
command.CommandType = CommandType.StoredProcedure;
command.CommandTimeout = 60;
connection.Open();
command.Parameters.AddWithValue("@ClaimNumber", ClaimInfo.ClaimNumber);
command.Parameters.AddWithValue("@ClaimantFirstName", ClaimInfo.ClaimantFirstName);
command.Parameters.AddWithValue("@ClaimantLastName", ClaimInfo.ClaimantLastName);
command.Parameters.AddWithValue("@Status", ClaimInfo.Status);
command.Parameters.AddWithValue("@LossDate", ClaimInfo.LossDate);
command.Parameters.AddWithValue("@lossInfoTypeID", lossInfoID);
command.Parameters.AddWithValue("@VehicleID", vehicleInfoID);
command.Parameters.AddWithValue("@AssignedAdjusterID", ClaimInfo.AssignedAdjusterID);
ClaimTypeID = System.Convert.ToInt32(command.ExecuteScalar());
}
}
catch (Exception)
{
throw;
}
return ClaimTypeID;
}
private MitchellClaim GetMitchellClaim(string xmlFileName)
{
var rdMitchellClaim = new MitchellClaim();
using(var stream = File.OpenRead(xmlFileName))
{
var serializer = new XmlSerializer(typeof(MitchellClaim));
rdMitchellClaim = (MitchellClaim)serializer.Deserialize(stream);
}
return rdMitchellClaim;
}