コード例 #1
0
        private void SubmitRequest(string code, string sentto, string email)
        {
            var signerQuery = dbContext.tblRequests.Where(x => x.JR_Code == jrcode).ToList();

            foreach (var item in signerQuery)
            {
                tblRequest tblData = item as tblRequest;

                if (tblData.Is_Submitted == true &&
                    tblData.Is_Checked == false &&
                    tblData.Is_Assessed == false &&
                    tblData.Is_Approved == false &&
                    tblData.Is_Noted == false)
                {
                    SendEmailToChecker(sentto.Trim(), code.Trim(), email.Trim());
                }
                else if (tblData.Is_Submitted == true &&
                         tblData.Is_Checked == true &&
                         tblData.Is_Assessed == true &&
                         tblData.Is_Approved == false &&
                         tblData.Is_Noted == false)
                {
                    SendEmailToNoter(sentto.Trim(), code.Trim(), email.Trim());
                }
            }
        }
コード例 #2
0
        private void RejectExecute()
        {
            try
            {
                MessageBoxButton btnMessageBox = MessageBoxButton.YesNo;
                MessageBoxImage  icnMessageBox = MessageBoxImage.Question;

                MessageBoxResult resultMessageBox = MessageBox.Show("Are you sure you want to reject friend request?", "Accept approval", btnMessageBox, icnMessageBox);

                if (resultMessageBox == MessageBoxResult.Yes)
                {
                    int userSending  = UserRequest.UserID_Sending;
                    int userToFindID = (from r in context.tblUsers where r.Username == Username select r.UserID).FirstOrDefault();

                    tblRequest requestToFind = (from r in context.tblRequests where r.UserID_Receiving == userToFindID && r.UserID_Sending == userSending select r).FirstOrDefault();
                    context.tblRequests.Remove(requestToFind);
                    context.SaveChanges();
                    MessageBox.Show("Friend request is rejected!");
                    UserRequestList = tool.GetRequests(Username);
                }
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.ToString());
            }
        }
コード例 #3
0
 PgNotification Map(tblRequest request)
 {
     PgNotification note = new PgNotification();
     if((PgMessageType)request.MessageType==PgMessageType.SMSCN)
     {
         note = new SmscNotification();
     }
     if ((PgMessageType)request.MessageType == PgMessageType.SMSCP)
     {
         note = new SmscPaymentConfirmation();
     }
     note.Amount = request.Amount;
     note.ApplicationId = request.ApplicationId;
     note.MessageType = (PgMessageType) request.MessageType;
     note.Payee = request.Payee;
     note.ReferenceNumber = request.ReferenceId;
                                
     if(note.MessageType==PgMessageType.SMSCN)
     {
        var smscn = note as SmscNotification;
         smscn.OutletPhoneNumber = request.Smsc_PhoneNumber;
         smscn.TillNumber = request.Smsc_TillNumber;
     }
   
     return note;
 }
コード例 #4
0
        public ActionResult DeleteConfirmed(int id)
        {
            tblRequest tblRequest = db.tblRequests.Find(id);

            db.tblRequests.Remove(tblRequest);
            db.SaveChanges();
            return(RedirectToAction("Index"));
        }
コード例 #5
0
 public ActionResult Edit([Bind(Include = "IDRequest,DateRequest,DateNeeded,RequestedBy,Request,Budget,ApprovedBy,IDRequestStatus,ApproverNotes,DateApproved,RequestorEmail,DateAcc,RequestorNotes")] tblRequest tblRequest)
 {
     if (ModelState.IsValid)
     {
         db.Entry(tblRequest).State = EntityState.Modified;
         db.SaveChanges();
         return(RedirectToAction("Index"));
     }
     return(View(tblRequest));
 }
コード例 #6
0
        public ActionResult Create([Bind(Include = "IDRequest,DateRequest,DateNeeded,RequestedBy,Request,Budget,ApprovedBy,IDRequestStatus,ApproverNotes,DateApproved,RequestorEmail,DateAcc,RequestorNotes")] tblRequest tblRequest)
        {
            if (ModelState.IsValid)
            {
                db.tblRequests.Add(tblRequest);
                db.SaveChanges();
                return(RedirectToAction("Index"));
            }

            return(View(tblRequest));
        }
コード例 #7
0
        public ActionResult EmployeeResignations(RequestVM view)
        {
            var empid = Session["EmployeeId"].ToString();
            var cc    = Convert.ToInt32(Session["CompanyCode"].ToString());
            var cci   = Convert.ToInt32(Session["CityCode"].ToString());
            var di    = Convert.ToInt32(Session["DepartmentId"].ToString());
            var pos   = Session["Position"].ToString();
            var ename = Session["Employeename"].ToString();

            var req = db.tblRequestdetails.SqlQuery("select * from tblRequestdetail where EmployeeId=" + Convert.ToInt32(empid) + "").FirstOrDefault();

            if (req == null)
            {
                var reqdetail = new tblRequestdetail()
                {
                    CompanyCode     = cc,
                    CityCode        = cci,
                    DepartmentId    = di,
                    Position        = pos,
                    EmployeeId      = Convert.ToInt32(empid),
                    EmployeeName    = ename,
                    ReasonofRequest = view.ReasonofRequests,
                    LastWorkingDate = view.LastWorkingDate,
                };
                db.tblRequestdetails.Add(reqdetail);
                db.SaveChanges();

                if (reqdetail != null)
                {
                    var request = new tblRequest()
                    {
                        RequestId     = reqdetail.RequestId,
                        EmployeeId    = Convert.ToInt32(empid),
                        RequestType   = "Resignation",
                        DateofRequest = DateTime.Now,
                        Status        = "Pending",
                    };
                    db.tblRequests.Add(request);
                    db.SaveChanges();
                    if (request != null)
                    {
                        TempData["SuccessMessage"] = "Resignation Submitted";
                        return(RedirectToAction("SubmittedRequests", "Requests"));
                    }
                }
            }
            else
            {
                TempData["ErrorMessage1"] = "You already Submitted Resignation";
            }


            return(View());
        }
