Exemple #1
0
        public DataTable getExpiredWHRsonTruck(Guid warehouseid)
        {
            DataTable           dt     = new DataTable();
            WarehouseRecieptBLL whrbll = new WarehouseRecieptBLL();

            dt = whrbll.getexpiredWHRsOnTruck(warehouseid);
            return(dt);
        }
Exemple #2
0
        public void BindApprovalGrid(Guid warehouseid)
        {
            DataTable           dt     = new DataTable();
            WarehouseRecieptBLL whrbll = new WarehouseRecieptBLL();

            dt = whrbll.getexpiredWHRsOnTruck(warehouseid);
            grvGRNApproval.DataSource = dt;
            grvGRNApproval.DataBind();
        }
Exemple #3
0
        public void UpdateReceipt()
        {
            string GRNNo    = txtGRNNo.Text;
            Guid   LICName2 = new Guid(ddLIC.SelectedValue.ToString());
            //Guid Shed = new Guid();
            string Shed               = DDLShed.SelectedItem.ToString();
            GRN_BL objGrnNew          = new GRN_BL();
            GRNBLL objGrnOld          = objGrnNew.GetWarehouseReciptByGRNNumber(GRNNo);
            WarehouseRecieptBLL objWR = new WarehouseRecieptBLL(objGrnOld);

            objWR.EditWHRtoWarehouse(GRNNo, Shed);
        }
Exemple #4
0
        protected void GRNApprovalEdit()
        {
            string dateEntered;
            string timeEntered;
            Guid   GRNNo;
            string GRN_No;
            int    response;

            Messages1.ClearMessage();
            int countError = 0;

            dateEntered = ((TextBox)grvGRNApproval.Rows[0].FindControl("txtDateTimeLICSigned")).Text;
            timeEntered = ((TextBox)grvGRNApproval.Rows[0].FindControl("txtTimeLICSigned")).Text;
            GRNNo       = new Guid(grvGRNApproval.DataKeys[0].Value.ToString());
            GRN_No      = ((Label)grvGRNApproval.Rows[0].FindControl("lblGRNNo")).Text;
            response    = int.Parse(((DropDownList)grvGRNApproval.Rows[0].FindControl("drpLICStatus")).SelectedValue);

            if (dateEntered == "" || timeEntered == "")
            {
                Messages1.SetMessage("Enter values to GRN No: <b>" + GRN_No + "</b><br/>", WarehouseApplication.Messages.MessageType.Warning);
                countError++;
            }

            if (countError == 0)
            {
                try
                {
                    GRNApprovalModel.UpdateGRNSupervisorApproval(GRNNo, UserBLL.CurrentUser.UserId, response, (DateTime.Parse(dateEntered + " " + timeEntered)), DateTime.Now);

                    // if Superevisor Accept it create WarehouseReciept....
                    if (response == 1)
                    {
                        GRN_BL objGrnNew          = new GRN_BL();
                        GRNBLL objGrnOld          = objGrnNew.GetWarehouseReciptByGRNNumber(GRN_No);
                        WarehouseRecieptBLL objWR = new WarehouseRecieptBLL(objGrnOld);
                        objWR.Save();
                    }

                    BindGRNApprovalGridviewForEdit();
                    Messages1.SetMessage("Updated successfully.", Messages.MessageType.Success);
                }
                catch (Exception ex)
                {
                    Messages1.SetMessage(ex.Message, Messages.MessageType.Error);
                }
            }
            else
            {
                btnApprove.Style["visibility"] = "visible";
            }
        }
