//[HttpPost]
        //public ActionResult TablePRCC()
        //{
        //    int start = Convert.ToInt32(Request["start"]);
        //    int length = Convert.ToInt32(Request["length"]);
        //    string searchValue = Request["search[value]"];
        //    string sortColumnName =Request["columns["+Request["order[0][column]"] +"][name]"];
        //    string sortDirection = Request["order[0][dir]"];
        //    using (var con = new SqlConnection(_connectionString))
        //    {
        //        var result = con.Query<PRCCModel>("GetTableDataForAllPages",
        //           new { }, commandType: CommandType.StoredProcedure).ToList();

        //        //if (!string.IsNullOrEmpty(searchValue))
        //        //{
        //        //    result=result.Where(x=>x.)
        //        //}
        //        result= result.OrderBy(sortColumnName + " " +sortDirection).ToList<PRCCModel>();

        //        result=result.Skip(start).Take(length).ToList<PRCCModel>();

        //        return Json(new { data = result }, JsonRequestBehavior.AllowGet);
        //    }

        //}
        public ActionResult RPCAP()
        {
            /* ViewBag.ReceivedDevice = new SelectList(Enumerable.Empty<SelectListItem>());
             * ViewBag.RecvdBrand = new SelectList(Enumerable.Empty<SelectListItem>());
             * ViewBag.RecvdModel = new SelectList(Enumerable.Empty<SelectListItem>());
             * ViewBag.Engg_Name = new SelectList(Enumerable.Empty<SelectListItem>());
             * ViewBag.ReceivedDevice = new SelectList(Enumerable.Empty<SelectListItem>());
             * ViewBag.SpareType = new SelectList(Enumerable.Empty<SelectListItem>());
             * ViewBag.ProblemFound = new SelectList(Enumerable.Empty<SelectListItem>());*/

            //AllData ad = new AllData
            {
                var ReceiveMaterial = new ReceiveMaterials();
                ReceiveMaterial.ReceivedDeviceList = new SelectList(Enumerable.Empty <SelectListItem>());
                ReceiveMaterial.RecvdBrandlList    = new SelectList(Enumerable.Empty <SelectListItem>());
                ReceiveMaterial.RecvdModelList     = new SelectList(Enumerable.Empty <SelectListItem>());
                ReceiveMaterial.Engg_NameList      = new SelectList(Enumerable.Empty <SelectListItem>());
                ReceiveMaterial.SpareTypeList      = new SelectList(Enumerable.Empty <SelectListItem>());
                ReceiveMaterial.SpareNameList      = new SelectList(Enumerable.Empty <SelectListItem>());
                ReceiveMaterial.ProblemFoundList   = new SelectList(Enumerable.Empty <SelectListItem>());
            };

            if (TempData["Message"] != null)
            {
                ViewBag.Message = TempData["Message"].ToString();
            }
            return(View());
        }
 public ActionResult CJSForm(ReceiveMaterials m)
 {
     using (var con = new SqlConnection(_connectionString))
     {
         if (ModelState.IsValid)
         {
             var result1 = con.Query <int>("Insert_RPCAP_In_Repair_Request_Details",
                                           new
             {
                 m.CC_NO,
                 RPCAP_PaymentMode = m.PaymentMode,
                 RPCAP_TransNumber = m.TransNumber,
                 RPCAP_AccountHolderNameonCheque = m.AccountHolderNameonCheque,
                 RPCAP_CashDepositedByNameonSlip = m.CashDepositedByNameonSlip,
                 RPCAP_TransDateTime             = m.TransDateTime,
                 RPCAP_ChequeNumber = m.ChequeNumber,
                 RPCAP_CashDepositedByMobileNumberonSlip = m.CashDepositedByMobileNumberonSlip
             }, commandType: CommandType.StoredProcedure).FirstOrDefault();
             if (result1 == 1)
             {
                 TempData["Message"] = "Updated Successfully";
             }
             else
             {
                 TempData["Message"] = "Something Went Wrong";
             }
         }
     }
     return(RedirectToAction("RPCAP", "CustomerSupport"));
 }
        public ActionResult EditPIWRR()
        {
            /* ViewBag.ServiceProviderName = new SelectList(dropdown.BindServiceProvider(), "Value", "Text");
             * ViewBag.SpareType = new SelectList(dropdown.BindSpareType(), "Value", "Text");
             * ViewBag.SpareName = new SelectList(Enumerable.Empty<SelectListItem>());
             * ViewBag.ProblemObserved = new SelectList(dropdown.BindProblemObserved(), "Value", "Text");
             * ViewBag.SelectTrc = new SelectList(dropdown.BindTrc(), "Value", "Text");
             * ViewBag.CourierName = new SelectList(dropdown.BindCourier(), "Value", "Text");
             * ViewBag.CallStatus = new SelectList(dropdown.BindStatusMaster(), "Value", "Text");*/
            //AllData ad = new AllData

            var pwirr = new ReceiveMaterials();

            pwirr.ServiceProviderNameList = new SelectList(dropdown.BindServiceProvider(CurrentUser.CompanyId), "Value", "Text");
            pwirr.SpareTypeList           = new SelectList(dropdown.BindSpareType(CurrentUser.CompanyId), "Value", "Text");
            pwirr.SpareNameList           = new SelectList(Enumerable.Empty <SelectListItem>());
            pwirr.ProblemObservedList     = new SelectList(dropdown.BindProblemObserved(CurrentUser.CompanyId), "Value", "Text");
            pwirr.SelectTrcList           = new SelectList(Enumerable.Empty <SelectListItem>());
            pwirr.CourierNameList         = new SelectList(dropdown.BindCourier(CurrentUser.CompanyId), "Value", "Text");
            pwirr.CallStatusList          = new SelectList(dropdown.BindStatusMaster(), "Value", "Text");



            return(PartialView(pwirr));
        }
