public bool isApproverExclusive(int ApprovalPositionID)
{
var isSuccess = false;
try
{
var ApprovalPositionName = "";
string[] Exclusive;
Exclusive = new string[1];
Exclusive[0] = "KADIV";
List<string> _Exclusive = new List<string>(Exclusive);
using (var db = new ESKAPEDEContext())
{
ApprovalPositionName = db.vwUserProfiles.Where(a => a.PositionID == ApprovalPositionID).Select(a => a.PositionTypeName).SingleOrDefault();
}
if (_Exclusive.Any(s => ApprovalPositionName.Contains(s)))
{
isSuccess = true;
}
}
catch (Exception ex)
{
//Log exception
ex.ToString();
}
return isSuccess;
}
protected override void Initialize(RequestContext requestContext)
{
if (db == null) { db = new ESKAPEDEContext(); }
if (WebSecurityService == null) { WebSecurityService = new WebSecurityService(); }
if (MessengerService == null) { MessengerService = new MessengerService(); }
if (ServiceSkpd == null) { ServiceSkpd = new ServiceSkpd(); }
base.Initialize(requestContext);
}
public bool isRequestIDExist(int RequestID)
{
bool isValid = false;
using (var db = new ESKAPEDEContext())
{
var x = db.RequestLogs.Where(a => a.RequestID == RequestID).Count();
if (x > 0) return isValid = true;
}
return isValid;
}
//private ESKAPEDEContext db = new ESKAPEDEContext();
public bool isAlreadyApproveOrReject(int RequestID, int ApprovalPosistionID, int FlagID)
{
bool isValid = false;
using (var db = new ESKAPEDEContext())
{
var x = db.RequestLogs.Where(a => a.RequestID == RequestID && a.ApprovalPositionID == ApprovalPosistionID && a.FlagID == FlagID).Count();
if (x > 0) return isValid = true;
}
return isValid;
}
public string[] ccEmail(int requestID)
{
using (var db = new ESKAPEDEContext())
{
string[] _ccEmail = (from reglog in db.RequestLogs
join user in db.Users on reglog.ApprovalPositionID equals user.PositionID
where reglog.RequestID == requestID
select user.Email).Distinct().ToArray();
return _ccEmail;
}
}
protected override void Initialize(RequestContext requestContext)
{
if (db == null) { db = new ESKAPEDEContext(); }
base.Initialize(requestContext);
}
//
// GET: /paging/
public ViewResult Index(int? id, string currentFilter, string searchString)
{
if (Request.HttpMethod == "GET")
{
searchString = currentFilter;
}
else
{
id = 1;
}
ViewBag.CurrentFilter = searchString;
int currentPage = id ?? 1;
ViewBag.Message = "Position List";
using (var db = new ESKAPEDEContext())
{
var positions = db.Positions.ToList();
if (!String.IsNullOrEmpty(searchString))
{
positions = positions.Where(s => s.PositionName.ToUpper().Contains(searchString.ToUpper())).ToList();
}
int pageSize = 5;
int pageNumber = (id ?? 1);
return View(positions.OrderBy(a => a.PositionID).ToPagedList(pageNumber, pageSize));
}
}
public ViewResult Lacak(int? id, string currentFilter, string searchString)
{
if (Request.HttpMethod == "GET")
{
searchString = currentFilter;
}
else
{
id = 1;
}
ViewBag.CurrentFilter = searchString;
int currentPage = id ?? 1;
ViewBag.Message = "Lacak Pengajuan";
using (var db = new ESKAPEDEContext())
{
var requests = db.vwRequests.Where(a => a.Username == User.Identity.Name).OrderByDescending(a => a.RequestID).ToList();
if (!String.IsNullOrEmpty(searchString))
{
requests = requests.Where(s => s.EventName.ToUpper().Contains(searchString.ToUpper())).OrderByDescending(a => a.RequestID).ToList();
}
int pageSize = 5;
int pageNumber = (id ?? 1);
return View(requests.ToPagedList(pageNumber, pageSize));
}
//return View(db.Requests.Where(a => a.CreatedBy == User.Identity.Name).ToList());
}
public ActionResult xls()
{
using (ESKAPEDEContext db = new ESKAPEDEContext())
{
IQueryable<vwRequest> results = db.vwRequests;
System.Web.UI.WebControls.GridView grd = new System.Web.UI.WebControls.GridView();
grd.DataSource = db.vwRequests.ToList();
grd.DataBind();
Response.ClearContent();
Response.AddHeader("content-disposition", "attachment; filename=ReportSKPD.xls");
Response.ContentType = "application/ms-excel";
StringWriter sw = new StringWriter();
HtmlTextWriter htw = new HtmlTextWriter(sw);
// Render the grid contents => the writer objects => Response object
grd.RenderControl(htw);
Response.Write(sw.ToString());
Response.End();
return View("Index");
}
}
public string ParentPositionName(int PositionID)
{
var ParentPositionName = string.Empty;
using (var db = new ESKAPEDEContext())
{
var ParentPositionID = db.Positions.Where(a => a.PositionID == PositionID).Select(a => a.AssignID).Single();
ParentPositionName = db.Positions.Where(a => a.PositionID == ParentPositionID).Select(a => a.PositionName).Single();
}
return ParentPositionName.ToString();
}
public int ParentPositionID(int PositionID)
{
using (var db = new ESKAPEDEContext())
{
var ParentPosisitionID = db.Positions.Where(a => a.PositionID == PositionID).Select(a => a.AssignID).Single();
return ParentPosisitionID;
}
}
public bool SendEmailToApproverFromRequester(string hostUrl,Request request, ESKAPEDEContext Db,IMessengerService MessengerService)
{
var isSuccess = false;
try
{
var RequestID = request.RequestID ;
var fromFirstName = Db.Users.Where(a => a.Username == request.CreatedBy).Select(a => a.FirstName).SingleOrDefault();
var fromLastName = Db.Users.Where(a => a.Username == request.CreatedBy).Select(a => a.LastName).SingleOrDefault();
if (fromLastName == null) fromLastName = "";
var fromfullName = string.Format("{0}.{1}", fromFirstName.ToUpper(), fromLastName.ToUpper());
var fromAddress = ConfigurationManager.AppSettings["Sender"];
var fromPositionName = Db.Positions.Where(a => a.PositionID == request.PositionID).Select(a => a.PositionName).SingleOrDefault();
var fromDivisionName = Db.Positions.Where(a => a.PositionID == request.PositionID).Select(a => a.Unit.Division.DivisionName).SingleOrDefault();
var fromCountryName = Db.Positions.Where(a => a.PositionID == request.PositionID).Select(a => a.Country.CountryName).SingleOrDefault();
var fromDesti = Db.Countries.Where(a => a.CountryID == request.FromCountryID).Select(a => a.CountryName).SingleOrDefault();
var toDesti = Db.Countries.Where(a => a.CountryID == request.ToCountryID).Select(a => a.CountryName).SingleOrDefault();
var fromDate = request.StartDate.Date.ToShortDateString();
var toDate = request.EndDate.Date.ToShortDateString();
var skpdEventName = request.EventName;
var skpdEndDate = request.EndDate.Date.ToShortDateString();
var toAddress = Db.Users.Where(a => a.PositionID == request.ApprovalPositionID).Select(a => a.Email).SingleOrDefault();
var toName = Db.Users.Where(a => a.PositionID == request.ApprovalPositionID).Select(a => a.Username).SingleOrDefault();
var skpdRequestID = request.RequestID.ToString();
var QueryParam = string.Format("UserName={0}&RequestID={1}", toName, skpdRequestID);
var QueryParamEncrypt = QueryStringEncrypt(QueryParam);
var approveUrl = hostUrl + VirtualPathUtility.ToAbsolute(string.Format("~/FromEmail/Approve{0}", QueryParamEncrypt));
var rejectUrl = hostUrl + VirtualPathUtility.ToAbsolute(string.Format("~/FromEmail/Reject{0}", QueryParamEncrypt));
var subject = string.Format("Pengajuan Permohonan Perjalanan Dinas Dari Bapak/Ibu {0}", fromfullName);
IEnumerable<RequestInTransport> ListTrans = Db.RequestInTransports.Include("Transport").Where(a => a.RequestID == request.RequestID);
var anggaran = Db.RequestInPrograms.Where(a => a.RequestID == request.RequestID).Select(a => a.Program.ProgramName).FirstOrDefault();
//IEnumerable<Transport> transport = db.Transports;
var StrListTrans = "<ul>";
foreach (var item in ListTrans)
{
StrListTrans += string.Format("<li>{0}</li>", item.Transport.TransportName);
}
StrListTrans = string.Format("{0}</ul>", StrListTrans);
var body = string.Format("Kepada Yth,<br />" +
"Bapak/Ibu. {0} <br /><br/>" +
"Permohonan Persetujuan Perjalanan Dinas : " +
"<br/><br/>No. Perjadin: {1} " +
"<br/>Nama: {2} " +
"<br/>Posisi: {3} " +
"<br/>Divisi : {4} " +
"<br/>Kantor : {5} " +
"<br/>Kegiatan : {6} " +
"<br/>Perjalanan : {7} - {8} " +
"<br/>Tanggal: {9} - {10}" +
"<br/>Transportasi : {11} " +
"<br/>Beban Anggaran : {12} " +
"<br/><br /> Apakah Permohonan perjalanan dinas ini di SETUJUI atau TIDAK DISETUJUI ? " +
"<br/><br/><p><strong><a href=\"{13}\">DISETUJUI</a></strong></p> " +
"<br/><br/><p><strong><a href=\"{14}\">TIDAK DISETUJUI</a></strong></p>",
toName.ToUpper(), skpdRequestID, fromfullName, fromPositionName, fromDivisionName,
fromCountryName, skpdEventName, fromDesti, toDesti, fromDate, toDate,
StrListTrans, anggaran, approveUrl, rejectUrl);
if (MessengerService.Send(fromAddress, toAddress, subject, body, true))
{
isSuccess = true;
}
}
catch (Exception ex)
{
//Log exception
ex.ToString();
}
return isSuccess;
}
public bool SendEmailResultToRequesterCcApprover(Request request, ESKAPEDEContext Db, IMessengerService MessengerService)
{
var isSuccess = false;
try
{
//SEND EMAIL TO REQUESTER Cc APPROVER
var RequestID = request.RequestID.ToString();
var fromFirstName = Db.Users.Where(a => a.PositionID == request.ApprovalPositionID).Select(a => a.FirstName).SingleOrDefault();
var fromLastName = Db.Users.Where(a => a.PositionID == request.ApprovalPositionID).Select(a => a.LastName).SingleOrDefault();
if (fromLastName == null) fromLastName = "";
var fromfullName = string.Format("{0}.{1}", fromFirstName.ToUpper(), fromLastName.ToUpper());
var toFirstName = Db.Users.Where(a => a.Username == request.CreatedBy).Select(a => a.FirstName).SingleOrDefault();
var toLastName = Db.Users.Where(a => a.Username == request.CreatedBy).Select(a => a.LastName).SingleOrDefault();
var tofullName = string.Format("{0}.{1}", toFirstName.ToUpper(), toLastName.ToUpper());
var fromAddress = ConfigurationManager.AppSettings["Sender"];
var toAddress = Db.Users.Where(a => a.ID == request.UserID).Select(a => a.Email).SingleOrDefault();
var ccAddress = ccEmail(request.RequestID);
var subject = string.Format("Hasil Pengajuan Perjalanan Dinas Dari {0}", tofullName);
var appSkpdUrl = ConfigurationManager.AppSettings["hostUrl"];
var body = string.Format("<p>Kepada Yth,<br /> Bapak/Ibu {0}<br /><br />" +
"<p>No. Perjadin : {1}</p> <br />" +
"<p>Pengajuan perjalanan dinas anda telah DISETUJUI oleh Bapak/Ibu {2}</p><br />" +
"<p>Untuk informasi lengkap <a href=\"{3}\">login</a></p>",
tofullName.ToUpper(), RequestID, fromfullName, appSkpdUrl);
if (MessengerService.Send(fromAddress, toAddress, subject, body, true, ccAddress))
{
isSuccess = true;
}
}
catch (Exception ex)
{
ex.ToString();
}
return isSuccess;
}
//public bool ExclusiveApprover(int ApprovalPositionID)
//{
// var ApprovalPositionName = "";
// bool PositionName = false;
// string[] Exclusive;
// Exclusive = new string[2];
// Exclusive[0] = "KADIV";
// Exclusive[1] = "KA. KPM";
// List<string> _Exclusive = new List<string>(Exclusive);
// using (var db = new ESKAPEDEContext())
// {
// ApprovalPositionName = db.Positions.Where(a => a.PositionID == ApprovalPositionID).Select(a => a.PositionName).First();
// }
// if (_Exclusive.Any(s => ApprovalPositionName.Contains(s)))
// {
// PositionName = true;
// }
// return PositionName;
//}
public bool SendEmailRejectToRequesterCcApprover(Request request, ESKAPEDEContext Db, IMessengerService MessengerService)
{
var isSuccess = false;
try
{
var RequestID = request.RequestID;
var fromUsername = Db.Users.Where(a => a.PositionID == request.ApprovalPositionID).Select(a => a.Username).SingleOrDefault();
var fromFirstName = Db.Users.Where(a => a.Username == fromUsername).Select(a => a.FirstName).SingleOrDefault();
var fromLastName = Db.Users.Where(a => a.Username == fromUsername).Select(a => a.LastName).SingleOrDefault();
if (fromLastName == null) fromLastName = "";
var fromfullName = string.Format("{0}.{1}", fromFirstName.ToUpper(), fromLastName.ToUpper());
var fromAddress = ConfigurationManager.AppSettings["Sender"];
var toAddress = Db.Users.Where(a => a.PositionID == request.ApprovalPositionID).Select(a => a.Email).SingleOrDefault();
var toFirstName = Db.Users.Where(a => a.Username == request.CreatedBy).Select(a => a.FirstName).SingleOrDefault();
var toLastName = Db.Users.Where(a => a.Username == request.CreatedBy).Select(a => a.LastName).SingleOrDefault();
var tofullName = string.Format("{0}.{1}", toFirstName.ToUpper(), toLastName.ToUpper());
//var ccAddress = Db.Users.Where(a => a.PositionID == request.ApprovalPositionID).Select(a => a.Email).Single();
var ccAddress = ccEmail(request.RequestID);
var subject = string.Format("Hasil Permohonan Pengajuan Perjalan Dinas Dari {0}", fromfullName);
var appSkpdUrl = ConfigurationManager.AppSettings["hostUrl"];
var fromReason = request.RejectedReason;
var body = string.Format("<p>Kepada Yth,<br />" +
"Bapak/Ibu {0}<br /><br />" +
"No. Perjadin : {1} <br />" +
"TIDAK DISETUJUI Oleh Bapak/Ibu {2}</p><br />" +
"Dengan Alasan : {3}" +
"<p>Untuk informasi lengkap <a href='{4}'>login</a></p>",
tofullName.ToUpper(), RequestID, fromfullName, request.RejectedReason, appSkpdUrl);
if (MessengerService.Send(fromAddress, toAddress, subject, body, true, ccAddress))
{
isSuccess = true;
}
}
catch (Exception ex)
{
//Log exception
ex.ToString();
}
return isSuccess;
}