コード例 #8
0
        // GET: Requests/Delete/5
        public ActionResult Delete(int?id)
        {
            if (id == null)
            {
                return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
            }
            tblRequest tblRequest = db.tblRequests.Find(id);

            if (tblRequest == null)
            {
                return(HttpNotFound());
            }
            return(View(tblRequest));
        }
コード例 #9
0
        private void SendRequestExecute()
        {
            try
            {
                int     idReceiving = User.UserID;
                tblUser userSending = (from r in context.tblUsers where r.Username == Username select r).FirstOrDefault();

                if (tool.AreTheyFriends(idReceiving, userSending.UserID) == true)
                {
                    MessageBox.Show("You are already friends");
                }
                else
                {
                    MessageBoxButton btnMessageBox = MessageBoxButton.YesNo;
                    MessageBoxImage  icnMessageBox = MessageBoxImage.Question;

                    MessageBoxResult resultMessageBox = MessageBox.Show("Are you sure you want to send friend request?", "Request approval", btnMessageBox, icnMessageBox);

                    if (resultMessageBox == MessageBoxResult.Yes)
                    {
                        if (tool.AreTheyFriends(userSending.UserID, idReceiving) == false && tool.StatusPending(userSending.UserID, idReceiving) == false)
                        {
                            tblRequest newRequest = new tblRequest();
                            newRequest.UserID_Receiving = idReceiving;
                            newRequest.UserID_Sending   = userSending.UserID;
                            newRequest.Approved         = false;
                            context.tblRequests.Add(newRequest);
                            context.SaveChanges();
                            MessageBox.Show("Friend request is sent.");
                        }
                        else if (tool.StatusPending(userSending.UserID, idReceiving) == true)
                        {
                            MessageBox.Show("Request is already sent.");
                        }
                        else
                        {
                            MessageBox.Show("You are already friend with this user.");
                        }
                    }
                }
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.ToString());
            }
        }
コード例 #10
0
        public tblRequest Addreqtfordgm(int Employeeid, int posid, string citytrans, string ReasonofReq)
        {
            var addreq = new tblRequest()
            {
                EmployeeId      = Employeeid,
                PositionId      = posid,
                CitytoTranser   = citytrans,
                RequestType     = "Transfer",
                DateofRequest   = DateTime.Now,
                Status          = "Pending",
                ReasonofRequest = ReasonofReq,
                AuthorizedRole  = "CEO",
                IsSeen          = false,
            };

            return(addreq);
        }
コード例 #11
0
        public int Save(PgNotification entity)
        {
            tblRequest toSave = new tblRequest();
            toSave.Amount = entity.Amount;
            toSave.ApplicationId = entity.ApplicationId;
            toSave.DateCreated = DateTime.Now;
            toSave.Payee = entity.Payee;
            toSave.ReferenceId = entity.ReferenceNumber.ToString();
            if (entity is SmscNotification)
            {
                SmscNotification smcs = entity as SmscNotification;
                toSave.Smsc_PhoneNumber = smcs.OutletPhoneNumber;
                toSave.Smsc_TillNumber = smcs.TillNumber;
                toSave.MessageType = (int)entity.MessageType;

            } if (entity is SmscPaymentConfirmation)
            {
                SmscPaymentConfirmation smcs = entity as SmscPaymentConfirmation;
                toSave.Smsc_PhoneNumber = smcs.OutletPhoneNumber;
                toSave.Smsc_TillNumber = smcs.TillNumber;
                toSave.MessageType = (int)entity.MessageType;

            }
            if (entity is Eazy247Notification)
            {
                Eazy247Notification smcs = entity as Eazy247Notification;
                toSave.Smsc_PhoneNumber = smcs.OutletPhoneNumber;
                toSave.Smsc_TillNumber = smcs.BillerNumber;
                toSave.MessageType = (int)entity.MessageType;

            }
            if (entity is Easy247Payment)
            {
                Easy247Payment smcs = entity as Easy247Payment;
                toSave.Smsc_PhoneNumber = smcs.OutletPhoneNumber;
                toSave.Smsc_TillNumber = smcs.BillerNumber;
                toSave.MessageType = (int)entity.MessageType;

            }
            _ctx.tblRequest.Add(toSave);
            _ctx.SaveChanges();
            return toSave.Id;
        }
コード例 #12
0
        public tblRequest AddReqlforhr(int empid, int posid, DateTime FromDate, DateTime ToDate, string ReasonofReq, string leavetype)
        {
            var addreq = new tblRequest()
            {
                EmployeeId      = empid,
                PositionId      = posid,
                RequestType     = "Leave",
                DateofRequest   = DateTime.Now,
                FromDate        = FromDate,
                ToDate          = ToDate,
                Status          = "Pending",
                ReasonofRequest = ReasonofReq,
                LeaveType       = leavetype,
                AuthorizedRole  = "CEO",
                IsSeen          = false,
            };

            return(addreq);
        }