Esempio n. 4
0
        public async Task ReceiveMaterials_Success()
        {
            //adhere
            var initialMaterialRequestStatus = Material1TimberMaterialRequest.Status;
            var initialShopInventory         = MaterialStockpileShop.Inventory.DeepCopy();

            //arrange
            var command = new ReceiveMaterials
            {
                MaterialRequestId = Material1TimberMaterialRequest.Id,
                InitiatorId       = GlobalAdmin.Id
            };
            var handler = new ReceiveMaterialsHandler(EntityRepository, ShopRepo, InventoryService, EventTransmitter);

            //act
            await handler.HandleAsync(command);

            //assert
            var diffInventory = MaterialStockpileShop.Inventory.Of(Material1Timber).Amount
                                - initialShopInventory.Of(Material1Timber).Amount;

            Assert.That(diffInventory,
                        Is.EqualTo(Material1TimberMaterialRequest.ItemsRequested.Of(Material1Timber).Amount));
            Assert.That(initialMaterialRequestStatus, Is.EqualTo(MaterialRequestStatus.Submitted));
            Assert.That(Material1TimberMaterialRequest.Status, Is.EqualTo(MaterialRequestStatus.Fulfilled));
            Assert.That(GetRecordedEvents <MaterialsReceived>().Count, Is.EqualTo(1));

            //annul
            Material1TimberMaterialRequest.Status = initialMaterialRequestStatus;
            MaterialStockpileShop.Inventory       = initialShopInventory;
        }
Esempio n. 5
0
 public async Task PutMaterialRequestReceiveAsync(Guid id, Guid subId)
 {
     var command = new ReceiveMaterials()
     {
         MaterialRequestId = subId,
         InitiatorId       = Guid.NewGuid()
     };
     await _commandInvoker.Execute(command);
 }
