public string CreateLoanRequest(string reason,
string loantype, string comment,
string loanamount, string noofinstallment,
string deductionistartdate)
{
if (Request.Cookies["user"] != null && Request.Cookies["compid"] != null)
{
ESSWebService.CallContext callcont = new ESSWebService.CallContext();
var compid = Request.Cookies["compid"].Value;
var username = Convert.ToInt64(Request.Cookies["user"].Value);
ESSWebService.SDSLoanRequestServicesClient sdsloanreq = new ESSWebService.SDSLoanRequestServicesClient();
sdsloanreq.ClientCredentials.Windows.ClientCredential.Domain = "Soletechs";
ESSWebService.LoanRequest _creloanreq = new ESSWebService.LoanRequest();
sdsloanreq.ClientCredentials.Windows.ClientCredential = new NetworkCredential("webapp", "pass" + '"' + "word123");
_creloanreq.Comments = comment;
_creloanreq.RequestDate = DateTime.Now;
_creloanreq.WorkerRecid = username;
_creloanreq.Loantype = loantype == "-1" ? null : loantype;
_creloanreq.Loanvalue = Convert.ToDecimal(loanamount);
_creloanreq.NoOfInsatllment = Convert.ToInt32(noofinstallment);
_creloanreq.MonthlyInstallment = Convert.ToDecimal(loanamount) / Convert.ToInt32(noofinstallment);
_creloanreq.DeductionStartDate = new DateTime(Convert.ToInt32(deductionistartdate.Split('/')[2]), Convert.ToInt32(deductionistartdate.Split('/')[1]), Convert.ToInt32(deductionistartdate.Split('/')[0]));
_creloanreq.ReasonCode = reason == "-1" ? null : reason;
string g = sdsloanreq.createLoanRequest(callcont, _creloanreq, compid);
return(g);
}
else
{
RedirectToAction("Login", "Account");
return("");
}
}
public ActionResult LetterRequests()
{
if (Request.Cookies["user"] != null && Request.Cookies["compid"] != null)
{
var username = Convert.ToInt64(Request.Cookies["user"].Value);
var compid = Request.Cookies["compid"].Value;
ESSWebService.CallContext callcont = new ESSWebService.CallContext();
ESSWebService.SDSGeneralRequestServiceClient sdgenreq = new ESSWebService.SDSGeneralRequestServiceClient();
sdgenreq.ClientCredentials.Windows.ClientCredential.Domain = "Soletechs";
sdgenreq.ClientCredentials.Windows.ClientCredential = new NetworkCredential("webapp", "pass" + '"' + "word123");
var ss = (from a in sdgenreq.getAllGeneralRequestListByNature(callcont, username, ESSWebService.SDSGeneralNature.Letter, compid).parmGeneralRequestList
select new DTOGeneralRequests
{
TransactionId = a.TransactionId,
RequestId = a.RequestId,
RequestgroupId = "",
Transactiondate = a.Transactiondate.ToShortDateString(),
PersonalNumber = a.NameEn.Split('-')[0],
ReqNature = a.Generalnature.ToString(),
ReasonCode = a.ReasonCode,
Name = a.NameEn.Split('-')[1],
State = a.Status.ToString(),
URL = "/GeneralRequest/ViewGeneralRequestbyId?genreqid=" + a.TransactionId,
}).ToList();
return(View(ss));
}
else
{
return(RedirectToAction("Login", "Account"));
}
}
public ActionResult ExcuseRequests()
{
if (Request.Cookies["user"] != null && Request.Cookies["compid"] != null)
{
var username = Convert.ToInt64(Request.Cookies["user"].Value);
var compid = Request.Cookies["compid"].Value;
ESSWebService.CallContext callcont = new ESSWebService.CallContext();
ESSWebService.SDSExcuseRequestServicesClient sdexcusereq = new ESSWebService.SDSExcuseRequestServicesClient();
sdexcusereq.ClientCredentials.Windows.ClientCredential.Domain = "Soletechs";
sdexcusereq.ClientCredentials.Windows.ClientCredential = new NetworkCredential("webapp", "pass" + '"' + "word123");
var ss = (from a in sdexcusereq.getAllExcuseReqeustByNature(callcont, username, ESSWebService.SDSExcuseNature.Excuse, compid).parmExcuseRequestList
select new DTOExcuseRequest
{
RequestId = a.RequestId,
ExcuseType = ESSWebService.SDSExcuseNature.Excuse.ToString(),
Date = a.RequestDate.ToShortDateString(),
ExcuseId = a.ExcuseType,
PersonalNumber = a.NameEn.Split('-')[0],
Name = a.NameEn.Split('-')[1],
State = a.WorkflowStatus.ToString(),
URL = "/ExcuseRequest/ViewExcuseRequestbyId?requestid=" + a.RequestId,
}).ToList();
return(View(ss));
}
else
{
return(RedirectToAction("Login", "Account"));
}
}
public string CreateLetterRequest(string reason, string requestid, string comment, string reportlang, string sendto)
{
if (Request.Cookies["user"] != null && Request.Cookies["compid"] != null)
{
ESSWebService.CallContext callcont = new ESSWebService.CallContext();
var compid = Request.Cookies["compid"].Value;
var username = Convert.ToInt64(Request.Cookies["user"].Value);
ESSWebService.SDSGeneralRequestServiceClient sdsgenreq = new ESSWebService.SDSGeneralRequestServiceClient();
sdsgenreq.ClientCredentials.Windows.ClientCredential.Domain = "Soletechs";
ESSWebService.GeneralRequest _cregenreq = new ESSWebService.GeneralRequest();
sdsgenreq.ClientCredentials.Windows.ClientCredential = new NetworkCredential("webapp", "pass" + '"' + "word123");
_cregenreq.Comments = comment;
_cregenreq.Transactiondate = DateTime.Now;
_cregenreq.Workerrecid = username;
_cregenreq.RequestId = requestid;
_cregenreq.ReasonCode = reason;
_cregenreq.Sendto = sendto;
_cregenreq.Reportlanguage = (ESSPortal.ESSWebService.SDSReportLang)Convert.ToInt32(reportlang);
_cregenreq.Generalnature = ESSWebService.SDSGeneralNature.Letter;
//_cregenreq.ge
string g = sdsgenreq.createGeneralRequestByNature(callcont, _cregenreq, ESSWebService.SDSGeneralNature.Letter, compid);
return(g);
}
else
{
RedirectToAction("Login", "Account");
return("");
}
}
public ActionResult GetLoanedItemsbyEmployee(string status)
{
if (Request.Cookies["user"] != null && Request.Cookies["compid"] != null)
{
var username = Convert.ToInt64(Request.Cookies["user"].Value);
var compid = Request.Cookies["compid"].Value;
ESSWebService.SDSPersonalInfoServicesClient sdperinfo = new ESSWebService.SDSPersonalInfoServicesClient();
ESSWebService.CallContext callcont = new ESSWebService.CallContext();
sdperinfo.ClientCredentials.Windows.ClientCredential.Domain = "Soletechs";
sdperinfo.ClientCredentials.Windows.ClientCredential = new NetworkCredential("webapp", "pass" + '"' + "word123");
var loanequip = sdperinfo.getAllLoanedEquipList(callcont, username, true).parmAddressList;
var toreturn = (from a in loanequip
select new DTOModels.DTOLoanedItems
{
LoanItem = a.LoanItemId,
LoanDate = a.LoanedDate.ToShortDateString(),
Description = a.Description,
ReturnDate = a.ActualReturnDate.ToShortDateString()
});
return(View("LoanedItem", toreturn));
}
else
{
return(RedirectToAction("Home", "Account"));
// return _perinfo;
}
}
public ActionResult LoanRequests()
{
if (Request.Cookies["user"] != null && Request.Cookies["compid"] != null)
{
var username = Convert.ToInt64(Request.Cookies["user"].Value);
var compid = Request.Cookies["compid"].Value;
ESSWebService.CallContext callcont = new ESSWebService.CallContext();
ESSWebService.SDSLoanRequestServicesClient sdgenreq = new ESSWebService.SDSLoanRequestServicesClient();
sdgenreq.ClientCredentials.Windows.ClientCredential.Domain = "Soletechs";
sdgenreq.ClientCredentials.Windows.ClientCredential = new NetworkCredential("webapp", "pass" + '"' + "word123");
var ss = (from a in sdgenreq.getAllLoanReqeust(callcont, username, compid).parmLoanRequestList
select new DTOLoans
{
LoanRequestId = a.LoanRequestId,
LoanType = a.Loantype.ToString(),
LoanRequested = a.Loanvalue.ToString(),
MonthlyInstallment = a.MonthlyInstallment.ToString(),
NoofInstallment = a.NoOfInsatllment.ToString(),
Date = a.RequestDate.ToShortDateString(),
PersonalNumber = a.NameEn.Split('-')[0],
ReasonCode = a.ReasonCode,
Name = a.NameEn.Split('-')[1],
State = a.Workflowstatus.ToString(),
URL = "/Loan/ViewLoanbyRequestId?loanreqid=" + a.LoanRequestId,
}).ToList();
return(View(ss));
}
else
{
return(RedirectToAction("Login", "Account"));
}
}
public string CreateEosRequest(string reason, string eostype, string comment, string lastworkingday, string noticestartdate)
{
if (Request.Cookies["user"] != null && Request.Cookies["compid"] != null)
{
ESSWebService.CallContext callcont = new ESSWebService.CallContext();
var compid = Request.Cookies["compid"].Value;
var username = Convert.ToInt64(Request.Cookies["user"].Value);
ESSWebService.SDSEosRequestServicesClient sdseosreq = new ESSWebService.SDSEosRequestServicesClient();
sdseosreq.ClientCredentials.Windows.ClientCredential.Domain = "Soletechs";
ESSWebService.EosRequest _creeosreq = new ESSWebService.EosRequest();
sdseosreq.ClientCredentials.Windows.ClientCredential = new NetworkCredential("webapp", "pass" + '"' + "word123");
_creeosreq.Comments = comment;
_creeosreq.RequestDate = DateTime.Now;
_creeosreq.WorkerRecid = username;
_creeosreq.EOSRequestType = eostype;
_creeosreq.ReasonCode = reason;
_creeosreq.LastWorkingDate = new DateTime(Convert.ToInt32(lastworkingday.Split('/')[2]), Convert.ToInt32(lastworkingday.Split('/')[1]), Convert.ToInt32(lastworkingday.Split('/')[0]));
_creeosreq.NoticeStartDate = new DateTime(Convert.ToInt32(noticestartdate.Split('/')[2]), Convert.ToInt32(noticestartdate.Split('/')[1]), Convert.ToInt32(noticestartdate.Split('/')[0]));
string g = sdseosreq.createEosRequest(callcont, _creeosreq, compid);
return(g);
}
else
{
RedirectToAction("Login", "Account");
return("");
}
}
public ActionResult EOSRequests()
{
if (Request.Cookies["user"] != null && Request.Cookies["compid"] != null)
{
var username = Convert.ToInt64(Request.Cookies["user"].Value);
var compid = Request.Cookies["compid"].Value;
ESSWebService.CallContext callcont = new ESSWebService.CallContext();
ESSWebService.SDSEosRequestServicesClient sdgenreq = new ESSWebService.SDSEosRequestServicesClient();
sdgenreq.ClientCredentials.Windows.ClientCredential.Domain = "Soletechs";
sdgenreq.ClientCredentials.Windows.ClientCredential = new NetworkCredential("webapp", "pass" + '"' + "word123");
var ss = (from a in sdgenreq.getAllEosReqeust(callcont, username, compid).parmEosRequestList
select new DTOEOS
{
EOSID = a.EosRequestId,
Date = a.RequestDate.ToShortDateString(),
EOSType = a.EOSRequestType.ToString(),
Worker = a.NameEn.Split('-')[1],
PersonalNumber = a.NameEn.Split('-')[0],
Status = a.Workflowstatus.ToString(),
Reason = a.ReasonCode,
URL = "/EOS/ViewEOSRequestbyId?EOSid=" + a.EosRequestId,
}).ToList();
return(View(ss));
}
else
{
return(RedirectToAction("Login", "Account"));
}
}
public ActionResult BusinessTripRequests()
{
if (Request.Cookies["user"] != null && Request.Cookies["compid"] != null)
{
var username = Convert.ToInt64(Request.Cookies["user"].Value);
var compid = Request.Cookies["compid"].Value;
ESSWebService.CallContext callcont = new ESSWebService.CallContext();
ESSWebService.SDSBusinessTripRequestServicesClient sdbustripreq = new ESSWebService.SDSBusinessTripRequestServicesClient();
sdbustripreq.ClientCredentials.Windows.ClientCredential.Domain = "Soletechs";
sdbustripreq.ClientCredentials.Windows.ClientCredential = new NetworkCredential("webapp", "pass" + '"' + "word123");
var ss = (from a in sdbustripreq.getAllBusinessTripReqeust(callcont, username, compid).parmBusinessTripRequestList
select new DTOBusinessTrip
{
BusinessTripId = a.RequestId,
ToDate = a.ToDaTE.ToShortDateString(),
FromDate = a.FromDate.ToShortDateString(),
Destination = a.Destination,
PersonalNumber = a.NameEn.Split('-')[0],
RequestDate = a.RequestDate.ToShortDateString(),
Name = a.NameEn.Split('-')[1],
State = a.WorkflowStatus.ToString(),
URL = "/BusinessTrip/ViewBusinessTripbyRequestbyId?requestid=" + a.RequestId,
}).ToList();
return(View(ss));
}
else
{
return(RedirectToAction("Login", "Account"));
}
}
public string ApproveBusinessTripbyId(string id, string Comment)
{
if (Request.Cookies["user"] != null && Request.Cookies["compid"] != null)
{
try
{
ESSWebService.CallContext callcont = new ESSWebService.CallContext();
var compid = Request.Cookies["compid"].Value;
var username = Convert.ToInt64(Request.Cookies["user"].Value);
ESSWebService.SDSBusinessTripRequestServicesClient sdbustripreq = new ESSWebService.SDSBusinessTripRequestServicesClient();
sdbustripreq.ClientCredentials.Windows.ClientCredential.Domain = "Soletechs";
sdbustripreq.ClientCredentials.Windows.ClientCredential = new NetworkCredential("webapp", "pass" + '"' + "word123");
ESSWebService.BusinessTripRequest _crbustripreq = new ESSWebService.BusinessTripRequest();
_crbustripreq = sdbustripreq.getPendingWorkflowList(callcont, username).parmBusinessTripRequestList.Where(x => x.RequestId == id).FirstOrDefault();
return(sdbustripreq.Approve(callcont, _crbustripreq.WorkflowItem, username, compid));
}
catch (Exception ex)
{
throw ex;
}
}
else
{
RedirectToAction("Login", "Account");
return("");
// return _perinfo;
}
}
public string Workflowforrequest(string requesid)
{
string workcom = "";
ESSWebService.CallContext callcont = new ESSWebService.CallContext();
var compid = Request.Cookies["compid"].Value;
var username = Convert.ToInt64(Request.Cookies["user"].Value);
ESSWebService.SDSLeaveRequestServicesClient sdsworkcom = new ESSWebService.SDSLeaveRequestServicesClient();
sdsworkcom.ClientCredentials.Windows.ClientCredential.Domain = "Soletechs";
sdsworkcom.ClientCredentials.Windows.ClientCredential = new NetworkCredential("webapp", "pass" + '"' + "word123");
ESSWebService.SDSWorkflowApprovalWorkItemHistory workflowHistory = sdsworkcom.getWorkflowHistory(callcont, requesid, compid);
if (workflowHistory != null)
{
foreach (ESSWebService.SDSWorkflowApprovalWorkItemComment wfHistory in workflowHistory.Comments)
{
if (wfHistory.IsStep == 0)
{
workcom = workcom + (wfHistory.Time + " - " + wfHistory.ActionLabel + " - " + "Comments : " + wfHistory.Comment) + " \n";
}
else
{
workcom = workcom + (wfHistory.StepName) + " \n";
}
}
}
return(workcom);
}
public JsonResult GetLeaveRequestsByEmployeeLogIn()
{
if (Request.Cookies["user"] != null && Request.Cookies["compid"] != null)
{
var username = Convert.ToInt64(Request.Cookies["user"].Value);
var compid = Request.Cookies["compid"].Value;
ESSWebService.CallContext callcont = new ESSWebService.CallContext();
ESSWebService.SDSLeaveRequestServicesClient sd = new ESSWebService.SDSLeaveRequestServicesClient();
sd.ClientCredentials.Windows.ClientCredential.Domain = "Soletechs";
sd.ClientCredentials.Windows.ClientCredential = new NetworkCredential("webapp", "pass" + '"' + "word123");
var ss = (from a in sd.getAllleaveRequestList(callcont, username, compid).parmGeneralRequestList
select new DTOLeaveRequest
{
LeaveRequest = a.Leaverequestid,
LeaveType = a.Leavetypeid,
RequestDate = a.Transactiondate.ToShortDateString(),
FromDate = a.Fromdate.ToShortDateString(),
ToDate = a.ToDate.ToShortDateString(),
PersonalNumber = a.WorkerRecid.ToString(),
Worker = a.NameEn,
State = a.Workflowstatus.ToString(),
URL = "/LeaveRequest/ViewRequestbyRequestId?LeaveRequestNumber=" + a.Leaverequestid,
//Attachment = a.
}).ToList();
return(Json(ss, JsonRequestBehavior.AllowGet));
}
else
{
RedirectToAction("Login", "Account");
// return _perinfo;
return(Json(""));
}
}
public ActionResult PayslipbyEmployee(string month, string year)
{
if (Request.Cookies["user"] != null && Request.Cookies["compid"] != null)
{
int monthval;
int yearval;
monthval = month != null && month != "" ? Convert.ToInt32(month) : DateTime.Now.AddMonths(-1).Month;
yearval = year != null && year != "" ? Convert.ToInt32(year) : DateTime.Now.AddMonths(-1).Year;
var username = Convert.ToInt64(Request.Cookies["user"].Value);
var compid = Request.Cookies["compid"].Value;
ESSWebService.SDSPaySlipInfoServiceClient sdspayslip = new ESSWebService.SDSPaySlipInfoServiceClient();
ESSWebService.CallContext callcont = new ESSWebService.CallContext();
sdspayslip.ClientCredentials.Windows.ClientCredential.Domain = "Soletechs";
sdspayslip.ClientCredentials.Windows.ClientCredential = new NetworkCredential("webapp", "pass" + '"' + "word123");
var hdr = sdspayslip.getPaySlipInfo(callcont, username, yearval, monthval, compid);
var lines = sdspayslip.getPaySlipLineInfoList(callcont, username, yearval, monthval, compid).parmpaySlipLineInfoList;
DTOModels.DTOPayslip payslip = new DTOModels.DTOPayslip();
payslip.FromDate = hdr.Fromdate.ToShortDateString();
payslip.ToDate = hdr.Todate.ToShortDateString();
payslip.Month = hdr.Months.ToString();
payslip.Year = hdr.Year.ToString();
payslip.Paycycle = hdr.PaycycleId;
payslip.Paygroup = hdr.PayGroup;
payslip.TotalDeductions = hdr.TotalDeductions.ToString("#,##0");
payslip.TotalEarnings = hdr.TotalEarnings.ToString("#,##0");
payslip.NetAmount = hdr.Netsalary.ToString("#,##0");
payslip.Earnings = (from a in lines
where (int)a.SourceType == 0
select new DTOModels.DTOEarnings
{
Amount = Convert.ToDecimal(a.Amount).ToString("#,##0"),
EarningsType = a.Paymenttype,
EarningsTypeID = a.PayCode,
}).ToList();
payslip.Deductions = (from a in lines
where (int)a.SourceType == 1
select new DTOModels.DTODeductions
{
Amount = Convert.ToDecimal(a.Amount).ToString("#,##0"),
DeductionType = a.Paymenttype,
DeductionTypeID = a.PayCode,
}).ToList();
return(View("Payslip", payslip));
}
else
{
return(RedirectToAction("Login"));
// return _perinfo;
}
}
public JsonResult getleavetypes()
{
ESSWebService.CallContext callcont = new ESSWebService.CallContext();
var compid = Request.Cookies["compid"].Value;
var username = Convert.ToInt64(Request.Cookies["user"].Value);
ESSWebService.SDSLeaveRequestServicesClient sdleavereq = new ESSWebService.SDSLeaveRequestServicesClient();
sdleavereq.ClientCredentials.Windows.ClientCredential.Domain = "Soletechs";
sdleavereq.ClientCredentials.Windows.ClientCredential = new NetworkCredential("webapp", "pass" + '"' + "word123");
var leavetypes = sdleavereq.getLeaveTypeId_2(callcont, username, compid).parmleaveTypeIdList;
return(Json(leavetypes, JsonRequestBehavior.AllowGet));
}
public JsonResult getexecustypesforTraining()
{
var username = Convert.ToInt64(Request.Cookies["user"].Value);
var compid = Request.Cookies["compid"].Value;
ESSWebService.CallContext callcont = new ESSWebService.CallContext();
ESSWebService.SDSExcuseRequestServicesClient sdexcusereq = new ESSWebService.SDSExcuseRequestServicesClient();
sdexcusereq.ClientCredentials.Windows.ClientCredential.Domain = "Soletechs";
sdexcusereq.ClientCredentials.Windows.ClientCredential = new NetworkCredential("webapp", "pass" + '"' + "word123");
var retreasons = sdexcusereq.getExcuseTypeIdByNature(callcont, ESSWebService.SDSExcuseNature.Training, compid).parmExcuseTypeIdList;
return(Json(retreasons, JsonRequestBehavior.AllowGet));
}
public JsonResult getrequestreasons()
{
ESSWebService.CallContext callcont = new ESSWebService.CallContext();
var compid = Request.Cookies["compid"].Value;
var username = Convert.ToInt64(Request.Cookies["user"].Value);
ESSWebService.SDSBusinessTripRequestServicesClient sdbustripreq = new ESSWebService.SDSBusinessTripRequestServicesClient();
sdbustripreq.ClientCredentials.Windows.ClientCredential.Domain = "Soletechs";
sdbustripreq.ClientCredentials.Windows.ClientCredential = new NetworkCredential("webapp", "pass" + '"' + "word123");
var retreasons = sdbustripreq.getReasonCodes(callcont, compid).parmReasonCodeList;
return(Json(retreasons, JsonRequestBehavior.AllowGet));
}
public ActionResult LeaveRequestAng(int pageNumber, int pageSize)
{
if (Request.Cookies["user"] != null && Request.Cookies["compid"] != null)
{
var username = Convert.ToInt64(Request.Cookies["user"].Value);
var compid = Request.Cookies["compid"].Value;
ESSWebService.CallContext callcont = new ESSWebService.CallContext();
ESSWebService.SDSLeaveRequestServicesClient sd = new ESSWebService.SDSLeaveRequestServicesClient();
sd.ClientCredentials.Windows.ClientCredential.Domain = "Soletechs";
sd.ClientCredentials.Windows.ClientCredential = new NetworkCredential("webapp", "pass" + '"' + "word123");
//sd.getPendingWorkflowList()
// sd.Approve()
// sd.getAllleaveRequestList(callcont, username, compid).
List <DTOLeaveRequest> leavereqList = null; int recordsTotal = 0;
var ss = (from a in sd.getAllleaveRequestList(callcont, username, compid).parmGeneralRequestList.Where(x => x.Leaverequestnature == ESSWebService.SDSLeaveReqNature.LeaveRequest).ToList()
select new DTOLeaveRequest
{
LeaveRequest = a.Leaverequestid,
LeaveType = a.Leavetypeid,
RequestDate = a.Transactiondate.ToShortDateString(),
FromDate = a.Fromdate.ToShortDateString(),
ToDate = a.ToDate.ToShortDateString(),
PersonalNumber = a.NameEn.Split('-')[0],
Worker = a.NameEn.Split('-')[1],
State = a.Workflowstatus.ToString(),
LeaveReqNature = ((int)a.Leaverequestnature).ToString(),
URL = "/LeaveRequest/ViewRequestbyRequestId?LeaveRequestNumber=" + a.Leaverequestid,
//Attachment = a.
}).ToList();
recordsTotal = ss.Count();
//leavereqList = ss
// .Skip(pageNumber)
// .Take(pageSize)
// .ToList();
leavereqList = ss
.ToList();
return(Json(new
{
recordsTotal,
leavereqList
}, JsonRequestBehavior.AllowGet));
}
else
{
return(RedirectToAction("Home", "Account"));
// return _perinfo;
}
}
public JsonResult getticketbalance(string leavetype, string nooftickets)
{
ESSWebService.CallContext callcont = new ESSWebService.CallContext();
var compid = Request.Cookies["compid"].Value;
var username = Convert.ToInt64(Request.Cookies["user"].Value);
ESSWebService.SDSLeaveRequestServicesClient sdleavereq = new ESSWebService.SDSLeaveRequestServicesClient();
sdleavereq.ClientCredentials.Windows.ClientCredential.Domain = "Soletechs";
sdleavereq.ClientCredentials.Windows.ClientCredential = new NetworkCredential("webapp", "pass" + '"' + "word123");
var intnumtckt = nooftickets != "" ? Convert.ToInt32(nooftickets) : 0;
var tckbalance = sdleavereq.getTicketBalance(callcont, username, intnumtckt, DateTime.Now, leavetype, compid);
return(Json(tckbalance, JsonRequestBehavior.AllowGet));
}
public JsonResult GetAlternativeWorkers()
{
//sdleavereq.de
ESSWebService.CallContext callcont = new ESSWebService.CallContext();
var compid = Request.Cookies["compid"].Value;
var username = Convert.ToInt64(Request.Cookies["user"].Value);
ESSWebService.SDSBusinessTripRequestServicesClient sdbustripreq = new ESSWebService.SDSBusinessTripRequestServicesClient();
sdbustripreq.ClientCredentials.Windows.ClientCredential.Domain = "Soletechs";
sdbustripreq.ClientCredentials.Windows.ClientCredential = new NetworkCredential("webapp", "pass" + '"' + "word123");
var alternateworkers = sdbustripreq.getAlternateWorker_Lookup(callcont, username, compid).parmList;
return(Json(alternateworkers, JsonRequestBehavior.AllowGet));
}
public string ValidateLogin(string username, string password)
{
try
{
//http://172.22.226.148:31564/MicrosoftDynamicsAXAif60/AxTest/xppservice.svc
//http://dc01:3340/MicrosoftDynamicsAXAif60/AxMobServices/xppservice.svc
//BasicHttpBinding binding = new BasicHttpBinding();
//EndpointAddress epAddr = new EndpointAddress("http://172.22.226.148:31564/MicrosoftDynamicsAXAif60/AxTest/xppservice.svc");
//ESSWebService.SDSPersonalInfoServices servref = ChannelFactory<ESSWebService.SDSPersonalInfoServices>.CreateChannel(binding, epAddr);
//ESSWebService.SDSPersonalInfoServicesClient sd = new ESSWebService.SDSPersonalInfoServicesClient(binding, epAddr);
ESSWebService.SDSLoginServicesClient sd = new ESSWebService.SDSLoginServicesClient();
sd.ClientCredentials.Windows.ClientCredential.Domain = "Soletechs";
sd.ClientCredentials.Windows.ClientCredential = new NetworkCredential("webapp", "pass" + '"' + "word123");
//sd.ClientCredentials.Windows.ClientCredential.UserName = "******";
//sd.ClientCredentials.Windows.ClientCredential.Password = "******" + '"' + "word123";
ESSWebService.CallContext callcont = new ESSWebService.CallContext();
ESSWebService.Permission _permissionlInfo = sd.ValidateUserEncrypted(callcont, username, password);
callcont.LogonAsUser = "";
var userCookie = new HttpCookie("user", _permissionlInfo.WorkerRecId.ToString());
var compCookie = new HttpCookie("compid", _permissionlInfo.CompanyId);
var useridCookie = new HttpCookie("userlogid", username);
var language = new HttpCookie("Language", "En");
//add Language Cookie
//language cookie by default English
//language = new HttpCookie("Language", "En");
userCookie.Expires.AddDays(365);
compCookie.Expires.AddDays(365);
useridCookie.Expires.AddDays(365);
language.Expires.AddDays(365);
HttpContext.Response.Cookies.Add(userCookie);
HttpContext.Response.Cookies.Add(compCookie);
HttpContext.Response.Cookies.Add(useridCookie);
//if (Request.Cookies["Language"] == null)
//{
HttpContext.Response.Cookies.Add(language);
//}
// ESSWebService.SDSPersonPhotoData photo = sd.getPersonPhoto(callcont, Convert.ToInt64("52565425785"));
return("");
}
catch (Exception ex)
{
//throw new Exception("Username or password is Incorrect");
return(ex.Message);
}
}
public ActionResult MenuLayout()
{
DTOModels.DTOPersonalInfo _perinfo = new DTOModels.DTOPersonalInfo();
if (Request.Cookies["user"] != null && Request.Cookies["compid"] != null)
{
DateTime _nulldate = new DateTime(1990, 1, 1);
var username = Convert.ToInt64(Request.Cookies["user"].Value);
var compid = Request.Cookies["compid"].Value;
ESSWebService.SDSPersonalInfoServicesClient sd = new ESSWebService.SDSPersonalInfoServicesClient();
sd.ClientCredentials.Windows.ClientCredential.Domain = "Soletechs";
sd.ClientCredentials.Windows.ClientCredential = new NetworkCredential("webapp", "pass" + '"' + "word123");
ESSWebService.CallContext callcont = new ESSWebService.CallContext();
ESSPortal.ESSWebService.PersonalInfo perinfoser = sd.getOnePersonalInfo(callcont, username);
_perinfo.ArabicName = perinfoser.ArabicName;
_perinfo.EnglishName = perinfoser.EnglishName;
_perinfo.FirstName = perinfoser.EnglishName.Split(' ')[0];
_perinfo.NewID = perinfoser.OldId;
_perinfo.OldID = perinfoser.OldId;
_perinfo.JoiningDate = perinfoser.Joiningdate == _nulldate ? "-" : perinfoser.Joiningdate.ToShortDateString();
_perinfo.BirthDate = perinfoser.Birthdate == _nulldate ?null : perinfoser.Birthdate.ToShortDateString();
_perinfo.JobType = perinfoser.JobId;
_perinfo.JobDesc = perinfoser.JobTypeId;
_perinfo.PositionDesc = perinfoser.Positiondescription;
_perinfo.PositionId = perinfoser.PositionId;
_perinfo.Companyname = perinfoser.Companyname;
_perinfo.Gender = perinfoser.Gender;
_perinfo.MaritalStatus = perinfoser.Maritalstatus;
ESSPortal.ESSWebService.SDSAddressListDC lstadd = perinfoser.AddressList;
_perinfo.ImageArray = (sd.getPersonPhoto(callcont, Convert.ToInt64(username))).parmPersonPhoto;
// lstadd.parmAddressList
_perinfo.Departmentname = perinfoser.DepartmentName;
_perinfo.ProbationEndDate = perinfoser.ProbationEndDate == _nulldate ? "-" : perinfoser.ProbationEndDate.ToShortDateString();
//if ((sd.getPersonPhoto(callcont, Convert.ToInt64(username))).parmPersonPhoto != null)
// _perinfo.ImageArray = Encoding.ASCII.GetBytes((sd.getPersonPhoto(callcont, Convert.ToInt64(username))).parmPersonPhoto);
// C:\Sabri\SoltechESSPortal\ESSPortal\ESSPortal\Views\.cshtml
return(PartialView("~/Views/LeftProfile.cshtml", _perinfo));
}
else
{
return(RedirectToAction("Login", "Account"));
// return _perinfo;
}
}
public string SubmitLeaveReturn(string leaverequestid, string date, string comments)
{
if (Request.Cookies["user"] != null && Request.Cookies["compid"] != null)
{
var username = Convert.ToInt64(Request.Cookies["user"].Value);
var compid = Request.Cookies["compid"].Value;
ESSWebService.CallContext callcont = new ESSWebService.CallContext();
ESSWebService.SDSLeaveRequestServicesClient sd = new ESSWebService.SDSLeaveRequestServicesClient();
sd.ClientCredentials.Windows.ClientCredential.Domain = "Soletechs";
sd.ClientCredentials.Windows.ClientCredential = new NetworkCredential("webapp", "pass" + '"' + "word123");
return(sd.ReturnLeaveRequest(callcont, leaverequestid, new DateTime(Convert.ToInt32(date.Split('/')[2]), Convert.ToInt32(date.Split('/')[1]), Convert.ToInt32(date.Split('/')[0])), compid));
}
else
{
RedirectToAction("Login", "Account");
return("");
}
}
public ActionResult SubmittedRequestsbyType(string reqnature)
{
if (Request.Cookies["user"] != null && Request.Cookies["compid"] != null)
{
var username = Convert.ToInt64(Request.Cookies["user"].Value);
var compid = Request.Cookies["compid"].Value;
ESSWebService.CallContext callcont = new ESSWebService.CallContext();
ESSWebService.SDSLeaveRequestServicesClient sd = new ESSWebService.SDSLeaveRequestServicesClient();
sd.ClientCredentials.Windows.ClientCredential.Domain = "Soletechs";
sd.ClientCredentials.Windows.ClientCredential = new NetworkCredential("webapp", "pass" + '"' + "word123");
//sd.getPendingWorkflowList()
// sd.Approve()
// sd.getAllleaveRequestList(callcont, username, compid).
var ss = (from a in sd.getPendingWorkflowList(callcont, username).parmGeneralRequestList
select new DTOLeaveRequest
{
LeaveRequest = a.Leaverequestid,
LeaveType = a.Leavetypeid,
RequestDate = a.Transactiondate.ToShortDateString(),
FromDate = a.Fromdate.ToShortDateString(),
ToDate = a.ToDate.ToShortDateString(),
PersonalNumber = a.NameEn.Split('-')[0],
Worker = a.NameEn.Split('-')[1],
State = a.Workflowstatus.ToString(),
LeaveReqNature = ((int)a.Leaverequestnature).ToString(),
WorkflowRecId = a.WorkflowItem,
URL = "/LeaveRequest/ViewRequestbyRequestId?LeaveRequestNumber=" + a.Leaverequestid,
//Attachment = a.
}).ToList();
if (reqnature != null && reqnature != "")
{
ss = ss.Where(x => x.LeaveReqNature == reqnature).OrderByDescending(x => x.LeaveRequest).ToList();
}
return(View(ss));
}
else
{
return(RedirectToAction("Login", "Account"));
// return _perinfo;
}
}
public ActionResult ViewEOSRequestbyId(string EOSid)
{
if (Request.Cookies["user"] != null && Request.Cookies["compid"] != null)
{
ESSWebService.CallContext callcont = new ESSWebService.CallContext();
var compid = Request.Cookies["compid"].Value;
var username = Convert.ToInt64(Request.Cookies["user"].Value);
ESSWebService.SDSEosRequestServicesClient sdseosreq = new ESSWebService.SDSEosRequestServicesClient();
sdseosreq.ClientCredentials.Windows.ClientCredential.Domain = "Soletechs";
sdseosreq.ClientCredentials.Windows.ClientCredential = new NetworkCredential("webapp", "pass" + '"' + "word123");
var ss = sdseosreq.getEosReqeust(callcont, EOSid, compid);
ss.NameAr = Workflowforrequest(EOSid);
return(View(ss));
}
else
{
return(RedirectToAction("Login", "Account"));
}
}
public ActionResult AllLoansbyEmployee()
{
if (Request.Cookies["user"] != null && Request.Cookies["compid"] != null)
{
var username = Convert.ToInt64(Request.Cookies["user"].Value);
var compid = Request.Cookies["compid"].Value;
ESSWebService.CallContext callcont = new ESSWebService.CallContext();
ESSWebService.SDSLoanRequestServicesClient sdloan = new ESSWebService.SDSLoanRequestServicesClient();
sdloan.ClientCredentials.Windows.ClientCredential.Domain = "Soletechs";
sdloan.ClientCredentials.Windows.ClientCredential = new NetworkCredential("webapp", "pass" + '"' + "word123");
// sdloan.getAllLoanReqeust(callcont, username, compid).parmLoanRequestList;
return(RedirectToAction("Home", "Account"));
}
else
{
return(RedirectToAction("Home", "Account"));
}
}
public ActionResult ViewallLeaveTravelled(string LeaveRequestNumber)
{
if (Request.Cookies["user"] != null && Request.Cookies["compid"] != null)
{
ESSWebService.CallContext callcont = new ESSWebService.CallContext();
var compid = Request.Cookies["compid"].Value;
var username = Convert.ToInt64(Request.Cookies["user"].Value);
ESSWebService.SDSLeaveRequestServicesClient sdleavereq = new ESSWebService.SDSLeaveRequestServicesClient();
sdleavereq.ClientCredentials.Windows.ClientCredential.Domain = "Soletechs";
sdleavereq.ClientCredentials.Windows.ClientCredential = new NetworkCredential("webapp", "pass" + '"' + "word123");
ESSWebService.LeaveRequest _leavereq = new ESSWebService.LeaveRequest();
_leavereq = sdleavereq.getleaveRequest(callcont, LeaveRequestNumber, compid);
_leavereq.NameAr = Workflowforrequest(LeaveRequestNumber);
return(View(_leavereq));
}
else
{
return(RedirectToAction("Login", "Account"));
}
}
public JsonResult getleavebalance(string leavetype, string fromdate, string todate)
{
try
{
ESSWebService.CallContext callcont = new ESSWebService.CallContext();
var compid = Request.Cookies["compid"].Value;
var username = Convert.ToInt64(Request.Cookies["user"].Value);
ESSWebService.SDSLeaveRequestServicesClient sdleavereq = new ESSWebService.SDSLeaveRequestServicesClient();
sdleavereq.ClientCredentials.Windows.ClientCredential.Domain = "Soletechs";
sdleavereq.ClientCredentials.Windows.ClientCredential = new NetworkCredential("webapp", "pass" + '"' + "word123");
DateTime frmdatedt = fromdate != "" ? Convert.ToDateTime(fromdate) : DateTime.Now;
DateTime todatedt = todate != "" ? Convert.ToDateTime(todate) : DateTime.Now;
var balance = sdleavereq.getLeaveBalance(callcont, username, leavetype, frmdatedt, todatedt, compid);
return(Json(balance, JsonRequestBehavior.AllowGet));
}
catch (Exception ex)
{
var ms = ex.Message;
throw;
}
}
public string ApproveEOSRequestbyRequestNumber(string eosid, string Comment)
{
if (Request.Cookies["user"] != null && Request.Cookies["compid"] != null)
{
ESSWebService.CallContext callcont = new ESSWebService.CallContext();
var compid = Request.Cookies["compid"].Value;
var username = Convert.ToInt64(Request.Cookies["user"].Value);
ESSWebService.SDSEosRequestServicesClient sdleavereq = new ESSWebService.SDSEosRequestServicesClient();
sdleavereq.ClientCredentials.Windows.ClientCredential.Domain = "Soletechs";
sdleavereq.ClientCredentials.Windows.ClientCredential = new NetworkCredential("webapp", "pass" + '"' + "word123");
ESSWebService.EosRequest _crleavereq = new ESSWebService.EosRequest();
_crleavereq = sdleavereq.getPendingWorkflowList(callcont, username).parmEosRequestList.Where(x => x.EosRequestId == eosid).FirstOrDefault();
return(sdleavereq.Approve(callcont, _crleavereq.WorkflowItem, username, compid));
}
else
{
RedirectToAction("Login", "Account");
return("");
// return _perinfo;
}
}
public ActionResult GetAttendancebyDate(string FromDate, string ToDate, string ByTeam)
{
try
{
if (Request.Cookies["user"] != null && Request.Cookies["compid"] != null)
{
var username = Convert.ToInt64(Request.Cookies["user"].Value);
var compid = Request.Cookies["compid"].Value;
ESSWebService.SDSAttendanceInfoServicesClient sattendance = new ESSWebService.SDSAttendanceInfoServicesClient();
ESSWebService.CallContext callcont = new ESSWebService.CallContext();
sattendance.ClientCredentials.Windows.ClientCredential.Domain = "Soletechs";
sattendance.ClientCredentials.Windows.ClientCredential = new NetworkCredential("webapp", "pass" + '"' + "word123");
var from = new DateTime(2017, 10, 11);
var to = new DateTime(2017, 11, 11);
var attlist = sattendance.getAttendanceList(callcont, username, from, to).parmAttendanceList;
var toreturn = (from a in attlist
select new DTOModels.DTOMyAttendance
{
Date = a.Date.ToShortDateString(),
Time = a.Time,
Event = a.Event,
Excused = a.IsExcuse == 0 ? "No" : "Yes"
}).ToList();
return(View("MyAttendance", toreturn));
}
else
{
//return View("Account/Login");
return(RedirectToAction("Login", "Account"));
// return _perinfo;
}
}
catch (Exception ex)
{
// return Redirect("Account/Home");
//return View("Account/Login");
return(RedirectToAction("Home", "Account"));
}
}
public string CreateExcuseRequestbyNature(string reason, string execuseid, string comment,
string excusenature, string frmtime, string totime, string requestdate)
{
if (Request.Cookies["user"] != null && Request.Cookies["compid"] != null)
{
string g = "";
ESSWebService.CallContext callcont = new ESSWebService.CallContext();
var compid = Request.Cookies["compid"].Value;
var username = Convert.ToInt64(Request.Cookies["user"].Value);
ESSWebService.SDSExcuseRequestServicesClient sdsexcreq = new ESSWebService.SDSExcuseRequestServicesClient();
sdsexcreq.ClientCredentials.Windows.ClientCredential.Domain = "Soletechs";
ESSWebService.ExcuseRequest _creeosreq = new ESSWebService.ExcuseRequest();
sdsexcreq.ClientCredentials.Windows.ClientCredential = new NetworkCredential("webapp", "pass" + '"' + "word123");
_creeosreq.Comments = comment;
//_creeosreq.RequestDate = DateTime.Now;
_creeosreq.RequestDate = new DateTime(Convert.ToInt32(requestdate.Split('/')[2]), Convert.ToInt32(requestdate.Split('/')[1]), Convert.ToInt32(requestdate.Split('/')[0]));
_creeosreq.WorkerRecId = username;
_creeosreq.ExcuseType = execuseid == "-1" ? null : execuseid;
_creeosreq.ReasonCode = reason == "-1" ? null : reason;
_creeosreq.FromTime = Helper.Helper.Timetoint(frmtime);
_creeosreq.ToTime = Helper.Helper.Timetoint(totime);
//_creeosreq.FromTime = 2;
//_creeosreq.ToTime = 2;
if (_creeosreq.ToTime >= _creeosreq.FromTime)
{
g = sdsexcreq.createExcuseRequestByNature(callcont, _creeosreq, (ESSWebService.SDSExcuseNature)Convert.ToInt32(excusenature), compid);
}
else
{
g = "Totime should be greater than from date";
}
return(g);
}
else
{
RedirectToAction("Login", "Account");
return("");
}
}