public Result addMember(string firstName, string lastName, DateTime birthDate, string gender, bool isUnitMember, string priesthood, int unitId)
{
firstName = firstName.Trim();
lastName = lastName.Trim();
MySqlCommand cmd = new MySqlCommand("insert into lds_member (first_name, last_name, birthdate, unit_id, created_by, member_record, active, restricted, gender, unit_member) values " +
"(@first_name, @last_name, @birthdate, @unit_id, now(), null, 1, 0, @gender, @unit_member)");
cmd.Parameters.AddWithValue("first_name", firstName);
cmd.Parameters.AddWithValue("last_name", lastName);
cmd.Parameters.AddWithValue("birthdate", common.convertDate(birthDate, true));
cmd.Parameters.AddWithValue("unit_id", unitId);
cmd.Parameters.AddWithValue("gender", gender);
cmd.Parameters.AddWithValue("unit_member", common.convertBool(isUnitMember));
Result result = database.executeQuery(cmd);
if (result.Success)
{
if (priesthood != "0" && gender == "M")
{
result = new Priesthood().addPriesthood(result.Id, common.convertNumber(priesthood));
}
}
return(result);
}
public Result updateMember(int id, string firstName, string lastName, DateTime birthDate, string gender, bool isUnitMember, string priesthood, int unitId)
{
firstName = firstName.Trim();
lastName = lastName.Trim();
MySqlCommand cmd = new MySqlCommand("update lds_member set first_name = @first_name, last_name = @last_name, birthdate = @birthdate, gender = @gender, unit_member = @unit_member " +
" where id = @id and unit_id = @unit_id");
cmd.Parameters.AddWithValue("first_name", firstName);
cmd.Parameters.AddWithValue("last_name", lastName);
cmd.Parameters.AddWithValue("birthdate", common.convertDate(birthDate, true));
cmd.Parameters.AddWithValue("gender", gender);
cmd.Parameters.AddWithValue("unit_member", common.convertBool(isUnitMember));
cmd.Parameters.AddWithValue("id", id);
cmd.Parameters.AddWithValue("unit_id", unitId);
Result result = database.executeQuery(cmd);
if (result.Success)
{
result = new Priesthood().deletePriesthood(id);
if (priesthood != "0" && gender == "M" && result.Success)
{
result = new Priesthood().addPriesthood(id, common.convertNumber(priesthood));
}
}
return(result);
}
/// <summary>
/// File format: first;last;1982-12-23;M
/// first;last;1989-07-12;F
/// </summary>
/// <param name="file"></param>
/// <param name="unitId"></param>
/// <returns></returns>
public Result execute(StreamReader file, int unitId)
{
Result result = new Result(true);
int errors = 0;
if (file != null)
{
string line;
// Read the file and display it line by line.
while ((line = file.ReadLine()) != null)
{
string[] data = line.Split(',');
if (data.Length >= 4)
{
string firstName = data[1].Trim();
string lastName = data[0].Trim();
DateTime birthDate = common.convertDate(data[2].Trim(), true);
string gender = data[3].Trim();
int priesthood = 0;
if (data.Length > 4)
priesthood = common.convertNumber(data[4].Trim());
Member member = new Member().findMember(lastName, firstName, birthDate, gender, unitId);
if (member == null || member.Id == 0)
{
MySqlCommand cmd = new MySqlCommand("insert into lds_member (first_name, last_name, birthdate, unit_id, created_by, active, restricted, gender, unit_member) values " +
"(@first_name, @last_name, @birthdate, @unit_id, now(), 1, 0, @gender, 1)");
cmd.Parameters.AddWithValue("first_name", firstName);
cmd.Parameters.AddWithValue("last_name", lastName);
cmd.Parameters.AddWithValue("birthdate", birthDate);
cmd.Parameters.AddWithValue("unit_id", unitId);
cmd.Parameters.AddWithValue("gender", gender);
result = database.executeQuery(cmd);
if (result.Success)
{
if (gender == "M" && priesthood != 0)
{
result = new Priesthood().addPriesthood(result.Id, priesthood);
if (!result.Success)
errors++;
}
}
else
errors++;
}
else
{
int priestH = new Priesthood().getMemberPriesthood(member.Id);
if (priestH != priesthood)
{
result = new Priesthood().deletePriesthood(member.Id);
if (result.Success)
{
result = new Priesthood().addPriesthood(member.Id, priesthood);
if (!result.Success)
errors++;
}
else
errors++;
}
}
}
}
file.Close();
}
if (errors > 0)
result.Success = false;
return result;
}
/// <summary>
/// File format: first;last;1982-12-23;M
/// first;last;1989-07-12;F
/// </summary>
/// <param name="file"></param>
/// <param name="unitId"></param>
/// <returns></returns>
public Result execute(StreamReader file, int unitId)
{
Result result = new Result(true);
int errors = 0;
if (file != null)
{
string line;
// Read the file and display it line by line.
while ((line = file.ReadLine()) != null)
{
string[] data = line.Split(',');
if (data.Length >= 4)
{
string firstName = data[1].Trim();
string lastName = data[0].Trim();
DateTime birthDate = common.convertDate(data[2].Trim(), true);
string gender = data[3].Trim();
int priesthood = 0;
if (data.Length > 4)
{
priesthood = common.convertNumber(data[4].Trim());
}
Member member = new Member().findMember(lastName, firstName, birthDate, gender, unitId);
if (member == null || member.Id == 0)
{
MySqlCommand cmd = new MySqlCommand("insert into lds_member (first_name, last_name, birthdate, unit_id, created_by, active, restricted, gender, unit_member) values " +
"(@first_name, @last_name, @birthdate, @unit_id, now(), 1, 0, @gender, 1)");
cmd.Parameters.AddWithValue("first_name", firstName);
cmd.Parameters.AddWithValue("last_name", lastName);
cmd.Parameters.AddWithValue("birthdate", birthDate);
cmd.Parameters.AddWithValue("unit_id", unitId);
cmd.Parameters.AddWithValue("gender", gender);
result = database.executeQuery(cmd);
if (result.Success)
{
if (gender == "M" && priesthood != 0)
{
result = new Priesthood().addPriesthood(result.Id, priesthood);
if (!result.Success)
{
errors++;
}
}
}
else
{
errors++;
}
}
else
{
int priestH = new Priesthood().getMemberPriesthood(member.Id);
if (priestH != priesthood)
{
result = new Priesthood().deletePriesthood(member.Id);
if (result.Success)
{
result = new Priesthood().addPriesthood(member.Id, priesthood);
if (!result.Success)
{
errors++;
}
}
else
{
errors++;
}
}
}
}
}
file.Close();
}
if (errors > 0)
{
result.Success = false;
}
return(result);
}
public Result updateMember(int id, string firstName, string lastName, DateTime birthDate, string gender, bool isUnitMember, string priesthood, int unitId)
{
firstName = firstName.Trim();
lastName = lastName.Trim();
MySqlCommand cmd = new MySqlCommand("update lds_member set first_name = @first_name, last_name = @last_name, birthdate = @birthdate, gender = @gender, unit_member = @unit_member " +
" where id = @id and unit_id = @unit_id");
cmd.Parameters.AddWithValue("first_name", firstName);
cmd.Parameters.AddWithValue("last_name", lastName);
cmd.Parameters.AddWithValue("birthdate", common.convertDate(birthDate, true));
cmd.Parameters.AddWithValue("gender", gender);
cmd.Parameters.AddWithValue("unit_member", common.convertBool(isUnitMember));
cmd.Parameters.AddWithValue("id", id);
cmd.Parameters.AddWithValue("unit_id", unitId);
Result result = database.executeQuery(cmd);
if (result.Success)
{
result = new Priesthood().deletePriesthood(id);
if (priesthood != "0" && gender == "M" && result.Success)
result = new Priesthood().addPriesthood(id, common.convertNumber(priesthood));
}
return result;
}
public Result addMember(string firstName, string lastName, DateTime birthDate, string gender, bool isUnitMember, string priesthood, int unitId)
{
firstName = firstName.Trim();
lastName = lastName.Trim();
MySqlCommand cmd = new MySqlCommand("insert into lds_member (first_name, last_name, birthdate, unit_id, created_by, member_record, active, restricted, gender, unit_member) values " +
"(@first_name, @last_name, @birthdate, @unit_id, now(), null, 1, 0, @gender, @unit_member)");
cmd.Parameters.AddWithValue("first_name", firstName);
cmd.Parameters.AddWithValue("last_name", lastName);
cmd.Parameters.AddWithValue("birthdate", common.convertDate(birthDate, true));
cmd.Parameters.AddWithValue("unit_id", unitId);
cmd.Parameters.AddWithValue("gender", gender);
cmd.Parameters.AddWithValue("unit_member", common.convertBool(isUnitMember));
Result result = database.executeQuery(cmd);
if (result.Success)
{
if (priesthood != "0" && gender == "M")
result = new Priesthood().addPriesthood(result.Id, common.convertNumber(priesthood));
}
return result;
}