コード例 #13
0
        protected void lnkviewdetails_Click(object sender, EventArgs e)
        {
            LinkButton lnkviewdetails = (LinkButton)sender;

            jrcode = lnkviewdetails.CommandArgument.ToString().Trim();

            var verifyRequest = dbContext.tblRequests.Where(x => x.JR_Code == jrcode);

            foreach (var item in verifyRequest)
            {
                tblRequest tblData = item as tblRequest;

                //ForChecking
                if ((Convert.ToBoolean(tblData.IsRejected) == false && Convert.ToBoolean(tblData.IsCancelled) == false) &&
                    Convert.ToBoolean(tblData.Is_Submitted) == true &&
                    Convert.ToBoolean(tblData.Is_Checked) == false &&
                    Convert.ToBoolean(tblData.Is_Assessed) == false &&
                    Convert.ToBoolean(tblData.Is_Noted) == false &&
                    Convert.ToBoolean(tblData.Is_Approved) == false &&
                    Convert.ToBoolean(tblData.Is_JobAccepted) == false &&
                    Convert.ToBoolean(tblData.IsCompleted) == false
                    )
                {
                    Response.Redirect("UserForChecking.aspx?RCode=" + jrcode);
                }
                //ForAssessment
                else
                if (Convert.ToBoolean(tblData.Is_Submitted) == true &&
                    Convert.ToBoolean(tblData.Is_Checked) == true &&
                    Convert.ToBoolean(tblData.Is_Assessed) == false &&
                    Convert.ToBoolean(tblData.Is_Noted) == false &&
                    Convert.ToBoolean(tblData.Is_Approved) == false &&
                    Convert.ToBoolean(tblData.Is_JobAccepted) == false &&
                    Convert.ToBoolean(tblData.IsCompleted) == false &&
                    (Convert.ToBoolean(tblData.IsRejected) == false && Convert.ToBoolean(tblData.IsCancelled) == false))
                {
                    Response.Redirect("UserForAssessment.aspx?RCode=" + jrcode);
                }
                //ForNoting
                else if (Convert.ToBoolean(tblData.Is_Submitted) == true &&
                         Convert.ToBoolean(tblData.Is_Checked) == true &&
                         Convert.ToBoolean(tblData.Is_Assessed) == true &&
                         Convert.ToBoolean(tblData.Is_Noted) == false &&
                         Convert.ToBoolean(tblData.Is_Approved) == false &&
                         Convert.ToBoolean(tblData.Is_JobAccepted) == false &&
                         Convert.ToBoolean(tblData.IsCompleted) == false &&
                         (Convert.ToBoolean(tblData.IsRejected) == false && Convert.ToBoolean(tblData.IsCancelled) == false))
                {
                    Response.Redirect("UserForNoting.aspx?RCode=" + jrcode);
                }
                //ForApproval
                else if (Convert.ToBoolean(tblData.Is_Submitted) == true &&
                         Convert.ToBoolean(tblData.Is_Checked) == true &&
                         Convert.ToBoolean(tblData.Is_Assessed) == true &&
                         Convert.ToBoolean(tblData.Is_Noted) == true &&
                         Convert.ToBoolean(tblData.Is_Approved) == false &&
                         Convert.ToBoolean(tblData.Is_JobAccepted) == false &&
                         Convert.ToBoolean(tblData.IsCompleted) == false &&
                         (Convert.ToBoolean(tblData.IsRejected) == false && Convert.ToBoolean(tblData.IsCancelled) == false))
                {
                    Response.Redirect("UserForApproval.aspx?RCode=" + jrcode);
                }
                //ViewDetailsWithJONo
                else if (Convert.ToBoolean(tblData.Is_Submitted) == true &&
                         Convert.ToBoolean(tblData.Is_Checked) == true &&
                         Convert.ToBoolean(tblData.Is_Assessed) == true &&
                         Convert.ToBoolean(tblData.Is_Noted) == true &&
                         Convert.ToBoolean(tblData.Is_Approved) == true &&
                         (Convert.ToBoolean(tblData.Is_JobAccepted) == false || (Convert.ToBoolean(tblData.Is_JobAccepted) == true) &&
                          Convert.ToBoolean(tblData.IsCompleted) == false &&
                          (Convert.ToBoolean(tblData.IsRejected) == false && Convert.ToBoolean(tblData.IsCancelled) == false)))

                {
                    Response.Redirect("UserJOGenerated.aspx?RCode=" + jrcode);
                }
                //ViewDenied
                else if ((Convert.ToBoolean(tblData.IsRejected) == true || Convert.ToBoolean(tblData.IsCancelled) == true))
                {
                    Response.Redirect("UserDeniedAndCancelled.aspx?RCode=" + jrcode);
                }
                //ViewCompleted
                else if (Convert.ToBoolean(tblData.Is_Submitted) == true &&
                         Convert.ToBoolean(tblData.Is_Checked) == true &&
                         Convert.ToBoolean(tblData.Is_Assessed) == true &&
                         Convert.ToBoolean(tblData.Is_Noted) == true &&
                         Convert.ToBoolean(tblData.Is_Approved) == true &&
                         Convert.ToBoolean(tblData.Is_JobAccepted) == true &&
                         Convert.ToBoolean(tblData.IsCompleted) == true &&
                         (Convert.ToBoolean(tblData.IsRejected) == false && Convert.ToBoolean(tblData.IsCancelled) == false))
                {
                    Response.Redirect("UserCompleted.aspx?RCode=" + jrcode);
                }
                else
                {
                }
            }
        }
