//[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)); }
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; }
public async Task PutMaterialRequestReceiveAsync(Guid id, Guid subId) { var command = new ReceiveMaterials() { MaterialRequestId = subId, InitiatorId = Guid.NewGuid() }; await _commandInvoker.Execute(command); }
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)); }
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")); } }
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; } }
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; } }
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; } }