//[HttpGet]
private int Update(Models.SBP_BlotterDTLDB DTLDeskBoard)
{
ServiceRepository serviceObj = new ServiceRepository();
HttpResponseMessage response = serviceObj.PutResponse("/api/BlotterDTLDB/UpdateWiseBal", DTLDeskBoard);
response.EnsureSuccessStatusCode();
return 0; // RedirectToAction("GetBlotterDTLDB");
}
public ActionResult GetBlotterDTLDB()
{
try
{
//GetBlotterSum
ServiceRepositoryBlotter serviceObj = new ServiceRepositoryBlotter();
HttpResponseMessage response = serviceObj.GetResponse("/api/BlotterDTLDB/GetBlotterDBList?brcode=" + BrCode);
response.EnsureSuccessStatusCode();
Models.SBP_BlotterDTLDB blotter = response.Content.ReadAsAsync <Models.SBP_BlotterDTLDB>().Result;
ViewBag.Title = "DTL Blotter";
ViewData["SysCurrentDt1"] = GetCurrentDT().ToString("dd-MMM-yyyy");
ViewData["BrCode"] = BrCode;
return(View(blotter));
}
catch (Exception)
{
throw;
}
}
public ActionResult SendEmail(ViewModel.BlotterMultiModel setup)
{
try
{
//GetBlotterSum
ServiceRepositoryBlotter serviceObj = new ServiceRepositoryBlotter();
HttpResponseMessage response = serviceObj.GetResponse("/api/BlotterDTLDB/GetBlotterDBList?brcode=" + Session["BR"].ToString());
response.EnsureSuccessStatusCode();
Models.SBP_BlotterDTLDB blotter = response.Content.ReadAsAsync <Models.SBP_BlotterDTLDB>().Result;
if (blotter != null)
{
DateTime DTLSartDate = blotter.DTL_Date;
int DTLDays = blotter.DTL_Days;
decimal DTLAmt = Convert.ToDecimal(blotter.DTL_Amount / 1000000);
decimal DTLAmt3Per = (DTLAmt * 3 / 100);
decimal DTLAmt5Per = (DTLAmt * 5 / 100);
Models.BlottterEmails TotalSum = BlotterSum();
decimal DTLAmt3Actual = (Convert.ToDecimal(0.03) / Convert.ToDecimal(DTLAmt3Per)) * (Convert.ToDecimal(TotalSum.Balance) * 100);
decimal DTLAmt5Actual = (Convert.ToDecimal(0.05) / Convert.ToDecimal(DTLAmt5Per)) * (Convert.ToDecimal(TotalSum.Balance) * 100);
//decimal DTLAmt3Actual = (Convert.ToDecimal(0.03) / Convert.ToDecimal(DTLAmt)) * (Convert.ToDecimal(TotalSum.Balance) );
//decimal DTLAmt5Actual = (Convert.ToDecimal(0.05) / Convert.ToDecimal(DTLAmt)) * (Convert.ToDecimal(TotalSum.Balance) );
decimal DTLAmtOpeningBalance = (Convert.ToDecimal((TotalSum.Balance - (TotalSum.Inflow + TotalSum.Outflow))));
ViewBag.Title = "All Blotter";
var currentDT = GetCurrentDT();
ViewData["SysCurrentDt1"] = currentDT.ToString("dd-MMM-yyyy");
var DatCount = (currentDT - DTLSartDate).TotalDays;
var DatCount1 = (DTLSartDate.AddDays(DTLDays));
if (currentDT >= DTLSartDate && DTLSartDate <= DatCount1)
{
var upd = 0;
if (DatCount == 0) //&& String.IsNullOrEmpty(blotter.Friday_01.ToString()))
{
blotter.Friday_01 = TotalSum.Balance * 1000000;
blotter.Saturday_02 = TotalSum.Balance * 1000000;
blotter.Sunday_03 = TotalSum.Balance * 1000000;
SendE = true;
upd = Update(blotter);
}
else
if (DatCount == 3) // && String.IsNullOrEmpty(blotter.Monday_04.ToString()))
{
blotter.Monday_04 = TotalSum.Balance * 1000000;
SendE = true;
upd = Update(blotter);
}
else
if (DatCount == 4) //&& String.IsNullOrEmpty(blotter.Tuesday_05.ToString()))
{
blotter.Tuesday_05 = TotalSum.Balance * 1000000;
SendE = true;
upd = Update(blotter);
}
else
if (DatCount == 5) // && String.IsNullOrEmpty(blotter.Wednesday_06.ToString()))
{
blotter.Wednesday_06 = TotalSum.Balance * 1000000;
SendE = true;
upd = Update(blotter);
}
else
if (DatCount == 6) //&& String.IsNullOrEmpty(blotter.Thursday_07.ToString()))
{
blotter.Thursday_07 = TotalSum.Balance * 1000000;
SendE = true;
upd = Update(blotter);
}
else
if (DatCount == 7) // && String.IsNullOrEmpty(blotter.Friday_08.ToString()))
{
blotter.Friday_08 = TotalSum.Balance * 1000000;
blotter.Saturday_09 = TotalSum.Balance * 1000000;
blotter.Sunday_10 = TotalSum.Balance * 1000000;
SendE = true;
upd = Update(blotter);
}
else
if (DatCount == 10) //&& String.IsNullOrEmpty(blotter.Monday_11.ToString()))
{
blotter.Monday_11 = TotalSum.Balance * 1000000;
SendE = true;
upd = Update(blotter);
}
else
if (DatCount == 11) //&& String.IsNullOrEmpty(blotter.Tuesday_12.ToString()))
{
blotter.Tuesday_12 = TotalSum.Balance * 1000000;
SendE = true;
upd = Update(blotter);
}
else
if (DatCount == 12) // && String.IsNullOrEmpty(blotter.Wednesday_13.ToString()))
{
blotter.Wednesday_13 = TotalSum.Balance * 1000000;
SendE = true;
upd = Update(blotter);
}
else
if (DatCount == 13) // && String.IsNullOrEmpty(blotter.Thursday_14.ToString()))
{
blotter.Thursday_14 = TotalSum.Balance * 1000000;
SendE = true;
upd = Update(blotter);
}
//var upd=Update(blotter);
}
if (SendE == true)
{
string htmlString = @"<table border = " + Convert.ToChar(34) + "2" + Convert.ToChar(34) + " width = " + Convert.ToChar(34) + "50%" + Convert.ToChar(34) + ">";
htmlString = htmlString + "<tr><td> </td><td align=" + Convert.ToChar(34) + "center" + Convert.ToChar(34) + "> " + "Amount in millions </td></tr>";
htmlString = htmlString + "<tr><td> Opening Balance </td><td align=" + Convert.ToChar(34) + "right" + Convert.ToChar(34) + "> " + String.Format("{0:0,0}", DTLAmtOpeningBalance) + " </td></tr>";
htmlString = htmlString + "<tr><td> InFlow </td><td align=" + Convert.ToChar(34) + "right" + Convert.ToChar(34) + "> " + String.Format("{0:0,0}", TotalSum.Inflow) + " </td></tr>";
htmlString = htmlString + "<tr><td> OutFlow </td><td align=" + Convert.ToChar(34) + "right" + Convert.ToChar(34) + "> " + String.Format("{0:0,0}", TotalSum.Outflow) + " </td></tr>";
htmlString = htmlString + "<tr><td> Balance maintained </td><td align=" + Convert.ToChar(34) + "right" + Convert.ToChar(34) + "> " + String.Format("{0:0,0}", TotalSum.Balance) + "</td></tr>";
htmlString = htmlString + "<tr bgcolor = " + Convert.ToChar(34) + "#5DADE2" + Convert.ToChar(34) + " ><td> Working </td></tr>";
htmlString = htmlString + "<tr bgcolor = " + Convert.ToChar(34) + "#76D8A0" + Convert.ToChar(34) + "><td> 5% Requirement </td><td align=" + Convert.ToChar(34) + "right" + Convert.ToChar(34) + "> " + String.Format("{0:0,0}", DTLAmt5Per) + " </td></tr>";
htmlString = htmlString + "<tr bgcolor = " + Convert.ToChar(34) + "#76D8A0" + Convert.ToChar(34) + " ><td> 3% Amount To Maintain </td><td align=" + Convert.ToChar(34) + "right" + Convert.ToChar(34) + "> " + String.Format("{0:0,0}", DTLAmt3Per) + " </td></tr>";
// if (Convert.ToDecimal(DTLAmt3Actual) < Convert.ToDecimal(3.0))
// {
// htmlString = htmlString + "<tr bgcolor = " + Convert.ToChar(34) + "#DE1C51" + Convert.ToChar(34) + "><td> 3% Actual % </td><td align=" + Convert.ToChar(34) + "right" + Convert.ToChar(34) + "> " + String.Format("{0:0,0.00}", DTLAmt3Actual) + " </td></tr>";
// }
// else
//{
// htmlString = htmlString + "<tr bgcolor = " + Convert.ToChar(34) + "#00FF00" + Convert.ToChar(34) + "><td> 3% Actual % </td><td align=" + Convert.ToChar(34) + "right" + Convert.ToChar(34) + "> " + String.Format("{0:0,0.00}", DTLAmt3Actual) + " </td></tr>";
// }
htmlString = htmlString + "<tr bgcolor = " + Convert.ToChar(34) + "#00FF00" + Convert.ToChar(34) + "><td>Balance Maintained in % age </td><td align=" + Convert.ToChar(34) + "right" + Convert.ToChar(34) + "> " + String.Format("{0:0.00}", DTLAmt5Actual) + " </td></tr>";
htmlString = htmlString + "</table>";
string EmailFrom = ConfigurationManager.AppSettings["EmailSender"].ToString();
string EmailTo = ConfigurationManager.AppSettings["EmailReceviers"].ToString();
SEND_EMAIL(EmailFrom, EmailTo, "", "", "SBP DTL Summary", htmlString, "");
SendE = false;
}
}
}
catch (Exception)
{
throw;
}
return(RedirectToAction("GetAllBlotter"));
}
//[HttpGet]
private void UpdateDTLBlotter01(decimal CashInflow,decimal CashOutFlow,DateTime Dt)
{
try
{
//GetBlotterSum
ServiceRepositoryBlotter serviceObj = new ServiceRepositoryBlotter();
HttpResponseMessage response = serviceObj.GetResponse("/api/BlotterDTLDB/GetBlotterDBList?brcode=" + BrCode);
response.EnsureSuccessStatusCode();
Models.SBP_BlotterDTLDB blotter = response.Content.ReadAsAsync<Models.SBP_BlotterDTLDB>().Result;
ViewBag.Title = "All Blotter";
var currentDT = Dt.ToString("dd-MMM-yyyy");
ViewData["SysCurrentDt1"] = currentDT;
var upd = 0;
if (blotter.Date_01 .ToString("dd-MMM-yyyy") == Dt.ToString("dd-MMM-yyyy"))
{
blotter.CashFlow_01 = CashInflow;
blotter.CashOutFlow_01 = CashOutFlow;
upd = Update(blotter);
}
else
if (blotter.Date_02.ToString("dd-MMM-yyyy") == Dt.ToString("dd-MMM-yyyy"))
{
blotter.CashFlow_02 = CashInflow;
blotter.CashOutFlow_02 = CashOutFlow;
upd = Update(blotter);
}
else
if (blotter.Date_03.ToString("dd-MMM-yyyy") == Dt.ToString("dd-MMM-yyyy"))
{
blotter.CashFlow_03 = CashInflow;
blotter.CashOutFlow_03 = CashOutFlow;
upd = Update(blotter);
}
else
if (blotter.Date_04.ToString("dd-MMM-yyyy") == Dt.ToString("dd-MMM-yyyy"))
{
blotter.CashFlow_04 = CashInflow;
blotter.CashOutFlow_04 = CashOutFlow;
upd = Update(blotter);
}
else
if (blotter.Date_05.ToString("dd-MMM-yyyy") == Dt.ToString("dd-MMM-yyyy"))
{
blotter.CashFlow_05 = CashInflow;
blotter.CashOutFlow_05 = CashOutFlow;
upd = Update(blotter);
}
else
if (blotter.Date_06.ToString("dd-MMM-yyyy") == Dt.ToString("dd-MMM-yyyy"))
{
blotter.CashFlow_06 = CashInflow;
blotter.CashOutFlow_06 = CashOutFlow;
upd = Update(blotter);
}
else
if (blotter.Date_07.ToString("dd-MMM-yyyy") == Dt.ToString("dd-MMM-yyyy"))
{
blotter.CashFlow_07 = CashInflow;
blotter.CashOutFlow_07 = CashOutFlow;
upd = Update(blotter);
}
else
if (blotter.Date_08.ToString("dd-MMM-yyyy") == Dt.ToString("dd-MMM-yyyy"))
{
blotter.CashFlow_08 = CashInflow;
blotter.CashOutFlow_08 = CashOutFlow;
upd = Update(blotter);
}
else
if (blotter.Date_09.ToString("dd-MMM-yyyy") == Dt.ToString("dd-MMM-yyyy"))
{
blotter.CashFlow_09 = CashInflow;
blotter.CashOutFlow_09 = CashOutFlow;
upd = Update(blotter);
}
else
if (blotter.Date_10.ToString("dd-MMM-yyyy") == Dt.ToString("dd-MMM-yyyy"))
{
blotter.CashFlow_10 = CashInflow;
blotter.CashOutFlow_10 = CashOutFlow;
upd = Update(blotter);
}
else
if (blotter.Date_11.ToString("dd-MMM-yyyy") == Dt.ToString("dd-MMM-yyyy"))
{
blotter.CashFlow_11 = CashInflow;
blotter.CashOutFlow_11 = CashOutFlow;
upd = Update(blotter);
}
else
if (blotter.Date_12.ToString("dd-MMM-yyyy") == Dt.ToString("dd-MMM-yyyy"))
{
blotter.CashFlow_12 = CashInflow;
blotter.CashOutFlow_12 = CashOutFlow;
upd = Update(blotter);
}
else
if (blotter.Date_13.ToString("dd-MMM-yyyy") == Dt.ToString("dd-MMM-yyyy"))
{
blotter.CashFlow_13 = CashInflow;
blotter.CashOutFlow_13 = CashOutFlow;
upd = Update(blotter);
}
else
if (blotter.Date_14.ToString("dd-MMM-yyyy") == Dt.ToString("dd-MMM-yyyy"))
{
blotter.CashFlow_14 = CashInflow;
blotter.CashOutFlow_14 = CashOutFlow;
upd = Update(blotter);
}
}
catch (Exception)
{
throw;
}
}
