public Message actionCreateNewDiscrepancy(Discrepancy discrepancy) { discrepancy.datetime_reported = DateTime.Now; data.Discrepancies.AddObject(discrepancy); Stationery stationery = data.Stationeries.Where(o => o.id == discrepancy.stationery).Single(); stationery.quantity_in_stock = stationery.quantity_in_stock - discrepancy.quantity; StockTransaction stockTransaction = new StockTransaction(); stockTransaction.stationery = stationery.id; stockTransaction.quantity = "-" + discrepancy.quantity; stockTransaction.description = discrepancy.remark; stockTransaction.balance = stationery.quantity_in_stock.ToString(); stockTransaction.datetime_inserted = DateTime.Now; data.StockTransactions.AddObject(stockTransaction); try { if (data.SaveChanges() == 3) { return new Message(true); } else { return new Message(false); } } catch (Exception e) { return new Message(false, Helper.getExceptionMessage(e)); } }
public CreateDiscrepencyReportControl() { currentEmployee = Util.ValidateUser(Constants.EMPLOYEE_ROLE.STORE_CLERK); inventory = new InventoryEntities(); discrepancyBroker = new DiscrepancyBroker(inventory); itemBroker = new ItemBroker(inventory); item = new Item(); itemPriceBroker = new ItemPriceBroker(inventory); itemprice = new ItemPrice(); discrepancy = new Discrepancy(); discrepancy.Id = discrepancyBroker.GetDiscrepancyId(); discrepancy.CreatedDate = DateTime.Now; discrepancy.CreatedBy = Util.GetEmployee(new EmployeeBroker(inventory)); discrepancy.Status = Converter.objToInt(Constants.VISIBILITY_STATUS.SHOW); // discrepancyDetailList = new System.Data.Objects.DataClasses.EntityCollection<DiscrepancyDetail>(); dataColumn = new DataColumn[] { new DataColumn(columnName[0]), new DataColumn(columnName[1]), new DataColumn(columnName[2]), new DataColumn(columnName[3]), new DataColumn(columnName[4]), new DataColumn(columnName[5]) }; }
public Message actionCreateNewDiscrepancy(Discrepancy discrepancy) { discrepancy.datetime_reported = DateTime.Now; data.Discrepancies.AddObject(discrepancy); Stationery stationery = data.Stationeries.Where(o => o.id == discrepancy.stationery).Single(); stationery.quantity_in_stock = stationery.quantity_in_stock - discrepancy.quantity; StockTransaction stockTransaction = new StockTransaction(); stockTransaction.stationery = stationery.id; stockTransaction.quantity = "-" + discrepancy.quantity; stockTransaction.description = discrepancy.remark; stockTransaction.balance = stationery.quantity_in_stock.ToString(); stockTransaction.datetime_inserted = DateTime.Now; data.StockTransactions.AddObject(stockTransaction); try { if (data.SaveChanges() == 3) { return(new Message(true)); } else { return(new Message(false)); } } catch (Exception e) { return(new Message(false, Helper.getExceptionMessage(e))); } }
public void UpdateDiscrepancy_Test() { // Given var user2 = new User { Username = "******", Email = "*****@*****.**", Id = Guid.NewGuid() }; var discrepancy = new Discrepancy() { Created = DateTime.Now, DelayLength = 15, Id = Guid.NewGuid(), Reason = "Test Reason", Type = Discrepancy.DiscrepancyType.Absence, User = user2, UserId = user2.Id }; this.discrepancies.Add(discrepancy); var dto = new UpsertDiscrepancyDTO() { DelayLength = 15, Reason = "Test Reason Updated", Type = Discrepancy.DiscrepancyType.Absence }; // When this.service.UpdateDiscrepancy(discrepancy.Id, dto); // Then Assert.Equal("Test Reason Updated", this.discrepancies.First().Reason); }
public void actionApproveDiscrepancies(int id) { Discrepancy discrepancy = data.Discrepancies.Where(x => x.id == id).FirstOrDefault(); discrepancy.status = 1; data.SaveChanges(); }
private void FillDiscrepancyInformation(Discrepancy discrepancy, out string description, out string filledBy, out string addNo, out string openClosePage, out string caDescription, out string pn_ON, out string sn_ON, out string pn_OFF, out string sn_OFF, out string sta, out string autorizationNo, out string date) { sta = ""; autorizationNo = ""; date = ""; description = discrepancy.Description; filledBy = discrepancy.FilledBy == false ? "Crew" : "Maintenance Staff"; addNo = discrepancy.CorrectiveAction.AddNo; openClosePage = discrepancy.CorrectiveAction.Status.ToString(); caDescription = discrepancy.CorrectiveAction.Description; pn_ON = discrepancy.CorrectiveAction.PartNumberOn; sn_ON = discrepancy.CorrectiveAction.SerialNumberOn; pn_OFF = discrepancy.CorrectiveAction.PartNumberOff; sn_OFF = discrepancy.CorrectiveAction.SerialNumberOff; if (discrepancy.CertificateOfReleaseToService != null) { sta = discrepancy.CertificateOfReleaseToService.Station; date = discrepancy.CertificateOfReleaseToService.RecordDate.ToString(_termsProvider["DateFormat"].ToString()); if (discrepancy.CertificateOfReleaseToService.AuthorizationB1 != null) { autorizationNo = discrepancy.CertificateOfReleaseToService.AuthorizationB1.ToString(); } } filledBy = null; }
public Discrepancy actionGetDiscrepancy(int discrepancyId) { Discrepancy discrepancy = (from s in data.Discrepancies where s.id == discrepancyId select s).FirstOrDefault(); return(discrepancy); }
/// <summary> /// Пустой конструктор /// </summary> public DiscrepancyControl(Discrepancy discrepancy, List <Discrepancy> discrepancies, List <WorkPackage> workPackages, List <TransferRecord> transferRecords, bool showDeffects = false) : this() { ShowDeffects = showDeffects; _discrepancies.AddRange(discrepancies); _workPackages.AddRange(workPackages); _transferRecords.AddRange(transferRecords); AttachedObject = discrepancy; }
private void ConditionControlDeleted(object sender, EventArgs e) { DiscrepancyControlLight control = (DiscrepancyControlLight)sender; Discrepancy cond = control.Discrepancy; if (cond.ItemId > 0 && MessageBox.Show("Do you really want to delete Discrepancy?", "Deleting confirmation", MessageBoxButtons.YesNoCancel, MessageBoxIcon.Exclamation, MessageBoxDefaultButton.Button2) == DialogResult.Yes) { //если информация о состоянии сохранена в БД //и получен положительный ответ на ее удаление try { GlobalObjects.NewKeeper.Delete(cond); } catch (Exception ex) { Program.Provider.Logger.Log("Error while removing data", ex); } if (panelDiscrepancies.Controls.Contains(control)) { panelDiscrepancies.Controls.Remove(control); } else if (panelMEL.Controls.Contains(control)) { panelMEL.Controls.Remove(control); } else if (panelOldMEL.Controls.Contains(control)) { panelOldMEL.Controls.Remove(control); } control.Deleted -= ConditionControlDeleted; control.Dispose(); } else if (cond.ItemId <= 0) { if (panelDiscrepancies.Controls.Contains(control)) { panelDiscrepancies.Controls.Remove(control); } else if (panelMEL.Controls.Contains(control)) { panelMEL.Controls.Remove(control); } else if (panelOldMEL.Controls.Contains(control)) { panelOldMEL.Controls.Remove(control); } control.Deleted -= ConditionControlDeleted; control.Dispose(); } if (panelDiscrepancies.Controls.OfType <DiscrepancyControlLight>().Count() < 4) { linkLabelAddNew.Enabled = true; } }
public async Task <IViewComponentResult> InvokeAsync(Discrepancy model, int number = 0, bool hidden = false) { await Task.CompletedTask; ViewBag.Number = number; ViewBag.Hidden = hidden; return(View(model)); }
public bool addDiscrepancy(iDiscrepancy ides) { ReportDescrepancyController rd = new ReportDescrepancyController(); Discrepancy des = new Discrepancy(); des = changeiDestoDesEntity(ides); return(rd.insertDiscrepancy(des)); }
public void actionCreateNewDiscrepancy(int stationeryId, int quantity, string remarks) { Discrepancy discrepancy = new Discrepancy(); discrepancy.stationery = stationeryId; discrepancy.quantity = quantity; discrepancy.remark = remarks; discrepancy.datetime_reported = DateTime.Now; data.Discrepancies.AddObject(discrepancy); data.SaveChanges(); }
public Discrepancy getDiscrepancyByID(int disID) { var x = from y in ent.Discrepancies where y.DiscrepancyID == disID select y; Discrepancy d = new Discrepancy(); d = x.First <Discrepancy>(); return(d); }
public StockAdjustment GetStockAdjustment(StockAdjustment stockAdjustment) { stockAdjustmentObj = inventory.StockAdjustments.Where(staObj => staObj.Id == stockAdjustment.Id).First(); if (!stockAdjustmentObj.Equals(null)) { Discrepancy dis = inventory.Discrepancies.Where(disObj => disObj.Id == stockAdjustmentObj.Discrepancy.Id).First(); stockAdjustmentObj.Discrepancy = dis; } return(stockAdjustmentObj); }
public static DiscrepancyModel Copy(Discrepancy objIn) { DiscrepancyModel discrepency = new DiscrepancyModel(); discrepency.id = objIn.id; discrepency.stationery = objIn.stationery; discrepency.quantity = objIn.quantity; discrepency.remark = objIn.remark; //discrepency.datetime_reported = objIn.datetime_reported; discrepency.status = objIn.status; return discrepency; }
public Discrepancy changeiDestoDesEntity(iDiscrepancy ides) { Discrepancy des = new Discrepancy(); des.DateRaised = DateTime.Today; des.RaisedBy = ides.RaisedBy; des.TotalAmount = float.Parse(ides.TotalAmount); des.DiscrepancyStatus = "Pending Approval"; des.DateUpdated = DateTime.Today; return(des); }
public int getDiscrepancyID() { var q = from x in context.Discrepancies orderby x.DiscrepancyID descending select x; Discrepancy d = new Discrepancy(); d = q.First <Discrepancy>(); int dID = d.DiscrepancyID; return(dID); }
public void actionDeleteDiscrepancy(int discrepancyId) { Discrepancy discrepancy = (from s in data.Discrepancies where s.id == discrepancyId select s).FirstOrDefault(); if (discrepancy != null) { data.Discrepancies.DeleteObject(discrepancy); data.SaveChanges(); } }
public static DiscrepancyModel Copy(Discrepancy objIn) { DiscrepancyModel discrepency = new DiscrepancyModel(); discrepency.id = objIn.id; discrepency.stationery = objIn.stationery; discrepency.quantity = objIn.quantity; discrepency.remark = objIn.remark; //discrepency.datetime_reported = objIn.datetime_reported; discrepency.status = objIn.status; return(discrepency); }
/// <summary> /// Retrieve the Discrepancy and DiscrepancyDetail information from Department Table according to the department Parameter /// Return Discrepancy /// </summary> /// <param name="discrepancy"></param> /// <returns></returns> public Discrepancy GetDiscrepancy(Discrepancy discrepancy) { try { discrepancyObj = inventory.Discrepancies.Where(disObj => disObj.Id == discrepancy.Id).First(); } catch (Exception e) { discrepancyObj = null; } return(discrepancyObj); }
/// <summary> /// Show all discrepancy list which status is show /// Created By:Zin Mar Thwin /// Created Date:28-01-2012 /// Modified By: /// Modified Date: /// Modification Reason: /// Modified By: /// Modified Date: /// Modification Reason: /// </summary> /// <param name="itemDescription"></param> /// <returns>The return value of this method is resultItem.</returns> //public DataTable GetDiscrepancyList() //{ // dt = new DataTable(); // dt.Columns.AddRange(discrepancyListColumn); // List<Discrepancy> list = discrepancyBroker.GetAllDiscrepancy(); // foreach (Discrepancy temp in list) // { // DataRow dr; // // requisitionDetail = new RequisitionDetail(); // if (temp.Status == Converter.objToInt(Constants.VISIBILITY_STATUS.SHOW)) // { // // RequisitionDetail resultRequisitionDetail = requisitionBroker.GetRequisitionDetail(requisitionDetail); // dr = dt.NewRow(); // dr["id"] = temp.Id; // dr["createdBy"] = temp.CreatedBy.Name; // dr["createdDate"] = temp.CreatedDate; // int totalQty = 0; // foreach (DiscrepancyDetail tempDetail in temp.DiscrepancyDetails.ToList()) // { // totalQty += tempDetail.Qty; // } // dr["totalQty"] = totalQty; // dr["status"] = temp.Status; // dt.Rows.Add(dr); // } // } //List<Discrepancy> newList = new List<Discrepancy>(); //foreach (Discrepancy discrepancy in list) //{ // if (discrepancy.Status == Converter.objToInt(Constants.VISIBILITY_STATUS.SHOW)) // newList.Add(discrepancy); //} //return dt; //} /// <summary> /// Show all discrepancies /// Created By:JinChengCheng /// Created Date:26-01-2012 /// Modified By: /// Modified Date: /// Modification Reason: /// Modified By: /// Modified Date: /// Modification Reason: /// </summary> /// <param name=""></param> /// <returns>The return type of this method is datatable.</returns> //public DataTable GetDiscrepancyList() //{ // DataTable dt = new DataTable(); // DataRow dr = new DataRow(); // discrepancyList = new List<Discrepancy>(); // List<Discrepancy> newDiscrepancyDetailList = new List<Discrepancy>(); // discrepancyList = discrepancyBroker.GetAllDiscrepancy(); // foreach (Discrepancy temp in discrepancyList) // { // if (discrepancy.status == (int)Constants.VISIBILITY_STATUS.SHOW) // newDiscrepancyDetailList.Add(discrepancy); // dt.NewRow(); // dr["voucherNo"] = null; // dr["createdBy"] = temp.Employee.Name; // dr["createdDate"] = temp.createddate; // int totalQty; // //List<DiscrepancyDetail> list = (List<DiscrepancyDetail>)temp.DiscrepancyDetails; // foreach (DiscrepancyDetail tempDetail in temp.DiscrepancyDetails.list) // { // totalQty+=tempDetail.Qty; // } // dr["totalQty"] = totalQty; // dr["status"] = temp.status; // dt.Rows.Add(dt); // } //} //public Discrepancy SelectDiscrepancy(int discrepancyId) //{ // Discrepancy discrepancy = new Discrepancy(); // discrepancy.id = discrepancyId; // return discrepancyBroker.GetDiscrepancy(discrepancy); //} /// <summary> /// Show one discrepancy detail according the discrepancyId selected /// Created By:JinChengCheng /// Created Date:26-01-2012 /// Modified By: /// Modified Date: /// Modification Reason: /// Modified By: /// Modified Date: /// Modification Reason: /// </summary> /// <param name="discrepancyId"></param> ///// <returns>The return type of this method is datatable.</returns> public DataTable SelectDiscrepancy(int discrepancyId) { if (dtt == null) { dtt = new DataTable(); dtt.Columns.AddRange(detailColumn); } else { dtt.Rows.Clear(); } discrepancy = new Discrepancy(); discrepancy.Id = discrepancyId; discrepancy = discrepancyBroker.GetDiscrepancy(discrepancy); //List<DiscrepancyDetail> discrepancyDetailList = (List<DiscrepancyDetail>)discrepancy.DiscrepancyDetails; //List<DiscrepancyDetail> supervisorDetails = new List<DiscrepancyDetail>(); //List<DiscrepancyDetail> managerDetails = new List<DiscrepancyDetail>(); //foreach (DiscrepancyDetail dd in discrepancy.DiscrepancyDetails) //{ // if (dd.DiscrepancyType == Converter.objToInt(Constants.DISCREPANCY_TYPE.SUPERVISOR)) // { // supervisorDetails.Add(dd); // } // else // { // managerDetails.Add(dd); // } //} //List<DiscrepancyDetail> currentList; //if (currentEmployee.Role.Id == Converter.objToInt(Constants.EMPLOYEE_ROLE.STORE_SUPERVISOR)) //{ // currentList = supervisorDetails; //} //else //{ // currentList = managerDetails; //} foreach (DiscrepancyDetail temp in GetList(discrepancy.DiscrepancyDetails.ToList())) { drr = dtt.NewRow(); drr[detailColumnName[0]] = temp.Item.Id; drr[detailColumnName[1]] = temp.Item.Description; drr[detailColumnName[2]] = temp.Qty; drr[detailColumnName[3]] = temp.Qty * 10;//temp.Item.Cost; drr[detailColumnName[4]] = temp.Remarks; dtt.Rows.Add(drr); } return(dtt); }
/// <summary> /// Существует ли данное отклонение у полета /// </summary> /// <param name="d"></param> /// <returns></returns> private bool DiscrepancyExists(Discrepancy d) { // if (Flight == null || Flight.Reference == null) { return(false); } // return(Flight.Reference.Any(t => Flight.Reference == d.Description)); // }
public bool insertDiscrepancy(Discrepancy d) { Discrepancy di = d; context.AddToDiscrepancies(di); try { context.SaveChanges(); return(true); } catch (Exception e) { return(false); } }
public void actionUpdateDiscrepancy(int discrepancyId, int stationeryId, int quantity, string remarks, DateTime date_of_report) { Discrepancy discrepancy = (from s in data.Discrepancies where s.id == discrepancyId select s).FirstOrDefault(); if (discrepancy != null) { discrepancy.stationery = stationeryId; discrepancy.quantity = quantity; discrepancy.remark = remarks; discrepancy.datetime_reported = date_of_report; data.SaveChanges(); } }
public void AddDiscrepancy(Guid eventId, UpsertDiscrepancyDTO dto, Guid userId) { var evt = this._eventRepository.GetById(eventId); var discrepancy = new Discrepancy() { Created = DateTime.Now, Reason = dto.Reason, Type = dto.Type, DelayLength = dto.DelayLength, EventId = eventId, UserId = userId }; evt.AddDiscrepancy(discrepancy); this._eventRepository.Update(evt); }
/// <summary> /// Insert Discrepancy data to the Discrepancy and Discrepancy Detail Table according to the newdiscrepancy Parameter /// Return Constants.DB_STATUS /// </summary> /// <param name="newdiscrepancy"></param> /// <returns></returns> public Constants.DB_STATUS Insert(Discrepancy newdiscrepancy) { Constants.DB_STATUS status = Constants.DB_STATUS.UNKNOWN; try { inventory.AddToDiscrepancies(newdiscrepancy); inventory.SaveChanges(); status = Constants.DB_STATUS.SUCCESSFULL; } catch (Exception e) { status = Constants.DB_STATUS.FAILED; } return(status); }
///<summary> /// Generates the documents and spreadsheet necessary after being passed a Discrepancy. ///</summary> public void GenerateDiscrepancySingle(Discrepancy discrep) { // Initialize with path and filestream var newFile = $"~/Documents/Discrepancy{discrep.Id}.xlsx"; var list = new List <Discrepancy>(); list.Add(discrep); using (var fs = new FileStream(newFile, FileMode.Create, FileAccess.Write)) { IWorkbook workbook = new XSSFWorkbook(); workbook.CreateDiscrepancySheets(list); workbook.Write(fs); } }
/* * Реализация */ #region private void BuildControls() /// <summary> /// Строит нужные контролы /// </summary> private void BuildControls() { // Освобождаем старые контролы panelMain.Controls.Clear(); int count = 4; if (Flight != null && Flight.Discrepancies != null && Flight.Discrepancies.Length > count) { count = Flight.Discrepancies.Length; } for (int i = 0; i < count; i++) { // Добавляем разделитель if (i > 0) { Delimiter delimiter = new Delimiter(); delimiter.Style = DelimiterStyle.Solid; delimiter.Orientation = DelimiterOrientation.Horizontal; delimiter.Margin = new Padding(0, 10, 0, 10); delimiter.Width = 1000; this.panelMain.Controls.Add(delimiter); } // Добавляем контрол - неисправность DiscrepancyControl d = new DiscrepancyControl(); d.Index = i + 1; if (Flight != null && Flight.Discrepancies != null && i < Flight.Discrepancies.Length) { d.Discrepancy = Flight.Discrepancies[i]; } else if (Flight != null) // Не будем создавать Discrepancy, если объект Flight не задан - черевато дальнейшими ошибками { Discrepancy discrepancy = new Discrepancy(); d.Discrepancy = discrepancy; //discrepancy.LoadChildObjectsFromDatabase(); //discrepancy.CorrectiveAction.LoadChildObjectsFromDatabase(); //discrepancy.Flight = Flight; } this.panelMain.Controls.Add(d); } }
public void createNewDiscrepancy(HttpContext context) { int stationeryId = Convert.ToInt32(context.Request.Form["stationeryId"]); int quantity = Convert.ToInt32(context.Request.Form["quantity"]); string remark = context.Request.Form["remark"]; Discrepancy d = new Discrepancy(); d.stationery = stationeryId; d.quantity = quantity; d.remark = remark; new DiscrepencyController().actionCreateNewDiscrepancy(d); context.Response.ContentType = "text/plain"; context.Response.Write("Successfully recorded as discrepancy item."); context.Response.End(); }
protected void ui_save_button_Click(object sender, EventArgs e) { DiscrepencyController discrepancyController = new DiscrepencyController(); Discrepancy discrepancy = new Discrepancy(); if (String.IsNullOrEmpty(ui_stationery_hidden.Value) || String.IsNullOrEmpty(ui_quantity_textbox.Text)) { Response.Cookies.Add(new HttpCookie("flash_message", "Field(s) marked with * can't be empty.") { Path = "/" }); Response.Cookies.Add(new HttpCookie("flash_css", "alert alert-error") { Path = "/" }); return; } discrepancy.stationery = Convert.ToInt32(ui_stationery_hidden.Value); try { discrepancy.quantity = Convert.ToInt32(ui_quantity_textbox.Text); if (discrepancy.quantity < 0) { throw new Exception(); } } catch (Exception ex) { Response.Cookies.Add(new HttpCookie("flash_message", "Quantity should be only number.") { Path = "/" }); Response.Cookies.Add(new HttpCookie("flash_css", "alert alert-error") { Path = "/" }); Response.Redirect(Request.RawUrl); } discrepancy.remark = ui_remark_textboxt.Text; discrepancyController.actionCreateNewDiscrepancy(discrepancy); Response.Redirect("DiscrepancyList.aspx"); }
public void DeleteDiscrepancy_Test() { // Given var user2 = new User { Username = "******", Email = "*****@*****.**", Id = Guid.NewGuid() }; var discrepancy = new Discrepancy() { Created = DateTime.Now, DelayLength = 15, Id = Guid.NewGuid(), Reason = "Test Reason", Type = Discrepancy.DiscrepancyType.Absence, User = user2, UserId = user2.Id }; this.discrepancies.Add(discrepancy); // When this.service.DeleteDiscrepancy(discrepancy.Id); // Then Assert.Empty(this.discrepancies); }
public void IsUserDiscrepancyIssuer_Is_Issuer_Returns_True_Test() { // Given var user = new User { Username = "******", Email = "*****@*****.**", Id = Guid.NewGuid() }; var discrepancy = new Discrepancy() { Created = DateTime.Now, DelayLength = 15, Id = Guid.NewGuid(), Reason = "Test Reason", Type = Discrepancy.DiscrepancyType.Absence, User = user, UserId = user.Id }; this.discrepancies.Add(discrepancy); // When bool result = this.service.IsUserDiscrepancyIssuer(user.Id, discrepancy.Id); // Then Assert.True(result); }