private void ParentsMaker_Load(object sender, EventArgs e) { xso.xso.Intialize(); datam.SecurityCheck(); CenterToScreen(); datam.SystemInitializer(); combomother.SelectedIndexChanged += new EventHandler(combomother_SelectedIndexChanged); combomother.SelectionChangeCommitted += new EventHandler(combomother_SelectionChangeCommitted); // combofather.SelectedIndexChanged += new EventHandler(combofather_SelectedIndexChanged); combofather.SelectionChangeCommitted += new EventHandler(combofather_SelectionChangeCommitted); // comboguardian.SelectedIndexChanged += new EventHandler(comboguardian_SelectedIndexChanged); comboguardian.SelectionChangeCommitted += new EventHandler(comboguardian_SelectionChangeCommitted); buttonsave.Enabled = false; buttoncanc.PerformClick(); if (this.Tag == null) { _mem_obj = new MTOMS.ic.memberC(); } else { _mem_obj = this.Tag as ic.memberC; } LoadMembers(); }
private void Update_Spouse(xing xd, ic.memberC mem_obj) { ic.spouseC objSpouse = mem_obj.objSpouse; string[] tb_col = null; object[] _row = null; tb_col = new string[] { "mem_id", "spouse_id", "spouse_name", "phone_no", "marriage_year", "marriage_date", "marriage_fs_id", "couple_id", "pastor_name", "church_name", "church_id", "un_id" }; _row = new object[] { objSpouse.mem_id, objSpouse.spouse_id, objSpouse.spouse_name, objSpouse.phone_no, objSpouse.marriage_year, objSpouse.marriage_date, objSpouse.marriage_fs_id, objSpouse.couple_id, objSpouse.pastor, objSpouse.church, 0, objSpouse.un_id }; xd.SingleUpdateCommandALL("ng_spouse_tb", tb_col, _row, 1); }
private void cbx_member_SelectedIndexChanged(object sender, EventArgs e) { if (cbx_member.SelectedIndex != -1) { m_sel_item = null; selected_mem_obj = null; } }
private void ApostacyForm_Load(object sender, EventArgs e) { CenterToScreen(); mem_obj = this.Tag as ic.memberC; this.BackColor = Color.WhiteSmoke; datam.SecurityCheck(); datam.SystemInitializer(); InitIgridColumns(); LoadMainGrid(); Application.DoEvents(); fGrid.SetCurCell("apostacy_date", 1); }
private static bool Save_parent(xing xd, ic.memberC mem_obj) { if (xd == null) { return(false); } if (mem_obj == null) { return(false); } string[] tb_col = null; object[] _row = null; tb_col = new string[] { "mem_id", "father_name", "father_phone", "father_status", "mother_name", "mother_phone", "mother_status", "guardian_name", "guardian_phone", "exp_type", "father_mem_id", "mother_mem_id", "guardian_mem_id", "lch_id", "lch_type_id" }; _row = new object[] { mem_obj.mem_id, mem_obj.objParent.father_name, mem_obj.objParent.father_phone, mem_obj.objParent.father_status, mem_obj.objParent.mother_name, mem_obj.objParent.mother_phone, mem_obj.objParent.mother_status, mem_obj.objParent.guardian_name, mem_obj.objParent.guardian_phone, emm.export_type.insert.ToByte(), mem_obj.objParent.father_mem_id, mem_obj.objParent.mother_mem_id, mem_obj.objParent.guardian_mem_id, datam.LCH_ID, datam.LCH_TYPE_ID }; xd.SingleInsertCommand("parents_tb", tb_col, _row); return(true); }
public static int CustomAgeGroup(this ic.memberC value, int yr) { if (value == null | yr == 0) { return(0); } int mem_age = (yr - value.birth_yr); var nlist = (xso.xso.DATA_AGEGROUP.Values.Where(o => mem_age >= o.start_age && mem_age <= o.end_age)).FirstOrDefault(); if (nlist != null) { return(nlist.age_gp_id); } return(0); }
private static bool Save_baptism(xing xd, ic.memberC mem_obj) { if (xd == null) { return(false); } if (mem_obj == null) { return(false); } ic.baptismC objBaptism = mem_obj.objBaptism; objBaptism.mem_id = mem_obj.mem_id; string[] tb_col = null; object[] _row = null; tb_col = new string[] { "mem_id", "bapt_yr", "bapt_date", "bapt_fs_id", "bapt_place", "bapt_pastor", "bapt_country", "bapt_church", "exp_type", "lch_id", "lch_type_id", "bapt_pastor_id", "bapt_church_id" }; _row = new object[] { mem_obj.mem_id, objBaptism.bapt_yr, null, objBaptism.bapt_fs_id, objBaptism.bapt_place, objBaptism.bapt_pastor, objBaptism.bapt_country, objBaptism.bapt_church, emm.export_type.insert.ToByte(), datam.LCH_ID, datam.LCH_TYPE_ID, objBaptism.bapt_pastor_id, objBaptism.bapt_church_id }; objBaptism.un_id = xd.SingleInsertCommandInt("baptismal_tb", tb_col, _row); return(true); }
public void Save_spouse(xing xd, ic.memberC mem_obj) { ic.spouseC objSpouse = mem_obj.objSpouse; string[] tb_col = null; object[] _row = null; tb_col = new string[] { "mem_id", "spouse_id", "spouse_name", "phone_no", "marriage_year", "marriage_date", "marriage_fs_id", "couple_id", "exp_type", "pastor_name", "pastor_id", "church_name", "church_id", "lch_id", "lch_type_id", "fs_time_stamp" }; _row = new object[] { objSpouse.mem_id, objSpouse.spouse_id, objSpouse.spouse_name, objSpouse.phone_no, objSpouse.marriage_year, objSpouse.marriage_date, objSpouse.marriage_fs_id, objSpouse.couple_id, emm.export_type.insert.ToByte(), objSpouse.pastor, 0, objSpouse.church, 0, datam.LCH_ID, datam.LCH_TYPE_ID, 0//fs_time_stamp }; objSpouse.un_id = xd.SingleInsertCommandTSPInt("ng_spouse_tb", tb_col, _row); }
private void cbx_member_SelectionChangeCommitted(object sender, EventArgs e) { if (cbx_member.SelectedIndex == -1) { return; } m_sel_item = cbx_member.SelectedItem as cbItemx; if (m_sel_item == null) { return; } selected_mem_obj = m_sel_item.AttachedObject as ic.memberC; clear_control(); if (selected_mem_obj != null) { cbx_cat.Select(); cbx_cat.Focus(); } }
public static bool Save_address(xing xd, ic.memberC mem_obj) { if (xd == null) { return(false); } if (mem_obj == null) { return(false); } ic.addressC objAddress = mem_obj.objAddress; objAddress.mem_id = mem_obj.mem_id; string[] tb_col = null; object[] _row = null; tb_col = new string[] { "mem_id", "phone1", "phone2", "email", "phy_address", "postal_address", "exp_type", "division", "village", "lch_id", "lch_type_id" }; _row = new object[] { objAddress.mem_id, objAddress.phone1, objAddress.phone2, objAddress.email, objAddress.phy_address, objAddress.postal_address, emm.export_type.insert.ToByte(), objAddress.division, objAddress.village, datam.LCH_ID, datam.LCH_TYPE_ID }; xd.SingleInsertCommandInt("address_tb", tb_col, _row); return(true); }
private void ChildrenMaker_Load(object sender, EventArgs e) { xso.xso.Intialize(); datam.SecurityCheck(); datam.SystemInitializer(); CenterToScreen(); combochild.SelectedIndexChanged += new EventHandler(combochild_SelectedIndexChanged); combochild.SelectionChangeCommitted += new EventHandler(combochild_SelectionChangeCommitted); if (this.Tag == null) { _mem_obj = new MTOMS.ic.memberC(); } else { _mem_obj = this.Tag as ic.memberC; } LoadMembers(); combochild.Focus(); }
private static bool Save_occupation(xing xd, ic.memberC mem_obj) { if (xd == null) { return(false); } if (mem_obj == null) { return(false); } string[] tb_col = null; object[] _row = null; tb_col = new string[] { "mem_id", "occup_cat_id", "occup_type_id", "employer", "exp_type", "lch_id", "lch_type_id", "occup_other", "other_skills", }; _row = new object[] { mem_obj.mem_id, mem_obj.objOccupation.occ_cat_id, mem_obj.objOccupation.occ_type_id, mem_obj.objOccupation.employer, emm.export_type.insert.ToByte(), datam.LCH_ID, datam.LCH_TYPE_ID, mem_obj.objOccupation.occupation_other, mem_obj.objOccupation.other_skills }; xd.SingleInsertCommandInt("occupation_tb", tb_col, _row); return(true); }
// public static bool Save_member(xing xd, ic.memberC mem_obj) { if (xd == null) { return(false); } if (mem_obj == null) { return(false); } string[] tb_col = null; object[] _row = null; object _bdate = null; object _jdate = null; //if (!string.IsNullOrEmpty(mem_obj.mem_birth_date)) //{ // _bdate = Convert.ToDateTime(mem_obj.mem_birth_date); //} GetMemberID(xd); mem_obj.mem_id = mem_id; mem_obj.mem_code = mem_code; mem_obj.mem_u_code = string.Format("{0}-{1}", mem_obj.mem_code, datam.LCH_ID); mem_obj.mem_status_id = em.xmem_status.Normal.ToByte(); mem_obj.country_id = -1; if (mem_obj.join_date != null) { _jdate = mem_obj.join_date.Value; } Int64 _stamp = xd.CreateFsTimeStamp(); tb_col = new string[] { #region MyRegion "mem_id", "mem_code", "mem_u_code", "mem_title_id", "mem_name", "mem_o_name", "mem_gender_id", "mem_birth_yr", "mem_birth_date", "mem_birth_fs_id", "marital_type_id", "e_fs_id", "e_date", "baptismal_type_id", "mem_status_type_id", "mem_educ_level_id", "prev_church", "lch_type_id", "lch_id", "exp_type", "country_id", "tribe_id", "join_year", "join_date", "join_fs_id", "national_id", "national_id_type", "fs_time_stamp", "pc_us_id", "xfield1", "xfield2", "mem_type_id", "prev_religion", "empl_status_id", "mem_church_code" #endregion }; _row = new object[] { #region MyRegion mem_obj.mem_id, mem_obj.mem_code, mem_obj.mem_u_code, mem_obj.mem_title_id, mem_obj.mem_name, mem_obj.mem_o_name, mem_obj.gender_id, mem_obj.birth_yr, _bdate, mem_obj.mem_birth_fs_id, mem_obj.marital_type_id, datam.CURR_FS.fs_id, datam.CURR_DATE, mem_obj.baptismal_type_id, mem_obj.mem_status_id, mem_obj.educ_level_id, mem_obj.prev_church, datam.LCH_TYPE_ID, datam.LCH_ID, emm.export_type.insert.ToByte(), mem_obj.country_id, 0,//tribe name mem_obj.join_year, _jdate, mem_obj.join_fs_id, 0, // national id 0, //national_id_type _stamp, datam.PC_US_ID, 0, 0, mem_obj.mem_type.ToByte(), mem_obj.prev_religion, mem_obj.employment_status.ToByte(), mem_obj.mem_church_code #endregion }; xd.SingleInsertCommand("member_tb", tb_col, _row); xd.IDCtrlDelete(mem_id_tb); return(true); }
private static bool ProcessCell(ic.memberC _emp, string _alpha, string _val) { try { #region start switch (_alpha.ToLower()) { case "a": { var _names = _val.Trim().ToProperCase().Split(new char[] { ' ' }); if (_names.Length == 1) { _emp.mem_name = string.Format("{0}", _names[0]); } if (_names.Length == 2) { _emp.mem_name = string.Format("{0} {1}", _names[0], _names[1]); } if (_names.Length == 3) { _emp.mem_name = string.Format("{0} {1}", _names[0], _names[1]); _emp.mem_o_name = string.Format("{0}", _names[2]); } if (_names.Length == 4) { _emp.mem_name = string.Format("{0} {1}", _names[0], _names[1]); _emp.mem_o_name = string.Format("{0} {1}", _names[2], _names[3]); } break; } case "b": { _emp.mem_o_name += _val.Trim().ToProperCase(); break; } case "c": { var _new_val = _val.Trim(); if (string.IsNullOrEmpty(_new_val)) //nil { break; } _emp.temp_date = _new_val; break; } case "d": //birth_year { var _new_val = _val.Trim(); if (string.IsNullOrEmpty(_new_val) || _new_val.Length < 4) //nil { return(false); } _emp.birth_yr = _new_val.ToInt16(); string _dt_string = null; if (string.IsNullOrEmpty(_emp.temp_date)) { return(true); } else { var _split = _emp.temp_date.Split(new char[] { '-' }); if (_split.Length == 1) { return(true); } else { short _id = 0; bool _found = false; foreach (var _m in _months) { _id++; if (_split[1].ToLower() == _m) { _found = true; break; } } if (!_found) { dbm.MessageNormal(_split[1], "er"); break; } _dt_string = string.Format("{0}/{1}/{2}", _id, _split[0].Trim().ToInt16(), _new_val.ToInt16()); } } if (!string.IsNullOrEmpty(_dt_string)) { _emp.birth_yr = _new_val.ToInt16(); // _emp.mem_birth_date = _dt_string; _emp.mem_birth_fs_id = fn.GetFSID(_dt_string); } break; } case "e": //gender { _emp.gender_id = _val.Trim().ToLower() == "m" ? em.xgender.Male.ToByte() : em.xgender.Female.ToByte(); break; } case "f": { var _new_val = _val.Trim(); if (string.IsNullOrEmpty(_new_val)) //nil { break; } if (_emp.objParent == null) { _emp.objParent = new MTOMS.ic.parentC(); _emp.objParent.father_name = _new_val.ToProperCase(); } break; } case "g": { var _new_val = _val.Trim(); if (string.IsNullOrEmpty(_new_val)) //nil { break; } if (_emp.objParent == null) { _emp.objParent = new MTOMS.ic.parentC(); _emp.objParent.mother_name = _new_val.ToProperCase(); } break; } case "h": { var _new_val = _val.Trim().ToLower(); if (string.IsNullOrEmpty(_new_val)) //nil { _emp.country_id = xso.xso.DATA_COUNTRY.Values.Where(k => k.country_name.ToLower() == "uganda").FirstOrDefault().country_id; break; } _emp.country_id = xso.xso.DATA_COUNTRY.Values.Where(k => k.country_name.ToLower() == _new_val).FirstOrDefault().country_id; if (_emp.country_id == 0) { dbm.MessageNormal(_new_val, "er"); } break; } case "i": //residence { var _new_val = _val.Trim().ToProperCase(); if (string.IsNullOrEmpty(_new_val)) //nil { break; } if (_emp.objAddress == null) { _emp.objAddress = new MTOMS.ic.addressC(); } _emp.objAddress.village = _new_val; break; } case "j": //residence { var _new_val = _val.Trim().ToProperCase(); if (string.IsNullOrEmpty(_new_val)) //nil { break; } if (_emp.objAddress == null) { _emp.objAddress = new MTOMS.ic.addressC(); } _emp.objAddress.phy_address = _new_val; break; } case "k": //contact { var _new_val = _val.Trim().ToProperCase(); if (string.IsNullOrEmpty(_new_val)) //nil { break; } if (_emp.objAddress == null) { _emp.objAddress = new MTOMS.ic.addressC(); } var _split = _new_val.Split(new char[] { '/' }); if (_split.Length == 1) { _emp.objAddress.phone1 = !_split[0].StartsWith("0") ? string.Format("0{0}", _split[0]) : _split[0]; } else { _emp.objAddress.phone1 = !_split[0].StartsWith("0") ? string.Format("0{0}", _split[0]) : _split[0]; _emp.objAddress.phone2 = !_split[1].StartsWith("0") ? string.Format("0{0}", _split[1]) : _split[1]; } break; } case "l": //email { var _new_val = _val.Trim(); if (string.IsNullOrEmpty(_new_val)) //nil { break; } if (_emp.objAddress == null) { _emp.objAddress = new MTOMS.ic.addressC(); } _emp.objAddress.email = _new_val; break; } case "m": //education level { var _new_val = _val.Trim(); if (string.IsNullOrEmpty(_new_val)) //nil { _emp.educ_level_id = xso.xso.DATA_COMMON.Values.Where(j => j.item_section == xso.em.common_section.education_level & j.item_name.ToLower() == "none").FirstOrDefault().item_id; break; } _emp.educ_level_id = xso.xso.DATA_COMMON.Values.Where(j => j.item_section == xso.em.common_section.education_level & j.item_name.ToLower() == _new_val.ToLower()).FirstOrDefault().item_id; break; } case "p": //occupation { var _new_val = _val.Trim(); if (string.IsNullOrEmpty(_new_val)) //nil { break; } if (_emp.objOccupation == null) { _emp.objOccupation = new MTOMS.ic.occupationC(); } _emp.objOccupation.occupation_other = _new_val; break; } case "q": //education level { var _new_val = _val.Trim(); if (string.IsNullOrEmpty(_new_val)) //nil { _emp.marital_type_id = xso.xso.DATA_COMMON.Values.Where(j => j.item_section == xso.em.common_section.marital_type & j.item_name.ToLower() == "single").FirstOrDefault().item_id; break; } _emp.marital_type_id = xso.xso.DATA_COMMON.Values.Where(j => j.item_section == xso.em.common_section.marital_type & j.item_name.ToLower() == _new_val.ToLower()).FirstOrDefault().item_id; break; } case "r": //baptised year { var _new_val = _val.Trim(); if (string.IsNullOrEmpty(_new_val)) //nil { break; } if (_emp.objBaptism == null) { _emp.objBaptism = new MTOMS.ic.baptismC(); } _emp.objBaptism.bapt_yr = _new_val.ToInt16(); _emp.baptismal_type_id = 125; break; } case "s": //baptised place { var _new_val = _val.Trim().ToProperCase(); if (string.IsNullOrEmpty(_new_val)) //nil { break; } if (_emp.objBaptism == null) { _emp.objBaptism = new MTOMS.ic.baptismC(); } _emp.objBaptism.bapt_place = _new_val; _emp.baptismal_type_id = 125; break; } case "t": //baptised pastor { var _new_val = _val.Trim().ToProperCase(); if (string.IsNullOrEmpty(_new_val)) //nil { break; } if (_emp.objBaptism == null) { _emp.objBaptism = new MTOMS.ic.baptismC(); } _emp.objBaptism.bapt_pastor = _new_val; _emp.baptismal_type_id = 125; break; } } #endregion } catch (Exception ex) { dbm.ErrorMessage(ex.Message, "jk"); dbm.MessageNormal(_alpha, "er"); return(false); } return(true); }
void LoadPictureGrid() { try { if (view_data.Data == null || view_data.Data.Count() == 0) { return; } int record_count = 0; iGRow _row = null; iGrid1.BeginUpdate(); iGrid1.Rows.Clear(); var _nlist = (from v in view_data.Data orderby v.HasPic descending, v.gender_id select v); int y = 0; for (int j = 0; j < 30; j++) { iGrid1.Cols[j].Visible = false; } record_count = _nlist.Count(); bool _passed_first = false; ic.memberC _mem = null; iGCell _cell = null; while (y < _nlist.Count()) { _row = iGrid1.Rows.Add(); _row.Height = 150; for (int j = 0; j < m_ret_cols; j++) { if (y == record_count) { break; } _mem = _nlist.ElementAt(y); if (_mem == null) { continue; } if (!_passed_first) { if (!iGrid1.Cols[j].Visible) { iGrid1.Cols[j].Visible = true; } } _cell = _row.Cells[j]; if (_mem.objPicture != null) { _cell.CustomDrawFlags |= iGCustomDrawFlags.Foreground; _cell.Value = _mem.objPicture.SmallLabelPicture; _cell.AuxValue = _mem.mem_id; iGrid1.Cols[j].Width = 103; } else { _cell.CustomDrawFlags = iGCustomDrawFlags.None; _cell.TextFormatFlags = iGStringFormatFlags.WordWrap; _cell.TextAlign = iGContentAlignment.MiddleCenter; if (_mem.mem_title_id > 0) { _cell.Value = string.Format("{0} {1}", xso.xso.DATA_COMMON[_mem.mem_title_id].item_name, _mem.mem_name).ToProperCase(); } else { _cell.Value = string.Format("{0}", _mem.mem_name).ToProperCase(); } _cell.AuxValue = _mem.mem_id; _cell.BackColor = Color.Gainsboro; iGrid1.Cols[j].Width = 103; } y++; } _passed_first = true; } iGrid1.AutoResizeCols = false; iGrid1.EndUpdate(); } catch (Exception ex) { MessageBox.Show(ex.Message); } }