Esempio n. 6
0
        public ActionResult RM()
        {
            var SessionModel     = Session["User"] as SessionModel;
            var receivematerials = new ReceiveMaterials();

            receivematerials.ReceivedDeviceList = new SelectList(dropdown.BindCategory(SessionModel.CompanyId), "Value", "Text");
            receivematerials.RecvdBrandlList    = new SelectList(dropdown.BindBrand(SessionModel.CompanyId), "Value", "Text");
            receivematerials.RecvdModelList     = new SelectList(Enumerable.Empty <SelectListItem>());
            receivematerials.Engg_NameList      = new SelectList(dropdown.BindEngineer(SessionModel.CompanyId), "Value", "Text");
            return(PartialView(receivematerials));
        }
        public ActionResult CJSForm()
        {
            var receivematerial = new ReceiveMaterials();

            receivematerial.ReceivedDeviceList = new SelectList(dropdown.BindCategory(CurrentUser.CompanyId), "Value", "Text");
            receivematerial.RecvdBrandlList    = new SelectList(dropdown.BindBrand(CurrentUser.CompanyId), "Value", "Text");
            receivematerial.RecvdModelList     = new SelectList(dropdown.BindProduct(CurrentUser.CompanyId), "Value", "Text");
            receivematerial.Engg_NameList      = new SelectList(dropdown.BindEngineer(CurrentUser.CompanyId), "Value", "Text");
            receivematerial.SpareTypeList      = new SelectList(dropdown.BindSpareType(CurrentUser.CompanyId), "Value", "Text");
            receivematerial.SpareNameList      = new SelectList(Enumerable.Empty <SelectListItem>());
            receivematerial.ProblemFoundList   = new SelectList(dropdown.BindProblemObserved(CurrentUser.CompanyId), "Value", "Text");
            return(PartialView(receivematerial));
        }
Esempio n. 8
0
        public ActionResult PFPForm(ReceiveMaterials m)
        {
            try
            {
                if (ModelState.IsValid)
                {
                    using (var con = new SqlConnection(_connectionString))
                    {
                        var result = con.Query <int>("Insert_into_Pending_For_Packing",
                                                     new
                        {
                            m.CC_NO,
                            m.Materials_packed,
                            m.Is_Repaking,
                            m.Number_of_Times_RePacked,
                            m.JOB_Date,
                            m.Is_QUTrust_Certificate_Printed,
                            m.Is_Functionality_Report_Printed,
                            m.Notice_Number_and_Level,
                            m.Packaging_Material,
                            m.Length,
                            m.Height,
                            Purpose = m.PurPose,
                            m.Previous_AWB_Number,
                            m.Previous_Courier_Name,
                            JOBNumber = m.JobNumber,
                            m.Packer_Name,
                            m.Packer_ID,
                            m.Packaging_Material_Size,
                            m.Width,
                            m.Weight,
                            CurrentUser.CompanyId
                        }, commandType: CommandType.StoredProcedure).FirstOrDefault();
                        if (result == 1)
                        {
                            TempData["Message"] = "Successfully Added";
                        }
                        else
                        {
                            TempData["Message"] = "Something Went Wrong";
                        }
                    }
                }

                return(RedirectToAction("index", "ServiceCenter"));
            }
            catch (Exception)
            {
                return(RedirectToAction("index", "ErrorPage"));
            }
        }
