public ActionResult PaymentCommitments(int Id, int?type)
{
ViewBag.Type = type;
ViewBag.Title = "Edit";
FillDropdowns();
PolicyIssue objPolicy = new PolicyIssueRepository().GetNewPolicy(Id);
objPolicy.PolicyStage = type;
objPolicy.Cheque = new List <PolicyIssueChequeReceived>();
objPolicy.Cheque.Add(new PolicyIssueChequeReceived());
if (type == 2)
{
objPolicy.Committed = new List <PaymentCommitments>();
objPolicy.Committed.Add(new PaymentCommitments());
objPolicy.Committed.Add(new PaymentCommitments());
objPolicy.Committed.Add(new PaymentCommitments());
objPolicy.Committed.Add(new PaymentCommitments());
}
else
{
objPolicy.Cheque = new PolicyIssueRepository().GetChequeDetails(Id);
objPolicy.Committed = new PolicyIssueRepository().GetCommittedDetails(Id);
}
return(View(objPolicy));
}
public ActionResult Delete(int Id)
{
ViewBag.Title = "Delete";
FillDropdowns();
PolicyIssue objPolicy = new PolicyIssueRepository().GetNewPolicy(Id);
objPolicy.Cheque = new PolicyIssueRepository().GetChequeDetails(Id);
return(View("Create", objPolicy));
}
public ActionResult PendingPolicyForPaymentDetailsGrid(string trnno = "", string client = "", string insuredname = "", string insuredComp = "", string coverage = "")
{
var griddata = new PolicyIssueRepository().GetNewPolicyForPaymentCollection(trnno, client, insuredname, insuredComp, coverage);
Session["GridDate"] = griddata;
Session["excelname"] = "PaymentDetails";
return(PartialView("_PendingPolicyForPaymentDetails", griddata));
}
public ActionResult PendingPolicyForCommitmentsGrid(string trnno = "", string client = "", string insuredname = "", string insuredComp = "", string coverage = "")
{
//return PartialView("_PendingPolicyForCommitments", new PolicyIssueRepository().GetNewPolicyForCommitments(trnno , client ,insuredname , insuredComp , coverage));
var griddata = new PolicyIssueRepository().GetNewPolicyForCommitments(UserID, UserRolename, trnno, client, insuredname, insuredComp, coverage);
Session["GridDate"] = griddata;
Session["excelname"] = "Commitments";
ViewBag.type = 2;
return(PartialView("_PendingPolicyForCommitments", griddata));
}
public ActionResult Delete(PolicyIssue model)
{
Result res = new PolicyIssueRepository().Delete(model);
if (res.Value)
{
TempData["Success"] = "Deleted Successfully!";
}
else
{
}
return(RedirectToAction("Index", new { type = model.PolicyStage }));
}
public ActionResult UpdateCommitments(PolicyIssue model)
{
Result res = new PolicyIssueRepository().UpdatePaymentCommitments(model);
if (res.Value)
{
TempData["Success"] = "Saved Successfully!";
}
else
{
}
return(RedirectToAction("Index", new { type = model.PolicyStage }));
}
public ActionResult PaymentDetails(int Id, int?type)
{
ViewBag.Type = type;
ViewBag.Title = "Edit";
FillDropdowns();
PolicyIssue objPolicy = new PolicyIssueRepository().GetNewPolicy(Id);
objPolicy.Cheque = new PolicyIssueRepository().GetChequeDetails(Id);
objPolicy.Committed = new List <PaymentCommitments>();
objPolicy.Committed.Add(new PaymentCommitments());
return(View("PaymentCommitments", objPolicy));
}
public JsonResult GetTransNum(string Id)
{
var internalid = PolicyIssueRepository.GetNextDocNo(Id);
string prefix;
if (Id == "RenewPolicy")
{
prefix = "CIB/REN/";
}
else
{
prefix = "CIB/NEW/";
}
return(Json(new { Success = true, internalid = prefix + internalid }, JsonRequestBehavior.AllowGet));
}
public ActionResult Edit(int?type, int Id)
{
ViewBag.Type = type;
ViewBag.Title = "Edit";
FillDropdowns();
PolicyIssue objPolicy = new PolicyIssueRepository().GetNewPolicy(Id);
//objPolicy.PolicyStage = type;
objPolicy.Cheque = new PolicyIssueRepository().GetChequeDetails(Id);
objPolicy.Committed = new List <PaymentCommitments>();
objPolicy.Committed.Add(new PaymentCommitments());
if (type == 2)
{
objPolicy.Committed = new PolicyIssueRepository().GetCommittedDetails(Id);
if (objPolicy.Committed.Count == 1)
{
objPolicy.Committed.Add(new PaymentCommitments());
objPolicy.Committed.Add(new PaymentCommitments());
objPolicy.Committed.Add(new PaymentCommitments());
}
else if (objPolicy.Committed.Count == 2)
{
objPolicy.Committed.Add(new PaymentCommitments());
objPolicy.Committed.Add(new PaymentCommitments());
}
else if (objPolicy.Committed.Count == 3)
{
objPolicy.Committed.Add(new PaymentCommitments());
}
objPolicy.PolicyStage = 2;
return(View("PaymentCommitments", objPolicy));
}
if (type == 3)
{
objPolicy.Committed = new PolicyIssueRepository().GetCommittedDetails(Id);
objPolicy.Cheque = new PolicyIssueRepository().GetChequeDetails(Id);
if (objPolicy.Cheque.Count == 0)
{
objPolicy.Cheque.Add(new PolicyIssueChequeReceived());
}
return(View("PaymentCommitments", objPolicy));
}
return(View("Create", objPolicy));
}
public ActionResult Create(int Id)
{
FillDropdowns();
PolicyIssue objPolicy = new PolicyRenewalRepository().GetNewPolicyForRenewal(Id);
objPolicy.PolicySubDate = DateTime.Now;
objPolicy.TranType = "RenewPolicy";
var internalid = PolicyIssueRepository.GetNextDocNo(objPolicy.TranType);
objPolicy.TranNumber = "CIB/REN/" + internalid;
objPolicy.Cheque = new PolicyIssueRepository().GetChequeDetails(Id);
if (objPolicy.Cheque.Count == 0)
{
objPolicy.Cheque.Add(new PolicyIssueChequeReceived());
}
return(View("Create", objPolicy));
}
public ActionResult NewPolicyList(int type, DateTime?FromDate, DateTime?ToDate, string PolicyNo = "", string Client = "", string SalesManager = "")
{
ViewBag.Type = type;
FromDate = FromDate ?? FYStartdate;
ToDate = ToDate ?? DateTime.Now;
//if (type == 2)
//{
// return PartialView("_NewPolicyListGrid", new PolicyIssueRepository().GetPaymentCommittedList(UserID, FromDate, ToDate, PolicyNo, Client, SalesManager));
//}
//else if (type == 3)
//{
// return PartialView("_NewPolicyListGrid", new PolicyIssueRepository().GetPaymentCollectionList(FromDate, ToDate, PolicyNo, Client, SalesManager));
//}
List <PolicyIssue> model = new PolicyIssueRepository().GetNewPolicy(type, UserID, UserRolename, FromDate, ToDate, PolicyNo, Client, SalesManager);
return(PartialView("_NewPolicyListGrid", model));
}
public ActionResult ViewPolicy(int Id)
{
ViewBag.Title = "View";
FillDropdowns();
PolicyIssue objPolicy = new PolicyIssueRepository().GetNewPolicy(Id);
//if(objPolicy.PayModeId != 0)
//{
// ViewBag.Type = 3;
//}
//else
//{
// ViewBag.Type = 2;
//}
objPolicy.Cheque = new PolicyIssueRepository().GetChequeDetails(Id);
objPolicy.Committed = new List <PaymentCommitments>();
objPolicy.Committed.Add(new PaymentCommitments());
objPolicy.Committed = new PolicyIssueRepository().GetCommittedDetails(Id);
if (objPolicy.Committed.Count == 1)
{
objPolicy.Committed.Add(new PaymentCommitments());
objPolicy.Committed.Add(new PaymentCommitments());
objPolicy.Committed.Add(new PaymentCommitments());
}
else if (objPolicy.Committed.Count == 2)
{
objPolicy.Committed.Add(new PaymentCommitments());
objPolicy.Committed.Add(new PaymentCommitments());
}
else if (objPolicy.Committed.Count == 3)
{
objPolicy.Committed.Add(new PaymentCommitments());
}
objPolicy.Committed = new PolicyIssueRepository().GetCommittedDetails(Id);
objPolicy.Cheque = new PolicyIssueRepository().GetChequeDetails(Id);
if (objPolicy.Cheque.Count == 0)
{
objPolicy.Cheque.Add(new PolicyIssueChequeReceived());
}
return(View(objPolicy));
}
public ActionResult Edit(PolicyIssue model)
{
model.TranDate = System.DateTime.Now;
if (!ModelState.IsValid)
{
var allErrors = ModelState.Values.SelectMany(v => v.Errors);
return(View(model));
}
Result res = new PolicyIssueRepository().Update(model);
if (res.Value)
{
TempData["Success"] = "Updated Successfully!";
}
else
{
}
return(RedirectToAction("Index", new { type = 1 }));
}
public ActionResult CreatePaymentCollection(int Id)
{
ViewBag.Type = 3;
ViewBag.Title = "Edit";
FillDropdowns();
PolicyIssue Model = new PolicyIssueRepository().GetNewPolicy(Id);
Model.PolicyStage = 3;
Model.Cheque = new PolicyIssueRepository().GetChequeDetails(Id);
if (Model.Cheque.Count == 0)
{
Model.Cheque = new List <PolicyIssueChequeReceived>();
Model.Cheque.Add(new PolicyIssueChequeReceived());
}
Model.Committed = new PolicyIssueRepository().GetCommittedDetails(Id);
return(View("PaymentCommitments", Model));
}
public ActionResult Create(int?type)
{
//ViewBag.Type = type;
FillDropdowns();
PolicyIssue model = new PolicyIssue();
model.TranType = "NewPolicy";
model.PolicyStage = type;
var internalid = PolicyIssueRepository.GetNextDocNo(model.TranType);
model.TranNumber = "CIB/NEW/" + internalid;
model.Cheque = new List <PolicyIssueChequeReceived>();
model.Cheque.Add(new PolicyIssueChequeReceived());
model.PolicySubDate = DateTime.Now;
model.EffectiveDate = DateTime.Now;
// model.RenewalDate = DateTime.Now.AddMonths(6);
model.ICActualDate = null;
return(View(model));
}
public ActionResult Create(PolicyIssue model)
{
model.TranPrefix = model.TranNumber.Substring(0, model.TranNumber.LastIndexOf('/'));
model.TranDate = System.DateTime.Now;
model.CreatedDate = System.DateTime.Now;
model.CreatedBy = UserID;
if (!ModelState.IsValid)
{
FillDropdowns();
var allErrors = ModelState.Values.SelectMany(v => v.Errors);
return(View(model));
}
Result res = new PolicyIssueRepository().Insert(model);
if (res.Value)
{
TempData["Success"] = "Saved Successfully!";
}
else
{
}
return(RedirectToAction("Index", new { type = model.PolicyStage }));
}
public ActionResult Print(int Id)
{
ReportDocument rd = new ReportDocument();
rd.Load(Path.Combine(Server.MapPath("~/Reports"), "ReceiptVoucher.rpt"));
DataSet ds = new DataSet();
ds.Tables.Add("Head");
ds.Tables.Add("Items");
// //-------HEAD
ds.Tables["Head"].Columns.Add("VoucherNo");
ds.Tables["Head"].Columns.Add("DocumentDate");
ds.Tables["Head"].Columns.Add("TotalPremium");
ds.Tables["Head"].Columns.Add("Customer");
ds.Tables["Head"].Columns.Add("Company");
ds.Tables["Head"].Columns.Add("Product");
ds.Tables["Head"].Columns.Add("PaymentTo");
//-------DT
ds.Tables["Items"].Columns.Add("ReceiptType");
ds.Tables["Items"].Columns.Add("ReceiveFrom");
ds.Tables["Items"].Columns.Add("Amount");
ds.Tables["Items"].Columns.Add("ChequeNo");
ds.Tables["Items"].Columns.Add("Date");
ds.Tables["Items"].Columns.Add("Bank");
var Head = new PolicyIssueRepository().GetReceiptHdForPrint(Id);
DataRow dr = ds.Tables["Head"].NewRow();
dr["VoucherNo"] = Head.StrTranNumber;
dr["DocumentDate"] = Head.TranDate.Value.ToString("dd-MMM-yyyy");
dr["TotalPremium"] = Head.TotalPremium;
dr["Customer"] = Head.CusName;
dr["Company"] = Head.InsCmpName;
dr["Product"] = Head.InsPrdName;
dr["PaymentTo"] = Head.PaymentTo;
ds.Tables["Head"].Rows.Add(dr);
var Items = new PolicyIssueRepository().GetReceiptChequeDetailsforPrint(Id);
foreach (var item in Items)
{
var ReceiptDetails = new PolicyIssueChequeReceived
{
CusName = item.CusName,
PayModeName = item.PayModeName,
TotalPremium = item.TotalPremium,
ChequeNo = item.ChequeNo,
ChequeDate = item.ChequeDate,
BankBranch = item.BankBranch,
BankName = item.BankName,
ChequeAmt = item.ChequeAmt
};
DataRow dri = ds.Tables["Items"].NewRow();
dri["ReceiptType"] = ReceiptDetails.PayModeName;
dri["ReceiveFrom"] = ReceiptDetails.CusName;
dri["Amount"] = ReceiptDetails.TotalPremium;
dri["ChequeNo"] = ReceiptDetails.ChequeNo;
dri["Date"] = ReceiptDetails.ChequeDate.Value.ToString("dd-MMM-yyyy");
dri["Bank"] = ReceiptDetails.BankName;
ds.Tables["Items"].Rows.Add(dri);
}
ds.WriteXml(Path.Combine(Server.MapPath("~/XML"), "ReceiptVoucher.xml"), XmlWriteMode.WriteSchema);
rd.SetDataSource(ds);
Response.Buffer = false;
Response.ClearContent();
Response.ClearHeaders();
try
{
Stream stream = rd.ExportToStream(CrystalDecisions.Shared.ExportFormatType.PortableDocFormat);
stream.Seek(0, SeekOrigin.Begin);
return(File(stream, "application/pdf"));
}
catch (Exception ex)
{
throw;
}
}