Exemple #5
0
        protected void GRNApprovalBySupervisor()
        {
            string dateEntered;
            string timeEntered;
            string GRNNo;
            string GRN_No;
            int    response;

            Messages1.ClearMessage();
            int countError = 0;

            string GRNApprovalXML = "<GRNApproval>";

            foreach (GridViewRow gvr in this.grvGRNApproval.Rows)
            {
                if (((CheckBox)gvr.FindControl("chkSelect")).Checked == true)
                {
                    // check if date and time is not empty
                    dateEntered = ((TextBox)grvGRNApproval.Rows[gvr.RowIndex].FindControl("txtDateTimeLICSigned")).Text;
                    timeEntered = ((TextBox)grvGRNApproval.Rows[gvr.RowIndex].FindControl("txtTimeLICSigned")).Text;
                    GRNNo       = grvGRNApproval.DataKeys[gvr.RowIndex].Value.ToString();
                    GRN_No      = ((Label)grvGRNApproval.Rows[gvr.RowIndex].FindControl("lblGRNNo")).Text;
                    response    = int.Parse(((DropDownList)grvGRNApproval.Rows[0].FindControl("drpLICStatus")).SelectedValue);

                    // if Superevisor Accept it create WarehouseReciept....
                    if (response == 1)
                    {
                        GRN_BL objGrnNew          = new GRN_BL();
                        GRNBLL objGrnOld          = objGrnNew.GetWarehouseReciptByGRNNumber(GRN_No);
                        WarehouseRecieptBLL objWR = new WarehouseRecieptBLL(objGrnOld);
                        objWR.Save();
                    }

                    if (dateEntered == "" || timeEntered == "")
                    {
                        Messages1.SetMessage("Enter values to GRN No: <b>" + GRN_No + "</b><br/>", WarehouseApplication.Messages.MessageType.Warning);
                        countError++;
                    }
                    if (countError == 0)
                    {
                        GRNApprovalXML +=
                            "<GRNApprovalItem> <ID>" + GRNNo + "</ID>" +
                            "<WarehouseSupervisorApprovedBy>" + UserBLL.CurrentUser.UserId + "</WarehouseSupervisorApprovedBy>" +
                            "<WarehouseSupervisorApprovedDateTime>" + dateEntered + " " + timeEntered + "</WarehouseSupervisorApprovedDateTime>" +
                            "<WarehouseSupervisorApprovedTimeStamp>" + DateTime.Now + "</WarehouseSupervisorApprovedTimeStamp>" +
                            "<WarehouseSupervisorStatus>" + response + "</WarehouseSupervisorStatus>" +
                            "<Status>" + 3 + "</Status>" +
                            "<StackID>" + ((Label)grvGRNApproval.Rows[gvr.RowIndex].FindControl("lblStackID")).Text + "</StackID>" +
                            "</GRNApprovalItem>";
                    }
                }
            }
            if (countError == 0)
            {
                try
                {
                    GRNApprovalXML += "</GRNApproval>";
                    GRNApprovalModel.ApproveGRNBySupervisor(GRNApprovalXML);
                    BindGRNApprovalGridview();
                    Messages1.SetMessage("Approved successfully.", Messages.MessageType.Success);
                    BindLIC(status);
                }
                catch (Exception ex)
                {
                    Messages1.SetMessage(ex.Message, Messages.MessageType.Error);
                }
            }
            else
            {
                btnApprove.Style["visibility"] = "visible";
            }
        }
Exemple #6
0
        protected void grvGRNApproval_SelectedIndexChanged(object sender, EventArgs e)
        {
            Guid     ID, StackID;
            DateTime LICApprovedDate;
            string   dateEntered, timeEntered, GRN_No, message;
            int      response;

            ID              = new Guid(grvGRNApproval.SelectedDataKey.Value.ToString());
            StackID         = new Guid(((Label)grvGRNApproval.SelectedRow.FindControl("lblStackID")).Text);
            dateEntered     = ((TextBox)grvGRNApproval.SelectedRow.FindControl("txtDateTimeLICSigned")).Text;
            timeEntered     = ((TextBox)grvGRNApproval.SelectedRow.FindControl("txtTimeLICSigned")).Text;
            GRN_No          = ((Label)grvGRNApproval.SelectedRow.FindControl("lblGRNNo")).Text;
            response        = int.Parse(((DropDownList)grvGRNApproval.SelectedRow.FindControl("drpLICStatus")).SelectedValue);
            LICApprovedDate = DateTime.Parse(((Label)grvGRNApproval.SelectedRow.FindControl("lblGRNCreatedDate")).Text);

            if (isValidDateTime(dateEntered, timeEntered, LICApprovedDate))
            {
                try
                {
                    if (((bool)ViewState["edit"]))
                    {
                        GRNApprovalModel.UpdateGRNSupervisorApproval(ID, UserBLL.CurrentUser.UserId, response, DateTime.Parse(dateEntered + " " + timeEntered), DateTime.Now);
                        BindGRNApprovalGridviewForEdit();
                        message = "Updated successfully.";
                    }
                    else
                    {
                        if (response == 1) //if Superevisor Accept it create WarehouseReciept....
                        {
                            GRN_BL objGrnNew = new GRN_BL();
                            GRNBLL objGrnOld = objGrnNew.GetWarehouseReciptByGRNNumber(GRN_No);

                            // Create the TransactionScope to execute the commands
                            TransactionOptions option = new TransactionOptions();
                            option.IsolationLevel = System.Transactions.IsolationLevel.ReadCommitted;
                            option.Timeout        = new TimeSpan(0, 0, 60);

                            using (TransactionScope transaction = new TransactionScope(TransactionScopeOption.Required, option))
                            {
                                GRNApprovalModel.ApproveGRNBySupervisor(ID, StackID, UserBLL.CurrentUser.UserId, response, DateTime.Parse(dateEntered + " " + timeEntered), DateTime.Now);
                                BindGRNApprovalGridview();

                                //create WarehouseReciept
                                WarehouseRecieptBLL objWR = new WarehouseRecieptBLL(objGrnOld);
                                objWR.Save2();

                                // The Complete method commits the transaction
                                transaction.Complete();
                            }
                        }

                        else
                        {
                            GRNApprovalModel.ApproveGRNBySupervisor(ID, StackID, UserBLL.CurrentUser.UserId, response, DateTime.Parse(dateEntered + " " + timeEntered), DateTime.Now);
                            BindGRNApprovalGridview();
                        }

                        message = "Approved successfully";
                        Messages1.SetMessage(message, Messages.MessageType.Success);
                    }
                }

                catch (Exception ex)
                {
                    Messages1.SetMessage("Unable to save record. Please try again.", WarehouseApplication.Messages.MessageType.Error);
                }
            }
        }