public ActionResult RequestInProgram(int id)
{
RequestInProgramDTO requestinprogram = new RequestInProgramDTO();
requestinprogram.RequestID = id;
return View(requestinprogram);
}
public ActionResult RequestInProgram(RequestInProgramDTO model)
{
try
{
using (TransactionScope transaction = new TransactionScope())
{
var ApprovalPositionID = db.Users.Where(a => a.Username == User.Identity.Name).Select(a => a.PositionID).Single();
//var ApprovalPositionInProgram = db.vwPositionInPrograms
// .Where(a => a.DivisionID == model.DivisionID && a.KdProg==model.BudgetID)
// .Select(a => a.PositionID).SingleOrDefault();
DateTime DateTimeNow = DateTime.Now;
//UPDATE REQUEST
Request request = db.Requests.Include("RequestInTransports").Where(a => a.RequestID == model.RequestID).First();
RequestInProgram requestinprogram = new RequestInProgram();
string hostUrl = Request.Url.GetComponents(UriComponents.SchemeAndServer, UriFormat.Unescaped);
//MY BUDGET
if (model.sendirilain != 2)
{
//APPROVED
request.FlagID = 2;
request.FlagCreatedDate = DateTimeNow;
db.Entry(request).State = EntityState.Modified;
db.SaveChanges();
if (ServiceSkpd.SendEmailResultToRequesterCcApprover(request, db, MessengerService))
{
//APPROVE REQUESTINPROGRAM
requestinprogram.RequestID = model.RequestID;
requestinprogram.ProgramID = model.ProgramID;
db.RequestInPrograms.Add(requestinprogram);
db.SaveChanges();
request.FlagID = 7;
request.ApprovalPositionID = 194;
request.FlagCreatedDate = DateTimeNow;
db.Entry(request).State = EntityState.Modified;
db.SaveChanges();
//if (request.ApprovalPositionID == ApprovalPositionID)
//{
// request.FlagID = 8;
// request.FlagCreatedDate = DateTime.Now;
// db.Entry(request).State = EntityState.Modified;
// db.SaveChanges();
//}
transaction.Complete();
this.HttpContext.Session["RequestID"] = requestinprogram.RequestID;
return RedirectToAction("SuccessAddBudget");
}
else
{
ModelState.AddModelError("", "Gagal proses pengajuan");
ModelState.AddModelError("", "Gagal mengirim email");
ModelState.AddModelError("", "Pastikan anda sedang terhubung koneksi internet");
}
}
//BUDGET ANOTHER DIVISION
else
{
//APPROVED
request.FlagID = 2;
request.FlagCreatedDate = DateTimeNow;
db.Entry(request).State = EntityState.Modified;
db.SaveChanges();
if (ServiceSkpd.SendEmailResultToRequesterCcApprover(request, db, MessengerService))
{
var AssignIDForBudget = db.vwPositionInPrograms.Where(a => a.UnitID == model.UnitID).Select(a => a.PositionID).FirstOrDefault();
request.FlagID = 9;
request.FlagCreatedDate = DateTimeNow;
request.ApprovalPositionID = AssignIDForBudget;
db.Entry(request).State = EntityState.Modified;
db.SaveChanges();
if (ServiceSkpd.SendEmailRequestBudgetToDivisionFromRequester(hostUrl, request, db, MessengerService))
{
transaction.Complete();
return RedirectToAction("SuccessSendRequestBudget");
}
else
{
ModelState.AddModelError("", "Gagal proses pengajuan");
ModelState.AddModelError("", "Gagal mengirim email");
ModelState.AddModelError("", "Pastikan anda sedang terhubung koneksi internet");
}
}
else
{
ModelState.AddModelError("", "Gagal proses pengajuan");
ModelState.AddModelError("", "Gagal mengirim email");
ModelState.AddModelError("", "Pastikan anda sedang terhubung koneksi internet");
}
}
}
}
catch (Exception ex)
{
ModelState.AddModelError("", ex.InnerException);
}
return View(model);
}
public ActionResult RequestInProgram(string tiket)
{
string QueryStringModuleDecrypt = QueryStringModule.Decrypt(tiket);
NameValueCollection NameValue = HttpUtility.ParseQueryString(QueryStringModuleDecrypt);
var RequestID = NameValue["RequestID"];
var UserName = NameValue["UserName"];
int intRequestID = Convert.ToInt16(RequestID);
var ApprovalPositionID = db.Requests.Where(a => a.RequestID == intRequestID).Select(a => a.ApprovalPositionID).SingleOrDefault();
var ApprovalDivisionID = db.vwUserProfiles.Where(a => a.PositionID == ApprovalPositionID).Select(a => a.DivisionID).SingleOrDefault();
RequestInProgramDTO requestinprogram = new RequestInProgramDTO();
requestinprogram.RequestID = intRequestID;
//requestinprogram.ApproverPositionID = ApprovalPositionID;
//requestinprogram.DivisionID = ApprovalDivisionID;
return View(requestinprogram);
}