private static string GetFormatedText(EF6.InvtBatchTXF_Header target, string[] textField, string textFormatString) { for (int i = 0; i < textField.Length; i++) { PropertyInfo pi = target.GetType().GetProperty(textField[i]); textFormatString = textFormatString.Replace("{" + i.ToString() + "}", pi != null ? pi.GetValue(target, null).ToString() : string.Empty); } return(textFormatString); }
/// <summary> /// Get a EF6.InvtBatchTXF_Header object from the database using the given HeaderId /// </summary> /// <param name="headerId">The primary key value</param> /// <returns>A EF6.InvtBatchTXF_Header object</returns> public static EF6.InvtBatchTXF_Header Get(Guid headerId) { EF6.InvtBatchTXF_Header result = null; using (var ctx = new EF6.RT2020Entities()) { result = ctx.InvtBatchTXF_Header.Where(x => x.HeaderId == headerId).AsNoTracking().FirstOrDefault(); } return(result); }
/// <summary> /// Get a EF6.InvtBatchTXF_Header object from the database using the given QueryString /// </summary> /// <param name="headerId">The primary key value</param> /// <returns>A EF6.InvtBatchTXF_Header object</returns> public static EF6.InvtBatchTXF_Header Get(string whereClause) { EF6.InvtBatchTXF_Header result = null; using (var ctx = new EF6.RT2020Entities()) { result = ctx.InvtBatchTXF_Header .SqlQuery(string.Format("Select * from InvtBatchTXF_Header Where {0}", whereClause)) .AsNoTracking() .FirstOrDefault(); } return(result); }
private int Import() { int result = 0; using (var ctx = new EF6.RT2020Entities()) { using (var scope = ctx.Database.BeginTransaction()) { try { for (int i = 0; i < md.Length; i++) { string txNumber = SystemInfoHelper.Settings.QueuingTxNumber(EnumHelper.TxType.TXF); #region Guid headerId = ImportTxferHeader(md[i].Master as TxferTxtIEMaster, txNumber); var master = md[i].Master as TxferTxtIEMaster; var oHeader = new EF6.InvtBatchTXF_Header(); oHeader.HeaderId = Guid.NewGuid(); oHeader.TxType = EnumHelper.TxType.TXF.ToString(); oHeader.TxNumber = txNumber; oHeader.TxDate = master.TxDate; oHeader.TransferredOn = master.TxferDate; oHeader.CompletedOn = master.CompletionDate; oHeader.FromLocation = WorkplaceEx.GetWorkplaceIdByCode(master.FromLocation); oHeader.ToLocation = WorkplaceEx.GetWorkplaceIdByCode(master.ToLocation); oHeader.StaffId = StaffEx.GetStaffIdByStaffNumber(master.Operator); oHeader.Status = Convert.ToInt32(EnumHelper.Status.Draft.ToString("d")); oHeader.Reference = master.RefNumber; oHeader.Remarks = master.Remarks; oHeader.CreatedBy = ConfigHelper.CurrentUserId; oHeader.CreatedOn = DateTime.Now; oHeader.ModifiedBy = ConfigHelper.CurrentUserId; oHeader.ModifiedOn = DateTime.Now; ctx.InvtBatchTXF_Header.Add(oHeader); ctx.SaveChanges(); Guid headerId = oHeader.HeaderId; #endregion if (headerId != Guid.Empty) { lvImportedList.Items[i].Text = txNumber; #region ImportTxferDetails(md[i].Details, headerId, txNumber); object[] details = md[i].Details; if (details != null) { for (int j = 0; j < details.Length; j++) { TxferTxtIEDetails detail = details[j] as TxferTxtIEDetails; Guid prodId = GetProductId(detail); if (prodId != Guid.Empty) { var oDetail = new EF6.InvtBatchTXF_Details(); oDetail.DetailsId = Guid.NewGuid(); oDetail.ProductId = prodId; oDetail.HeaderId = headerId; oDetail.LineNumber = j + 1; oDetail.TxNumber = txNumber; oDetail.TxType = EnumHelper.TxType.TXF.ToString(); oDetail.QtyConfirmed = 0; oDetail.QtyHHT = 0; oDetail.QtyManualInput = 0; oDetail.QtyReceived = detail.TxferQty; oDetail.QtyRequested = detail.RequiredQty; oDetail.Remarks = detail.Remarks; ctx.InvtBatchTXF_Details.Add(oDetail); ctx.SaveChanges(); result++; } } } #endregion result++; } } scope.Commit(); } catch (Exception ex) { scope.Rollback(); } } } return(result); }