private static string GetFormatedText(EF6.PosTenderType 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.PosTenderType object from the database using the given QueryString /// </summary> /// <param name="typeId">The primary key value</param> /// <returns>A EF6.PosTenderType object</returns> public static EF6.PosTenderType Get(string whereClause) { EF6.PosTenderType result = null; using (var ctx = new EF6.RT2020Entities()) { result = ctx.PosTenderType .SqlQuery(string.Format("Select * from PosTenderType Where {0}", whereClause)) .AsNoTracking() .FirstOrDefault(); } return(result); }
public static EF6.PosTenderType Get(string typeCode, string currencyCode) { EF6.PosTenderType result = null; using (var ctx = new EF6.RT2020Entities()) { var item = ctx.PosTenderType.Where(x => x.TypeCode == typeCode && x.CurrencyCode == currencyCode).AsNoTracking().FirstOrDefault(); if (item != null) { result = item; } } return(result); }
public static EF6.PosTenderType Get(Guid id) { EF6.PosTenderType result = null; using (var ctx = new EF6.RT2020Entities()) { var item = ctx.PosTenderType.Where(x => x.TypeId == id).AsNoTracking().FirstOrDefault(); if (item != null) { result = item; } } return(result); }
private bool Save() { decimal numeric = 0; if (txtTypeCode.Text.Length == 0) { errorProvider.SetError(txtTypeCode, "Cannot be blank!"); return(false); } else if (!decimal.TryParse(txtExchangeRate.Text, out numeric)) { errorProvider.SetError(txtExchangeRate, Resources.Common.DigitalNeeded); return(false); } else if (!decimal.TryParse(txtChargeRate.Text, out numeric)) { errorProvider.SetError(txtChargeRate, Resources.Common.DigitalNeeded); return(false); } else if (!decimal.TryParse(txtChargeAmount.Text, out numeric)) { errorProvider.SetError(txtChargeAmount, Resources.Common.DigitalNeeded); return(false); } else if (!decimal.TryParse(txtAdditionalMonthlyCharge.Text, out numeric)) { errorProvider.SetError(txtAdditionalMonthlyCharge, Resources.Common.DigitalNeeded); return(false); } else if (!decimal.TryParse(txtMinimumMonthlyCharge.Text, out numeric)) { errorProvider.SetError(txtMinimumMonthlyCharge, Resources.Common.DigitalNeeded); return(false); } else { errorProvider.SetError(txtTypeCode, string.Empty); errorProvider.SetError(txtExchangeRate, string.Empty); errorProvider.SetError(txtChargeRate, string.Empty); errorProvider.SetError(txtChargeAmount, string.Empty); errorProvider.SetError(txtAdditionalMonthlyCharge, string.Empty); errorProvider.SetError(txtMinimumMonthlyCharge, string.Empty); using (var ctx = new EF6.RT2020Entities()) { var oPosTenderType = ctx.PosTenderType.Find(_TenderTypeId); if (oPosTenderType == null) { oPosTenderType = new EF6.PosTenderType(); oPosTenderType.TypeId = Guid.NewGuid(); if (PosTenderTypeEx.IsTypeCodeInUse(txtTypeCode.Text.Trim())) { errorProvider.SetError(txtTypeCode, string.Format(Resources.Common.DuplicatedCode, "PoS Tender Type Code")); return(false); } else { oPosTenderType.TypeCode = txtTypeCode.Text; oPosTenderType.CreatedBy = ConfigHelper.CurrentUserId; oPosTenderType.CreatedOn = DateTime.Now; errorProvider.SetError(txtTypeCode, string.Empty); } ctx.PosTenderType.Add(oPosTenderType); } oPosTenderType.TypeName = txtTypeName.Text; oPosTenderType.TypeName_Chs = txtTypeNameAlt1.Text; oPosTenderType.TypeName_Cht = txtTypeNameAlt2.Text; oPosTenderType.CurrencyCode = cboCurrency.Text; oPosTenderType.ExchangeRate = (txtExchangeRate.Text.Length == 0) ? 0 : Convert.ToDecimal(txtExchangeRate.Text); oPosTenderType.DownloadToPOS = chkDownloadToPoS.Checked; oPosTenderType.ChargeRate = (txtChargeRate.Text.Length == 0) ? 0 : Convert.ToDecimal(txtChargeRate.Text); oPosTenderType.ChargeAmount = (txtChargeAmount.Text.Length == 0) ? 0 : Convert.ToDecimal(txtChargeAmount.Text); oPosTenderType.AdditionalMonthlyCharge = (txtAdditionalMonthlyCharge.Text.Length == 0) ? 0 : Convert.ToDecimal(txtAdditionalMonthlyCharge.Text); oPosTenderType.MinimumMonthlyCharge = (txtMinimumMonthlyCharge.Text.Length == 0) ? 0 : Convert.ToDecimal(txtMinimumMonthlyCharge.Text); oPosTenderType.ModifiedBy = ConfigHelper.CurrentUserId; oPosTenderType.ModifiedOn = DateTime.Now; ctx.SaveChanges(); } return(true); } }