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(); }
public static void FillChurchLicence() { xso.xso.Intialize(); if (!sdata.LicenceCreated()) { System.Environment.Exit(0); return; } try { datam.CHURCH = xso.xso.DATA_REGION[sdata.ChurchID]; datam.LCH_ID = CHURCH.item_id; datam.LCH_TYPE_ID = CHURCH.item_type.ToByte(); } catch (Exception ex) { MessageBox.Show(ex.Message); System.Environment.Exit(0); } }