コード例 #14
0
        private void SaveRequest()
        {
            double s1, s2, s3, s4, s5, s6;

            if (rdoInCharge.SelectedValue == "04" || rdoInCharge.SelectedValue == "05" || rdoInCharge.SelectedValue == "08")
            {
                if (double.TryParse(tbQuantity_Jigs.Text, out var outParse))
                {
                    s1 = Convert.ToDouble(tbQuantity_Jigs.Text.Trim());
                }
                else
                {
                    s1 = 0;
                }

                if (double.TryParse(qtyhrtxt.Text, out var outParse2))
                {
                    s2 = Convert.ToDouble(qtyhrtxt.Text.Trim());
                }
                else
                {
                    s2 = 0;
                }

                if (double.TryParse(mreqtxt.Text, out var outParse3))
                {
                    s3 = Convert.ToDouble(mreqtxt.Text.Trim());
                }
                else
                {
                    s3 = 0;
                }

                if (double.TryParse(mcaptxt.Text, out var outParse4))
                {
                    s4 = Convert.ToDouble(mcaptxt.Text.Trim());
                }
                else
                {
                    s4 = 0;
                }

                if (double.TryParse(tbNextForecast.Text, out var outPars5))
                {
                    s5 = Convert.ToDouble(tbNextForecast.Text.Trim());
                }
                else
                {
                    s5 = 0;
                }

                tblRequest tbl = new tblRequest()
                {
                    EmpID                   = Session["EmpID"].ToString().Trim(),
                    DeptCode                = Session["DeptCode"].ToString().Trim(),
                    SectCode                = Session["SectCode"].ToString().Trim(),
                    Request_Date            = DateTime.Now.Date,
                    Incharge_ID             = rdoInCharge.SelectedValue.ToString().Trim(),
                    Customer                = cboCustomer.SelectedValue.ToString().Trim(),
                    Partcode                = tbPartCode.Text.Trim(),
                    Partname                = tbPartName.Text.Trim(),
                    JigType                 = cboTypeOfJig.SelectedValue.ToString().Trim(),
                    Quantity                = s1,
                    QtyProdPerHr            = s2,
                    Monthly_Req             = s3,
                    Machine_Capacity        = s4,
                    NextForeCast            = s5,
                    Problem_Desc            = tbjustification.Text.Trim().Replace("\r\n", "<br/>").Replace(" ", "&nbsp;").Replace("\t", "&nbsp;&nbsp;&nbsp;&nbsp;").Replace("'", "^"),
                    Is_Submitted            = true,
                    IsHold                  = false,
                    Is_Checked              = false,
                    Is_Reviewed             = false,
                    Is_Assessed             = false,
                    Is_JobAccepted          = false,
                    Is_Approved             = false,
                    Is_Noted                = false,
                    Is_AttachmentApproved   = false,
                    IsCompleted             = false,
                    JR_Code                 = Session["RCode"].ToString().Trim(),
                    IsCancelled             = false,
                    IsRejected              = false,
                    Req_Remarks             = "SIGNED",
                    Checker                 = appr_name.Trim(),
                    AssessedBy              = "N/A",
                    Noter                   = "N/A",
                    Manager                 = "N/A",
                    FinalAcceptanceBy       = "N/A",
                    IsSentToApprover_First  = false,
                    IsSentToApprover_Second = false,
                    IsSentToApprover_Third  = false,
                    CreationDateTime        = DateTime.Now
                };

                dbContext.tblRequests.Add(tbl);

                dbContext.SaveChanges();
            }
            else
            {
                if (double.TryParse(tbItemQuantity.Text, out var outParse))
                {
                    s6 = Convert.ToDouble(tbItemQuantity.Text.Trim());
                }
                else
                {
                    s6 = 0;
                }

                tblRequest tbl = new tblRequest()
                {
                    EmpID                   = Session["EmpID"].ToString().Trim(),
                    DeptCode                = Session["DeptCode"].ToString().Trim(),
                    SectCode                = Session["SectCode"].ToString().Trim(),
                    Request_Date            = DateTime.Now.Date,
                    Incharge_ID             = rdoInCharge.SelectedValue.ToString().Trim(),
                    Partname                = tbItemName.Text.Trim(),
                    Quantity                = s6,
                    Problem_Desc            = tbjustification.Text.Trim().Replace(" ", "&nbsp;").Replace("\t", "&nbsp;&nbsp;&nbsp;&nbsp;").Replace("'", "^").Replace("\r\n", "<br/>"),
                    Is_Submitted            = true,
                    IsHold                  = false,
                    Is_Checked              = false,
                    Is_Reviewed             = false,
                    Is_Assessed             = false,
                    Is_JobAccepted          = false,
                    Is_Approved             = false,
                    Is_AttachmentApproved   = false,
                    Is_Noted                = false,
                    IsCompleted             = false,
                    JR_Code                 = Session["RCode"].ToString().Trim(),
                    IsCancelled             = false,
                    IsRejected              = false,
                    Req_Remarks             = "SIGNED",
                    Checker                 = appr_name.Trim(),
                    AssessedBy              = "N/A",
                    Noter                   = "N/A",
                    Manager                 = "N/A",
                    FinalAcceptanceBy       = "N/A",
                    IsSentToApprover_First  = false,
                    IsSentToApprover_Second = false,
                    IsSentToApprover_Third  = false,
                    CreationDateTime        = DateTime.Now
                };

                dbContext.tblRequests.Add(tbl);

                dbContext.SaveChanges();
            }

            foreach (ButtonListItem item in rdoReqType.Items)
            {
                if (item.Selected)
                {
                    tblRequestType_Selected tbl = new tblRequestType_Selected()
                    {
                        JR_Code         = Session["RCode"].ToString(),
                        RequestTypeCode = item.Value.ToString()
                    };

                    dbContext.tblRequestType_Selected.Add(tbl);
                }
            }

            dbContext.SaveChanges();

            UpdateAttachmentStatus();
        }
