private bool InputMemberID()
{
bool _retval = false;
_MemberID = txtMemberID.Text.Trim();
var oEntities = new Entities();
oEntities.MemberNo = _MemberID;
if (_MemberID.Trim() == "")
{
if (ProsesNonMemberOrMember())
{
_retval = true;
}
}
else if (oEntities.SelectOneByMemberNo().Rows.Count > 0)
{
_EntitiesSeqNo = oEntities.EntitiesSeqNo.Trim();
var oMemberBenefit = new MemberBenefit();
oMemberBenefit.MBTypeID = oEntities.MemberTypeID.Trim();
if (oMemberBenefit.SelectOne().Rows.Count > 0)
{
_MemberName = oMemberBenefit.MBTypeName;
_MemberSince = string.Format(Program.FormatDate, oEntities.MemberSinceDate);
_MemberValidThru = string.Format(Program.FormatDate, oEntities.MemberValidThruDate);
if (ProsesNonMemberOrMember())
{
_retval = true;
}
}
else
{
_MemberName = string.Empty;
Program.MsgBox_Show("Member ID is not found");
}
oMemberBenefit.Dispose();
oMemberBenefit = null;
}
else
{
_EntitiesSeqNo = "";
_MemberName = "-";
_MemberSince = "-";
_MemberValidThru = "-";
Program.MsgBox_Show("Entities is not found");
}
oEntities.Dispose();
oEntities = null;
if (_retval)
{
_IsValid = true;
}
return(_retval);
}
private bool ProsesNonMemberOrMember()
{
var conn = new SqlConnection(HisConfiguration.ConnectionString);
SqlTransaction trans = null;
try
{
conn.Open();
trans = conn.BeginTransaction();
using (var oMemberBenefit = new MemberBenefit())
{
oMemberBenefit.ProsesNonMemberOrMemberPromotionByMemberNo(_MemberID, _STxnNo, conn, trans);
}
trans.Commit();
}
catch (Exception ex)
{
if (trans != null)
{
trans.Rollback();
trans.Dispose();
}
MessageBox.Show(ex.Message);
return(false);
}
finally
{
if (trans != null)
{
trans.Dispose();
}
conn.Close();
conn.Dispose();
}
return(true);
}
private void SearchSales()
{
if (PrepareNewSales("ConfirmationS") != true)
{
return;
}
SalesUnitHd salesHd;
using (var frm = new SearchSalesForm())
{
salesHd = frm.Search(_loginInfo);
}
if (salesHd != null)
{
txtSTxnNo.Text = salesHd.STxnNo;
txtSTxnDate.Text = string.Format(Program.FormatDate, salesHd.STxnDate);
cboCurrency.SelectedValue = salesHd.Currency;
txtCurrencyRate.Text = string.Format(Program.FormatCurrency, salesHd.CurrencyRate);
cboWh.SelectedValue = salesHd.WhID;
cboUnit.SelectedValue = salesHd.UnitID;
cbotranstype.SelectedValue = salesHd.StxnTypeID;
cboSTxnStatusID.SelectedValue = salesHd.STxnStatusID;
lblEntitiesSeqNo.Text = salesHd.EntitiesSeqNo;
var oEntities = new Entities();
oEntities.EntitiesSeqNo = lblEntitiesSeqNo.Text;
if (oEntities.SelectOne().Rows.Count > 0)
{
txtMemberID.Text = oEntities.MemberNo.Trim();
lblMemberSinceDate.Text = (string.Format(Program.FormatDate, oEntities.MemberSinceDate) == "01-01-1900" ? "-" : string.Format(Program.FormatDate, oEntities.MemberSinceDate));
lblValidThruDate.Text = (string.Format(Program.FormatDate, oEntities.MemberValidThruDate) == "01-01-1900" ? "-" : string.Format(Program.FormatDate, oEntities.MemberValidThruDate));
var oMemberBenefit = new MemberBenefit();
oMemberBenefit.MBTypeID = oEntities.MemberTypeID.Trim();
if (oMemberBenefit.SelectOne().Rows.Count > 0)
{
lblMemberName.Text = oMemberBenefit.MBTypeName;
}
oMemberBenefit.Dispose();
oMemberBenefit = null;
}
oEntities.Dispose();
oEntities = null;
//Detil
_dtbSalesItem = LoadSalesItem();
PopulateGridAndTotal();
if (Convert.ToString(cboSTxnStatusID.SelectedValue) == "C" || Convert.ToString(cboSTxnStatusID.SelectedValue) == "V")
{
Program.PoleDisplay_Show(ldp_Hello);
}
else
{
Program.PoleDisplay_Show(ldp_DefaultText);
}
}
}
