public HttpResponseMessage AddQuotationCoverDetails(PostQuotationCoverRequest postQuotationCoverRequest)
{
// api/QuotationCover/AddQuotationCoverDetails?jobId=54163&RevisionId=0
var uIdentity = Thread.CurrentPrincipal.Identity;
UserAccountController uc = new UserAccountController();
UserAccount user = uc.getUserFromUserName(uIdentity.Name.ToString());
QuotationMainTakafulController quotationMainController = new QuotationMainTakafulController();
QuotationMainTakaful quotationMain;
CoverController coverController = new CoverController();
List <Cover> allowedCoverList = coverController.GetAllowedCovers(user.Company);
DeleteCovers(Convert.ToInt32(postQuotationCoverRequest.JobId), Convert.ToInt32(postQuotationCoverRequest.RevisionId));
foreach (QuotationCover cover in postQuotationCoverRequest.QuotationCovers)
{
if (cover.Cover == "chk4" || cover.Cover == "chk5" || cover.Cover == "chk8")
{
if (!validateCoverAmount(cover.Cover, cover.Amount))
{
var message = string.Format("Amount of cover {0} not in the allowed range", cover.Cover);
HttpError err = new HttpError(message);
return(Request.CreateResponse(HttpStatusCode.NotAcceptable, err));
}
}
//To validate the allowed covers
var item = allowedCoverList.Find(x => x.CoverCode == cover.Cover);
if (item == null)
{
continue;
}
///////////
OracleConnection con = new OracleConnection(ConnectionString);
try
{
con.Open();
OracleCommand cmd = null;
cmd = new OracleCommand("MNB_T_INSERT_MTR_COVER_DETAILS");
cmd.CommandType = CommandType.StoredProcedure;
cmd.Connection = con;
cmd.Parameters.Add("jobid", OracleType.Int32).Value = cover.JobId;
cmd.Parameters.Add("revision_id", OracleType.VarChar).Value = cover.RevisionId;
cmd.Parameters.Add("cover", OracleType.VarChar).Value = cover.Cover;
cmd.Parameters.Add("pol_type", OracleType.VarChar).Value = cover.Type;
cmd.Parameters.Add("amount", OracleType.VarChar).Value = cover.Amount;
cmd.ExecuteNonQuery();
con.Close();
//saveDefaultCovers(postQuotationCoverRequest.JobId, user);
}
catch (Exception ex)
{
con.Close();
return(Request.CreateResponse(HttpStatusCode.ExpectationFailed));
}
}
return(Request.CreateResponse(HttpStatusCode.OK));
}
