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);
}
}