コード例 #15
0
        // state that the method you intend to create is a POST
        public HttpResponseMessage ussd([FromBody] Models.ServerResponse ServerResponse)
        {
            // declare a complex type as input parameter
            HttpResponseMessage rs;
            string response;
            string eventType = string.Empty;

            if (ServerResponse.text == null)
            {
                ServerResponse.text = "";
            }

            // loop through the server's text value to determine the next cause of action
            if (ServerResponse.text.Equals("", StringComparison.Ordinal))
            {
                NewsManagementDBEntities entity = new NewsManagementDBEntities();
                tblRequest tableRequest         = new USSD_Application.tblRequest();
                tableRequest.PhoneNumber          = ServerResponse.phoneNumber;
                tableRequest.ServiceCode          = ServerResponse.serviceCode;
                tableRequest.SessionID            = ServerResponse.sessionId;
                tableRequest.RequestStartDateTime = DateTime.Now;

                entity.tblRequests.Add(tableRequest);
                entity.SaveChanges();

                response  = "CON Welcome to our service \n";
                response += " What type of NEWS you want today \n";
                response += " 1. Sport \n";
                response += " 2. Music \n";
                response += " 3. Movie \n";
            }
            else
            {
                string[] request = ServerResponse.text.Split('*');
                if (request.Count() == 1)
                {
                    response = "CON Please Enter Date to filter \n";
                }
                else if (request.Count() == 2)
                {
                    eventType = GetEventType(request[0]);
                    DateTime eventDate = DateTime.Parse(request[1]);

                    NewsManagementDBEntities entity = new NewsManagementDBEntities();
                    List <tblEvent>          events = entity.tblEvents.Where(x => x.EventType == eventType && x.CreatedDate == eventDate).ToList();

                    if (events != null && events.Count > 0)
                    {
                        string newsTitles = string.Empty;
                        response = "CON Please Enter the CODE on the left \n";

                        foreach (tblEvent singleEvent in events)
                        {
                            response += singleEvent.ID + ". " + singleEvent.Title + " \n";
                        }
                    }
                    else
                    {
                        response = "END Invalid Code selected";
                    }
                }
                else if (request.Count() == 3)
                {
                    eventType = GetEventType(request[0]);
                    DateTime eventDate = DateTime.Parse(request[1]);
                    int      eventID   = int.Parse(request[2]);

                    NewsManagementDBEntities entity = new NewsManagementDBEntities();
                    tblEvent singleEvent            = entity.tblEvents.Where(x => x.ID == eventID && x.EventType == eventType && x.CreatedDate == eventDate).FirstOrDefault();

                    if (singleEvent != null)
                    {
                        response = "END " + singleEvent.Description;

                        tblRequest oldRequest = entity.tblRequests.Where(x => x.SessionID == ServerResponse.sessionId).FirstOrDefault();

                        tblRequest newRequest = new tblRequest();
                        newRequest.PhoneNumber             = ServerResponse.phoneNumber;
                        newRequest.ServiceCode             = ServerResponse.serviceCode;
                        newRequest.SessionID               = ServerResponse.sessionId;
                        newRequest.RequestStartDateTime    = oldRequest.RequestStartDateTime;
                        newRequest.RequestCompleteDateTime = DateTime.Now;

                        entity.Entry(oldRequest).CurrentValues.SetValues(newRequest);
                        entity.SaveChanges();
                    }
                    else
                    {
                        response = "END Invalid Code selected";
                    }
                }
                else
                {
                    response = "END Invalid Option";
                }
            }

            rs = Request.CreateResponse(HttpStatusCode.Created, response);

            rs.Content = new StringContent(response, Encoding.UTF8, "text/plain");
            return(rs);
        }
コード例 #16
0
 public void AddLeaveReq(tblRequest obj)
 {
     context.tblRequests.Add(obj);
 }
