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);
}
}