Esempio n. 9
0
        public ActionResult PFBIForm(ReceiveMaterials m)
        {
            try
            {
                if (ModelState.IsValid)
                {
                    using (var con = new SqlConnection(_connectionString))
                    {
                        var result = con.Query <int>("Insert_Into_Billing_Invoicing_Information",
                                                     new
                        {
                            m.CC_NO,
                            m.Device_Shipping_Attempt_Number,
                            m.Previous_Shipping_Date,
                            m.Bill_Invoice_Number,
                            m.Service_Charge,
                            m.Advance_Amount_Paid,
                            m.Due_Amount,
                            m.Bill_Invoice_Amount,
                            m.CourierID,
                            m.Material_Type,
                            m.Notice_Shipping_Attempt_Number,
                            m.Previous_AWB_Status,
                            m.Bill_Invoice_Date,
                            m.Spare_Parts_Cost,
                            m.Advance_Payment_Date,
                            m.Collectable_Amount,
                            m.Schedule_Courier_Pickup_Date,
                            m.Courier_Type,
                            CurrentUser.CompanyId
                        }, commandType: CommandType.StoredProcedure).FirstOrDefault();
                        if (result == 1)
                        {
                            TempData["Message"] = "Successfully Added";
                        }
                        else
                        {
                            TempData["Message"] = "Something Went Wrong";
                        }
                    }
                }

                return(RedirectToAction("index", "ServiceCenter"));
            }
            catch (Exception e)
            {
                return(RedirectToAction("index", "ErrorPage"));
            }
        }
        public ActionResult PRCCForm(ReceiveMaterials m)
        {
            using (var con = new SqlConnection(_connectionString))
            {
                if (m.TableData != null)
                {
                    foreach (var item in m.TableData)
                    {
                        var resul2 = con.Query <int>("InsertTableDataByPRCC",
                                                     new
                        {
                            CC_NO         = item.TablespaceCC_NOField,
                            SpareType     = item.TablespareTypeField,
                            SpareCode     = item.TablespareCodeField,
                            SpareName     = item.TablespareNameField,
                            Price         = item.TablesparePriceField,
                            SpareQuantity = item.TablespareQuantityField,
                            Total         = item.TablespareTotalField,
                        }, commandType: CommandType.StoredProcedure).FirstOrDefault();
                    }
                }

                var result1 = con.Query <int>("InsertDataByPRCC",
                                              new {
                    m.CC_NO,
                    m.Prcc_Is_Repair_Cost_Approved,
                    m.CallBackDatetime,
                    m.Prcc_EMail_SMS,
                    m.Prcc_AdvancePaymentAmount,
                    m.Prcc_SendCompanyBankAccountDetails,
                    m.Prcc_IsCustomerwantstopayAdvance,
                    m.Prcc_CustomerSupportRemarks
                }, commandType: CommandType.StoredProcedure).FirstOrDefault();
                if (result1 == 1)
                {
                    TempData["Message"] = "Updated Successfully";
                }
                else
                {
                    TempData["Message"] = "Something Went Wrong";
                }
            }
            return(RedirectToAction("PRCC", "CustomerSupport"));
        }
        public ActionResult PRCC()

        {
            {
                var receiveMaterial = new ReceiveMaterials();
                //var receiveMaterial = new PRCCModel();
                receiveMaterial.ReceivedDeviceList = new SelectList(Enumerable.Empty <SelectListItem>());
                receiveMaterial.RecvdBrandlList    = new SelectList(Enumerable.Empty <SelectListItem>());
                receiveMaterial.RecvdModelList     = new SelectList(Enumerable.Empty <SelectListItem>());
                receiveMaterial.Engg_NameList      = new SelectList(Enumerable.Empty <SelectListItem>());
                receiveMaterial.SpareTypeList      = new SelectList(Enumerable.Empty <SelectListItem>());
                receiveMaterial.ProblemFoundList   = new SelectList(Enumerable.Empty <SelectListItem>());
            };

            if (TempData["Message"] != null)
            {
                ViewBag.Message = TempData["Message"].ToString();
            }
            return(View());
        }
        public ActionResult PFRMAForm(ReceiveMaterials m)
        {
            using (var con = new SqlConnection(_connectionString))
            {
                var result = con.Query <int>("InsertDatainPFRMA",
                                             new
                {
                    m.CC_NO,
                    m.ApproverRemarks,
                    m.IsApproveforReceivingDevice
                }, commandType: CommandType.StoredProcedure).FirstOrDefault();
                if (result == 2)
                {
                    TempData["Message"] = "Successfully Updated";
                }

                else
                {
                    TempData["Message"] = "Something Went Wrong";
                }
                return(RedirectToAction("Index"));
            }
        }
        public ActionResult POOWRRForm(ReceiveMaterials m)
        {
            try
            {
                using (var con = new SqlConnection(_connectionString))
                {
                    if (m.TableData != null)
                    {
                        foreach (var item in m.TableData)
                        {
                            //item.spareCcNo
                            var result = con.Query <int>("Insert_Maintain_SpareTable_Data",
                                                         new
                            {
                                CC_NO         = item.TablespaceCC_NOField,
                                SpareType     = item.TablespareTypeField,
                                SpareCode     = item.TablespareCodeField,
                                SpareName     = item.TablespareNameField,
                                SpareQuantity = item.TablespareQuantityField,
                                Price         = item.TablesparePriceField,
                                Total         = item.TablespareTotalField
                            }

                                                         , commandType: CommandType.StoredProcedure).FirstOrDefault();
                        }
                    }
                    if (m.CcNo != null)
                    {
                        var value      = "";
                        var finalValue = "";
                        if (m.PrblmObsrvdPoowrr != null)
                        {
                            var problem = m.PrblmObsrvdPoowrr.Length;
                            for (var i = 0; i <= problem - 1; i++)
                            {
                                var Data = m.ProblemFound[i].FirstOrDefault();
                                value      = Data + ",";
                                finalValue = finalValue + value;
                            }
                        }

                        var result1 = con.Query <int>("InsertDataInto_Repair_Request_Details",
                                                      new {
                            CC_NO = m.CcNo,
                            m.ServiceCharge,
                            m.SpareCost,
                            m.EstimatedCost,
                            EstimatedCostApproved = m.IsEstimatedCostApproved,
                            CustomerAgreeWipeData = m.wipedevicedata,
                            Current_Status        = '0',
                            CallBackDate          = m.CallBackDatetime,
                            Email_SMS_To_Customer = m.EMail_SMS,
                            TrcId     = m.SelectTrc,
                            CourierId = m.CourierName,
                            m.Remarks,
                            TrcAddress = m.TRCFullAddr,
                            m.CourierContact,
                            m.CourierActive,
                            ReversePickUpDate = m.ReversePickupDate,
                            m.EngineerVisitDate,
                            CallRequestReject     = m.Reject,
                            ServiceProviderNameId = new Guid(m.ServiceProviderName),
                            m.PhysicalDamage,
                            DeviceWarrantyVoid = m.WarrantyVoid,
                            ProblemObserved    = finalValue,
                            m.Customer_Name,
                            m.Mobile_No,
                            m.Email_Id,
                            m.Cust_Add,
                            m.Cust_City,
                            m.Cust_State,
                            m.IMEI1,
                            m.IMEI2,
                            SerialNumber = m.Serial_No,
                            m.AltNo,
                            Pincode = m.Pincode,
                            m.WS,
                            m.CallStatus,
                            m.CallRequestRejectReason,
                            SchedulePickupDate = m.SchedulePickup
                        }, commandType: CommandType.StoredProcedure).FirstOrDefault();
                        var response = new ResponseModel {
                            IsSuccess = false
                        };
                        if (result1 == 1)
                        {
                            response.IsSuccess = true;
                            response.Response  = "Submitted Successfully";
                        }
                        else
                        {
                            response.Response = "Something went wrong";
                        }

                        TempData["response"] = response;
                    }
                }
                return(RedirectToAction("POOWRR", "CustomerSupport"));
            }
            catch (Exception e)
            {
                throw e;
            }
        }
        public ActionResult PFRForm(ReceiveMaterials m)
        {
            try
            {
                using (var con = new SqlConnection(_connectionString))
                {
                    if (m.TableData1 != null)
                    {
                        foreach (var item in m.TableData1)
                        {
                            var DeleteQuery = con.Execute("delete Maintain_SpareTable_Data where CC_NO = @CC_NO", new { @CC_NO = item.TablespaceCC_NOField1 }, commandType: CommandType.Text);
                            var result      = con.Query <int>("Insert_Maintain_SpareTable_Data_NEW",
                                                              new
                            {
                                CC_NO         = item.TablespaceCC_NOField1,
                                SpareType     = item.TablespareTypeField1,
                                SpareCode     = item.TablespareCodeField1,
                                SpareName     = item.TablespareNameField1,
                                SpareQuantity = item.TablespareQuantityField1,
                                Price         = item.TablesparePriceField1,
                                Total         = item.TablespareTotalField1,
                                SparePhoto    = item.TablesparePartPhoto1
                            }

                                                              , commandType: CommandType.StoredProcedure).FirstOrDefault();
                        }
                    }
                    if (m.CC_NO != null)
                    {
                        var result1 = con.Query <int>("Add_In_Repair_Request_Details_from_Trc_PFR",
                                                      new
                        {
                            m.CC_NO,
                            m.ApprovedSpareCost,
                            m.NeedApprovalofSpareCost,
                            m.AdditionalSpareCost,
                            m.TotalEstimatedSpareCost,
                            m.CurrentRepairCostApproved,
                            m.ApprovedRepairCost,
                            m.NeedApprovalofRepairCost,
                            m.TotalEstimatedRepairCost,
                            m.IsRepairCostApproved,
                            m.IsApprovalRequiredforAdditionalCost,
                            m.EngineerRemarks,
                            m.FinalRepairStatus,
                            m.IsDeviceFunctioningNormally,
                            m.IsDeviceislookingEqualToNew,
                            m.QCPersonName,
                            m.PendingJOBsoftheQCPerson,
                            m.IsRepairCost_is_Less_than_Approved_Cost
                        }, commandType: CommandType.StoredProcedure).FirstOrDefault();
                        if (result1 == 1)
                        {
                            TempData["Message"] = "Submitted Successfully";
                        }
                        else
                        {
                            TempData["Message"] = "Something went wrong";
                        }
                    }
                }
                return(RedirectToAction("Index", "Trc_PFR"));
            }
            catch (Exception e)
            {
                throw e;
            }
        }
        public ActionResult PFQCForm(ReceiveMaterials m)
        {
            try
            {
                using (var con = new SqlConnection(_connectionString))
                {
                    var rest = "";
                    if (m.Table_Pass_Fail != null)
                    {
                        int re = 0;
                        foreach (var item in m.Table_Pass_Fail)
                        {
                            var result = con.Query <int>("Insert_into_QCInformation",
                                                         new
                            {
                                CC_NO        = item.TablePassFailCC_No,
                                QC_ProblemID = item.TablePassFail_ProblemId,
                                QC_Pass      = item.TablePassFail_Pass,
                                QC_Fail      = item.TablePassFail_Fail
                            }

                                                         , commandType: CommandType.StoredProcedure).FirstOrDefault();
                            re = re + result;
                        }

                        if (re != 0)
                        {
                            var result = con.Query <string>("Update_Current_Status",
                                                            new
                            {
                                CC_NO = m.CC_NO
                            }

                                                            , commandType: CommandType.StoredProcedure).FirstOrDefault();
                            rest = result;
                        }
                    }
                    if (m.CC_NO != null && rest != null)
                    {
                        if (m.QUTrust_Certificate1 != null)
                        {
                            m.QUTrust_Certificate = SaveImageFile(m.QUTrust_Certificate1);
                        }
                        var value      = "";
                        var finalValue = "";
                        if (m.QCFailReason != null)
                        {
                            var problem = m.QCFailReason.Length;
                            for (var i = 0; i <= problem - 1; i++)
                            {
                                var Data = m.QCFailReason[i].FirstOrDefault();
                                value      = Data + ",";
                                finalValue = finalValue + value;
                            }
                        }

                        var result1 = con.Query <int>("Insert_into_Pending_for_Quality_Check",
                                                      new
                        {
                            m.CC_NO,
                            Is_Device_Tested_by_QUTrust = m.QUTrust,
                            QUTrust_Certificate_Number  = m.QUTrustCertificateNumber,
                            QUTrust_Score = m.QUTrustScore,
                            m.QUTrust_Certificate,
                            Functionality_Test                = m.FunctionalityTest,
                            QC_Fail_Reason                    = finalValue,
                            Is_Device_Functioning_Normally    = m.QC_IsDeviceFunctioningNormally,
                            Is_Device_is_looking_Equal_To_New = m.QC_IsDeviceislookingEqualToNew,
                            Final_QC_Status                   = m.FinalQCStatus,
                            QC_Remarks = m.QCRemarks
                        }
                                                      , commandType: CommandType.StoredProcedure).FirstOrDefault();
                        if (result1 == 1)
                        {
                            TempData["Message"] = "Submitted Successfully";
                        }
                        else
                        {
                            TempData["Message"] = "Something went wrong";
                        }
                    }
                }
                return(RedirectToAction("Index", "Trc_PFQC"));
            }
            catch (Exception e)
            {
                throw e;
            }
        }