コード例 #17
0
        protected void Page_Load(object sender, EventArgs e)
        {
            btnShowReject.Attributes["href"]    = "javascript:void(0);";
            btnShowReject.Attributes["onclick"] = String.Format("return ShowRejectForm('{0}','{1}','{2}');"
                                                                , Request.QueryString["EmpID"].ToString().Trim(), Request.QueryString["RCode"].ToString().Trim(), "Approver");

            btnShowHold.Attributes["href"]    = "javascript:void(0);";
            btnShowHold.Attributes["onclick"] = String.Format("return ShowHoldForm('{0}','{1}','{2}');"
                                                              , Request.QueryString["EmpID"].ToString().Trim(), Request.QueryString["RCode"].ToString().Trim(), "Approver");

            DeleteUnusedCodes();

            if (!IsPostBack)
            {
                rdoInCharge.DataSource = dbContext.tblIncharges.Where(x => x.Incharge_ID == "07" || x.Incharge_ID == "08").ToList();
                rdoInCharge.DataBind();

                rdoReqType.DataSource = dbContext.tblRequestTypes.ToList();
                rdoReqType.DataBind();
            }

            approverempid2 = Request.QueryString["EmpID"].ToString().Trim();

            var getchecker = dbContext.tblUsers.Where(x => x.EmpID == approverempid2);

            foreach (var item in getchecker)
            {
                tblUser tblData = item as tblUser;

                approverempid = tblData.EmpID;

                approveremail = tblData.EmailAdd;
            }

            var dbuser = dbHRISContext.SKPI_GetAllEmployeesByEmpID(approverempid).ToList();

            foreach (DataRow row in ConvertToDataTable(dbuser).Rows)
            {
                approverposition = row["Pos_Desc"].ToString();

                Session["Position"] = row["Pos_Desc"].ToString();

                approverdeptcode = row["Dept_Code"].ToString();

                approverdeptname = row["Dept_Desc"].ToString();

                approversectcode = row["Sect_Code"].ToString();

                approversectname = row["Sect_Desc"].ToString();

                Session["FName"] = row["FirstName"].ToString();

                approverfullname_lnamefirst = row["FullName_LnameFirst"].ToString();

                approverfullname_fnamefirst = row["FullName_FnameFirst"].ToString();

                Session["FullName_LnameFirst"] = row["FullName_LnameFirst"].ToString();

                Session["FullName_FnameFirst"] = row["FullName_FnameFirst"].ToString();
            }

            Session["RCode"] = Request.QueryString["RCode"].ToString();

            jrcode = Session["RCode"].ToString();

            SQLDSGetAttachment.ConnectionString = ClsConfig.JobRequestConnectionString;

            //SQLDSGetAttachment2.ConnectionString = ClsConfig.JobRequestConnectionString;

            var verifyRequest = dbContext.tblRequests.Where(x => x.JR_Code == jrcode);

            foreach (var item in verifyRequest)
            {
                tblRequest tblData = item as tblRequest;

                if ((Convert.ToBoolean(tblData.Is_Submitted) == true &&
                     Convert.ToBoolean(tblData.Is_Checked) == true &&
                     Convert.ToBoolean(tblData.Is_Assessed) == true &&
                     Convert.ToBoolean(tblData.Is_Noted) == true &&
                     Convert.ToBoolean(tblData.Is_Approved) == true &&
                     Convert.ToBoolean(tblData.Is_JobAccepted) == false &&
                     Convert.ToBoolean(tblData.IsCompleted) == false &&
                     (Convert.ToBoolean(tblData.IsRejected) == false || Convert.ToBoolean(tblData.IsCancelled) == false)
                     ) || (Convert.ToBoolean(tblData.Is_JobAccepted) == true ||
                           Convert.ToBoolean(tblData.IsCompleted) == true))
                {
                    divSuccess.Visible     = true;
                    divApplication.Visible = false;
                    divRejected.Visible    = false;
                    divCancelled.Visible   = false;
                }
                else if (Convert.ToBoolean(tblData.IsRejected) == true)
                {
                    divSuccess.Visible     = false;
                    divApplication.Visible = false;
                    divRejected.Visible    = true;
                    divCancelled.Visible   = false;
                }
                else if (Convert.ToBoolean(tblData.IsCancelled) == true)
                {
                    divSuccess.Visible     = false;
                    divApplication.Visible = false;
                    divRejected.Visible    = false;
                    divCancelled.Visible   = true;
                }
                else
                {
                    divSuccess.Visible     = false;
                    divApplication.Visible = true;
                    divRejected.Visible    = false;
                    divCancelled.Visible   = false;

                    GetRequestDetails();
                }
            }
        }
コード例 #18
0
        //internal int SaveTutorSubjects(TutorSubjects objReq)
        //{

        //    tblTutorSubject objSubjectData = new tblTutorSubject();
        //    using (var db = new WizzDataContext())
        //    {
        //        objSubjectData = db.tblTutorSubjects.Where(x => x.fkTutorId == Convert.ToInt64(objReq.tutorId)).FirstOrDefault();
        //        if (objSubjectData == null)
        //        {
        //            //objSubjectData = new TutorSubjects();
        //            //objSubjectData.isApproved = true;
        //            //objSubjectData.isActive = true;
        //            //objSubjectData.fkUserId = Convert.ToInt64(objReq.userId);
        //            //objSubjectData.latitude = Convert.ToDecimal(objReq.latitude);
        //            //objSubjectData.longitude = Convert.ToDecimal(objReq.longitude);
        //            //objSubjectData.subjects = objReq.majors;
        //            //objSubjectData.TimeStamp = Convert.ToDateTime(objReq.timeStamp).Ticks;
        //            //objSubjectData.updatedDate = DateTime.UtcNow;
        //            //objSubjectData.createdDate = DateTime.UtcNow;
        //            //objSubjectData.passingYear = objReq.passingYear;
        //            //objSubjectData.referralcode = objReq.referalCode == null ? "" : objReq.referalCode;
        //            ////    profileData.fkClassId = String.Join(",", objReq.classes);
        //            //objSubjectData.fkCollegeId = Convert.ToInt32(objReq.collegeId);
        //            //db.tblTutorProfiles.InsertOnSubmit(objSubjectData);

        //        }
        //        else
        //        {
        //            //objSubjectData.isApproved = true;
        //            //objSubjectData.isActive = true;
        //            //objSubjectData.fkUserId = Convert.ToInt64(objReq.userId);
        //            //objSubjectData.latitude = Convert.ToDecimal(objReq.latitude);
        //            //objSubjectData.longitude = Convert.ToDecimal(objReq.longitude);
        //            //objSubjectData.subjects = objReq.majors;
        //            //objSubjectData.TimeStamp = Convert.ToDateTime(objReq.timeStamp).Ticks;
        //            //objSubjectData.updatedDate = DateTime.UtcNow;
        //            //objSubjectData.createdDate = DateTime.UtcNow;
        //            ////  profileData.fkClassId = String.Join(",", objReq.classes);
        //            //objSubjectData.fkCollegeId = Convert.ToInt32(objReq.collegeId);
        //        }
        //        db.SubmitChanges();
        //        return 1;
        //    }

        //}


        //save matched tutos in db and send notifications 
        void SendRequest(StudentRequestModel objReq,List<usp_GetTutorsResult> tutors,string requestId)
        {
            var studentId =Convert.ToInt64(objReq.userId);
            using(var db=new WizzDataContext())
            {
                foreach (var tutor in tutors.ToList())
                {
                    var request = new tblRequest();
                    request.createdDate = DateTime.UtcNow;
                    request.updatedDate = DateTime.UtcNow;
                    request.isAccepted = false;
                    request.isDeleted = false;
                    request.fkStudentId = studentId;
                    request.fkTutorId = tutor.fkUserId;
                    request.uniqueRequestId = requestId;
                    request.timeStamp = DateTime.UtcNow.Ticks;
                    db.tblRequests.InsertOnSubmit(request);
                    db.SubmitChanges();
                    //sendpush

                    if(!string.IsNullOrEmpty(tutor.deviceToken))
                    {
                        PushData push=new PushData()
                        {
                        
                        registration_ids = tutor.deviceToken,
                        message = PushMessages.newRequest,
                        type = Convert.ToInt16(PushType.newRequest).ToString(),
                        badge = Convert.ToString(tutor.badge)
                    };
                       // push.data = CommonMethod.ObjectToJson(objPush);

                        if (tutor.deviceType == Convert.ToInt16(DeviceType.ios))//ios
                        { 
                            SendPush objIOS=new SendPush();
                            objIOS.ConnectToAPNS(push);
                        }
                        else if (tutor.deviceType == Convert.ToInt16(DeviceType.android))//android
                        {
                            Android objAndroid = new Android();
                            objAndroid.send(push);
                            
                        }
                    }
                }
            }
        }
