private void buttonsave_Click(object sender, EventArgs e)
{
string _str = "Are You Sure You Want To Transfer The Selected Member ??";
if (!dbm.WarningMessage(_str, "Transfer Warning"))
{
return;
}
ic.transferC _tc = new MTOMS.ic.transferC();
_tc.church_name = fnn.GetIGridCellValue(fGrid, "church", "desc");
if (fGrid.Rows["church"].Cells["desc"].AuxValue != null)
{
xso.ic.cregion _r = (fGrid.Rows["church"].Cells["desc"].AuxValue as fnn.iGComboItemEX).Tag as xso.ic.cregion;
_tc.church_id = _r.item_id;
_tc.church_name = _r.item_name;
}
string[] _cols = new string[]
{
"mem_id",
"cat_id",
"reason",
"comment",
"transfer_date",
"transfer_fs_id",
"nchurch_name",
"church_id",
"edate",
"pc_us_id",
"exp_type",
"lch_id",
"lch_type_id"
};
object[] _row = new object[]
{
_tc.mem_id = mem_obj.mem_id,
0,
_tc.reason = fnn.GetIGridCellValue(fGrid, "reason", "desc"),
_tc.comment = fnn.GetIGridCellValue(fGrid, "comment", "desc"),
_tc.transfer_date = Convert.ToDateTime(fGrid.Rows["transfer_date"].Cells["desc"].AuxValue),
_tc.transfer_fs_id = fn.GetFSID(_tc.transfer_date),
_tc.church_name,
_tc.church_id,
datam.CURR_DATE,
datam.PC_US_ID,
emm.export_type.insert.ToByte(),
_tc.lch_id = datam.LCH_ID,
_tc.lch_type_id = datam.LCH_TYPE_ID
};
using (xing xd = new xing())
{
_tc.un_id = xd.SingleInsertCommandInt("transfer_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.Transfered.ToByte(), dbm.ETS, datam.PC_US_ID, mem_obj.mem_id));
xd.CommitTransaction();
}
datam.DATA_TRANSFER.Add(_tc.un_id, _tc);
mem_obj.mem_status_id = em.xmem_status.Transfered.ToByte();
mem_obj.objTransfer = _tc;
this.Close();
}
private static void fill_mem_transfer(ref xing xd)
{
string _str = "select * from transfer_tb";
try
{
if (DATA_TRANSFER == null)
{
DATA_TRANSFER = new SortedList <int, MTOMS.ic.transferC>();
}
if (DATA_TRANSFER.Keys.Count > 0)
{
return;
}
using (var _dr = xd.SelectCommand(_str))
{
ic.transferC obj = null;
while (_dr.Read())
{
obj = new MTOMS.ic.transferC();
obj.un_id = _dr["un_id"].ToInt32();
obj.mem_id = _dr["mem_id"].ToInt32();
obj.reason = _dr["reason"] == null ? string.Empty : _dr["reason"].ToStringNullable();
obj.comment = _dr["comment"] == null ? string.Empty : _dr["comment"].ToStringNullable();
obj.transfer_date = _dr.GetMySqlDateTime("transfer_date").Value;
obj.transfer_fs_id = fn.GetFSID(obj.transfer_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_TRANSFER.Add(obj.un_id, obj);
datam.DATA_MEMBER[obj.mem_id].objTransfer = 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);
}
}