Esempio n. 16
0
        public ActionResult RM(ReceiveMaterials m)
        {
            try
            {
                if (m.PhotoOfDevice1 != null)
                {
                    m.PhotoOfDevice = SaveImageFile(m.PhotoOfDevice1);
                }
                if (m.DamagedBox1 != null)
                {
                    m.DamagedBox = SaveImageFile(m.DamagedBox1);
                }

                using (var con = new SqlConnection(_connectionString))
                {
                    var result = con.Query <int>("InsertReceiveMaterialDetails",
                                                 new
                    {
                        m.CC_NO,
                        m.BtryRemovable,
                        m.BtryReq,
                        m.BtryReceived,
                        m.IsDiffDeviceRecvd,
                        m.BtryBrandAndModel,
                        m.DeviceTUPC,
                        RecvdDevice = m.ReceivedDevice,
                        m.RecvdBrand,
                        m.RecvdModel,
                        m.RecvdSerialNo,
                        m.RecvdIMEI1,
                        m.RecvdIMEI2,
                        m.IsPhyDamage,
                        m.PhotoOfDevice,
                        m.ReceiveDate,
                        m.ReceiveApprovalNeeded,
                        m.RecvRemarks,
                        m.EnggName,
                        m.RecvApprovalStatus,
                        m.RecvApprovalDate,
                        m.RecvApprovedBy,
                        DamagedBoxImage   = m.DamagedBox,
                        ReceivingDocument = m.ReceivingDoc,
                        m.BoxCondition,
                        IsReturnable      = m.Returnable,
                        NoOfBoxesReceived = m.NoOfBoxesReceived,
                        CreatedBy         = ""
                    }, commandType: CommandType.StoredProcedure).FirstOrDefault();
                    if (result == 1)
                    {
                        TempData["Message"] = "Successfully Added";
                    }
                    else if (result == 2)
                    {
                        TempData["Message"] = "Successfully Updated";
                    }
                    else
                    {
                        TempData["Message"] = "Something Went Wrong";
                    }
                    if (m.ReceiveApprovalNeeded)
                    {
                        return(RedirectToAction("Index", "Trc_PFRMA"));
                    }
                    else if (!m.ReceiveApprovalNeeded)
                    {
                        return(RedirectToAction("Index", "Trc_PFELS"));
                    }
                    else
                    {
                        return(RedirectToAction("Index"));
                    }
                }
            }
            catch (Exception e)
            {
                throw e;
            }
        }