コード例 #19
0
        protected void Page_Load(object sender, EventArgs e)
        {
            if (!IsPostBack)
            {
                rdoInCharge.DataSource = dbContext.tblIncharges.Where(x => x.Incharge_ID == "07" || x.Incharge_ID == "08").ToList();
                rdoInCharge.DataBind();

                rdoReqType.DataSource = dbContext.tblRequestTypes.ToList();
                rdoReqType.DataBind();

                ddlAssessment.DataSource = dbContext.tblAssessments.OrderBy(x => x.ID).ToList();
                ddlAssessment.DataBind();
            }

            approverempid2 = Request.QueryString["EmpID"].ToString().Trim();

            var getchecker = dbContext.tblUsers.Where(x => x.EmpID == approverempid2);

            foreach (var item in getchecker)
            {
                tblUser tblData = item as tblUser;

                approverempid = tblData.EmpID;

                approveremail = tblData.EmailAdd;
            }

            var dbuser = dbHRISContext.SKPI_GetAllEmployeesByEmpID(approverempid).ToList();

            foreach (DataRow row in ConvertToDataTable(dbuser).Rows)
            {
                approverposition = row["Pos_Desc"].ToString();

                Session["Position"] = row["Pos_Desc"].ToString();

                approverdeptcode = row["Dept_Code"].ToString();

                approverdeptname = row["Dept_Desc"].ToString();

                approversectcode = row["Sect_Code"].ToString();

                approversectname = row["Sect_Desc"].ToString();

                Session["FName"] = row["FirstName"].ToString();

                approverfullname_lnamefirst = row["FullName_LnameFirst"].ToString();

                approverfullname_fnamefirst = row["FullName_FnameFirst"].ToString();

                Session["FullName_LnameFirst"] = row["FullName_LnameFirst"].ToString();

                Session["FullName_FnameFirst"] = row["FullName_FnameFirst"].ToString();
            }

            jrcode = Request.QueryString["RCode"].ToString();//lnkviewdetails.CommandArgument.ToString().Trim();

            Session["RCode"] = jrcode;

            var verifyRequest = dbContext.tblRequests.Where(x => x.JR_Code == jrcode);

            foreach (var item in verifyRequest)
            {
                tblRequest tblData = item as tblRequest;

                if ((Convert.ToBoolean(tblData.Is_Submitted) == true &&
                     Convert.ToBoolean(tblData.Is_Checked) == true &&
                     Convert.ToBoolean(tblData.Is_Assessed) == true &&
                     Convert.ToBoolean(tblData.Is_Noted) == true &&
                     Convert.ToBoolean(tblData.Is_Approved) == true &&
                     Convert.ToBoolean(tblData.Is_JobAccepted) == false &&
                     Convert.ToBoolean(tblData.IsCompleted) == false &&
                     (Convert.ToBoolean(tblData.IsRejected) == false || Convert.ToBoolean(tblData.IsCancelled) == false)
                     ) || (Convert.ToBoolean(tblData.Is_JobAccepted) == true ||
                           Convert.ToBoolean(tblData.IsCompleted) == true))
                {
                    divSuccess.Visible     = true;
                    divApplication.Visible = false;
                    divRejected.Visible    = false;
                    divCancelled.Visible   = false;
                    divApplication.Visible = false;
                }
                else if (Convert.ToBoolean(tblData.IsRejected) == true)
                {
                    divSuccess.Visible     = false;
                    divApplication.Visible = false;
                    divRejected.Visible    = true;
                    divCancelled.Visible   = false;
                    divApplication.Visible = false;
                }
                else if (Convert.ToBoolean(tblData.IsCancelled) == true)
                {
                    divSuccess.Visible     = false;
                    divApplication.Visible = false;
                    divRejected.Visible    = false;
                    divCancelled.Visible   = true;
                    divApplication.Visible = false;
                }
                else
                {
                    if (!IsPostBack)
                    {
                        GetRequestDetails();
                    }

                    string id = Request.QueryString["EmpID"].ToString().Trim();

                    //int dbCount = dbContext.tblInchargePersons.Where(x => x.EmpID == id && x.IsAssesstor == true && x.Incharge_ID == incharge).Count();

                    int dbCount = 0;

                    if (incharge == "01" || incharge == "02" || incharge == "03")
                    {
                        //rdoInCharge.SelectedValue = "07";
                        dbCount = dbContext.tblInchargePersons.Where(x => x.EmpID == id && x.IsAssesstor == true && x.Incharge_ID == "07").Count();
                    }
                    else if (incharge == "04" || incharge == "05" || incharge == "06")
                    {
                        //rdoInCharge.SelectedValue = "08";
                        dbCount = dbContext.tblInchargePersons.Where(x => x.EmpID == id && x.IsAssesstor == true && x.Incharge_ID == "08").Count();
                    }
                    else
                    {
                        //rdoInCharge.SelectedValue = incharge;
                        dbCount = dbContext.tblInchargePersons.Where(x => x.EmpID == id && x.IsAssesstor == true && x.Incharge_ID == incharge).Count();
                    }

                    if (dbCount >= 1)
                    {
                        divApplication.Visible = true;
                        divAssess.Visible      = false;

                        divSuccess.Visible   = false;
                        divRejected.Visible  = false;
                        divCancelled.Visible = false;
                    }
                    else
                    {
                        divApplication.Visible = false;

                        divAssess.Visible = true;


                        divSuccess.Visible   = false;
                        divRejected.Visible  = false;
                        divCancelled.Visible = false;
                    }
                }
            }
        }
