private static void fill_mem_apostacy(ref xing xd)
{
string _str = "select * from apostacy_tb";
try
{
if (DATA_APOSTACY == null)
{
DATA_APOSTACY = new SortedList <int, MTOMS.ic.apostacyC>();
}
if (DATA_APOSTACY.Keys.Count > 0)
{
return;
}
using (var _dr = xd.SelectCommand(_str))
{
ic.apostacyC obj = null;
while (_dr.Read())
{
obj = new MTOMS.ic.apostacyC();
obj.mem_id = _dr["mem_id"].ToInt32();
obj.un_id = _dr["un_id"].ToInt32();
obj.reason = _dr["reason"] == null ? string.Empty : _dr["reason"].ToStringNullable();
obj.comment = _dr["comment"] == null ? string.Empty : _dr["comment"].ToStringNullable();
obj.apostacy_date = _dr.GetMySqlDateTime("apos_date").Value;
obj.apostacy_fs_id = fn.GetFSID(obj.apostacy_date);
obj.pc_us_id = _dr["pc_us_id"].ToInt32();
if (_dr["lch_id"] != null)
{
obj.lch_id = _dr["lch_id"].ToInt32();
}
if (_dr["lch_type_id"] != null)
{
obj.lch_type_id = _dr["lch_type_id"].ToInt32();
}
DATA_APOSTACY.Add(obj.un_id, obj);
datam.DATA_MEMBER[obj.mem_id].objApostacy = obj;
}
_dr.Close(); _dr.Dispose();
}
}
catch (VistaDB.Diagnostic.VistaDBException ex)
{
MessageBox.Show(ex.Message);
throw new Exception("Data Loading Failed");
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
private void buttonsave_Click(object sender, EventArgs e)
{
string _str = "Are You Sure You Want To Carry Out This Operation ??";
if (!dbm.WarningMessage(_str, "Apostacy Warning"))
{
return;
}
ic.apostacyC _tc = new MTOMS.ic.apostacyC();
string[] _cols = new string[]
{
"mem_id",
"apos_date",
"apos_fs_id",
"cat_id",
"reason",
"comment",
"edate",
"exp_type",
"pc_us_id",
"lch_id",
"lch_type_id",
"fs_time_stamp"
};
object[] _row = new object[]
{
_tc.mem_id = mem_obj.mem_id,
_tc.apostacy_date = Convert.ToDateTime(fGrid.Rows["apostacy_date"].Cells["desc"].AuxValue),
_tc.apostacy_fs_id = fn.GetFSID(_tc.apostacy_date),
0,
_tc.reason = fnn.GetIGridCellValue(fGrid, "reason", "desc"),
_tc.comment = fnn.GetIGridCellValue(fGrid, "comment", "desc"),
datam.CURR_DATE,
emm.export_type.insert.ToByte(),
datam.PC_US_ID,
_tc.lch_id = datam.LCH_ID,
_tc.lch_type_id = datam.LCH_TYPE_ID,
0//fs_time_stamp
};
using (xing xd = new xing())
{
_tc.un_id = xd.SingleInsertCommandTSPInt("apostacy_tb", _cols, _row);
xd.InsertUpdateDelete(string.Format("update member_tb set mem_status_type_id={0},{1},pc_us_id={2} where mem_id={3}", em.xmem_status.Apostacy.ToByte(), dbm.ETS, datam.PC_US_ID, mem_obj.mem_id));
xd.CommitTransaction();
}
datam.DATA_APOSTACY.Add(_tc.un_id, _tc);
mem_obj.mem_status_id = em.xmem_status.Apostacy.ToByte();
mem_obj.objApostacy = _tc;
this.Close();
}