Esempio n. 17
0
 public ActionResult Form_Re_Print_Invoice_Bill(ReceiveMaterials m)
 {
     return(View());
 }
        public ActionResult PFELSForm(ReceiveMaterials m)
        {
            try
            {
                using (var con = new SqlConnection(_connectionString))
                {
                    if (m.TableData != null)
                    {
                        foreach (var item in m.TableData)
                        {
                            //item.spareCcNo
                            //Delete procedure InsertDataPFELSTable
                            var result = con.Query <int>("Insert_Maintain_SpareTable_Data_NEW",
                                                         new
                            {
                                CC_NO         = item.TablespaceCC_NOField,
                                SpareType     = item.TablespareTypeField,
                                SpareCode     = item.TablespareCodeField,
                                SpareName     = item.TablespareNameField,
                                SpareQuantity = item.TablespareQuantityField
                            }

                                                         , commandType: CommandType.StoredProcedure).FirstOrDefault();
                        }
                    }
                    var value      = "";
                    var finalValue = "";
                    if (m.ProblemFound != null)
                    {
                        var problem = m.ProblemFound.Length;
                        for (var i = 0; i <= problem - 1; i++)
                        {
                            var Data = m.ProblemFound[i].FirstOrDefault();
                            value      = Data + ",";
                            finalValue = finalValue + value;
                        }
                    }

                    if (m.JobNumber != null)
                    {
                        var result = con.Query <int>("PfelsProc",
                                                     new
                        {
                            m.CC_NO,
                            m.CallStatus,
                            JobDate      = m.JOBDate,
                            EngineerName = m.Engg_Name,
                            m.WarrantyStickerTempered,
                            m.CurrentStatus,
                            m.JobNumber,
                            m.DeviceWaterDamaged,
                            DeviceWarrantyVoid       = m.WarrantyVoid,
                            ProblemFound             = finalValue,
                            OS_Software_Reinstall    = m.OS_SoftwareReinstall,
                            Customer_Data_Backup     = m.CustomerDataBackup,
                            Current_OS_Software_Name = m.CurrentOS_Software,
                            Installed_OS             = m.InstalledOS_Software,
                            m.EngineerRemarks,
                            m.DeviceServiceCharge
                        }

                                                     , commandType: CommandType.StoredProcedure).FirstOrDefault();
                        if (result == 1)
                        {
                            TempData["Message"] = "Added Successfully";
                        }
                        else if (result == 2)
                        {
                            TempData["Message"] = "Updated Successfully";
                        }
                        else
                        {
                            TempData["Message"] = "Something Went Wrong";
                        }
                    }
                }
                return(RedirectToAction("Index", "Trc_PFELS"));
            }
            catch (Exception e)
            {
                throw e;
            }
        }