コード例 #20
0
        protected void ChangeIncharge(object sender, EventArgs e)
        {
            string link = string.Empty, body = string.Empty;

            dbContext = new JobRequestDBEntities();

            var a = dbContext.tblRequests.Where(x => x.JR_Code == jrcode).FirstOrDefault();

            if (a != null)
            {
                tblRequest tbldata = a as tblRequest;

                tbldata.Incharge_ID = incharge;

                dbContext.Entry(tbldata).State = EntityState.Modified;

                dbContext.SaveChanges();
            }

            link = Environment.NewLine + "http://" + HttpContext.Current.Request.Url.Authority + "/DirectAssessment.aspx";

            var asstr = (from data in dbContext.tblUsers
                         join inchargePerson in dbContext.tblInchargePersons on data.EmpID equals inchargePerson.EmpID
                         into UP
                         from inchargePerson in UP.DefaultIfEmpty()
                         where inchargePerson.Incharge_ID == rdoInCharge.SelectedValue && inchargePerson.IsAssesstor == true
                         select new
            {
                EmpID = data.EmpID,
                EmailAdd = data.EmailAdd,
                InchargeCode = inchargePerson.Incharge_ID,
                IsAssesstor = inchargePerson.IsAssesstor,
                IsNoter = inchargePerson.IsNoter
            }
                         ).ToList();

            foreach (DataRow dr in ConvertToDataTable(asstr).Rows)
            {
                Boolean ress;

                ress = SaveEmailLogs(link + "?EmpID=" + dr["EmpID"].ToString().Trim() + "&RCode=" + jrcode
                                     , "Assesstor", dr["EmailAdd"].ToString().Trim(), approverfullname_fnamefirst.ToString().Trim()
                                     , dr["EmpID"].ToString().Trim(), Session["RCode"].ToString().Trim());

                body = "Dear Sir/Ma'am," + "<br /><br />" + "Good Day!";

                body += "<br /><br />" + "I Have Prepared A Job Order Request For Your Assessment.";

                body += "<br /><br />" + "You may click the link below to redirect to main page. ";

                body += "<br /><br />" + link + "?EmpID=" + dr["EmpID"].ToString().Trim() + "&RCode=" + jrcode;

                body += "<br /><br />" + "Thank You.";

                body += "<br /><br />" + "Note: This is a system generated email. Please do not reply. Thank you";


                var rx = new Regex(@"(?<=\w)\w");

                var newString2 = rx.Replace(Session["FullName_FnameFirst"].ToString(), new MatchEvaluator(m => m.Value.ToLowerInvariant()));

                using (MailMessage mm = new MailMessage())
                {
                    string sub = "Online Job Order Request: Requesting For Approval";

                    mm.Subject = sub.ToUpper();

                    mm.Body = body;

                    var newString = rx.Replace(Session["FullName_FnameFirst"].ToString(), new MatchEvaluator(m => m.Value.ToLowerInvariant()));

                    mm.From = new MailAddress(ConfigurationManager.AppSettings["MailSenderEmailAddress"].ToString(),

                                              ConfigurationManager.AppSettings["MailSenderName"].ToString());

                    mm.To.Add(dr["EmailAdd"].ToString().Trim());

                    SmtpClient smtp = new SmtpClient();

                    smtp.Host = ConfigurationManager.AppSettings["MailServer"].ToString();

                    smtp.EnableSsl = true;

                    mm.IsBodyHtml = true;

                    NetworkCredential NetworkCred = new NetworkCredential(ConfigurationManager.AppSettings["MailSenderEmailAddress"].ToString(),
                                                                          ConfigurationManager.AppSettings["MailSenderEmailPassword"].ToString());

                    smtp.Credentials = NetworkCred;

                    smtp.Port = Convert.ToInt32(ConfigurationManager.AppSettings["SMTPPort"]);

                    ServicePointManager.ServerCertificateValidationCallback = delegate(object s, X509Certificate certificate,
                                                                                       X509Chain chain, SslPolicyErrors sslPolicyErrors)
                    { return(true); };
                    smtp.Send(mm);
                }
            }

            dbContext.SaveChanges();

            SendToRequestor_Transferred();

            Show("Record Successfully Transferred");

            divRecords.Visible = true;

            gridRecords.Rebind();
        }