private void DataPortal_Fetch(Criteria criteria)
{
using (SqlConnection cn = new SqlConnection(Database.ConnectionString))
{
cn.Open();
using (SqlCommand cm = cn.CreateCommand())
{
cm.CommandType = CommandType.StoredProcedure;
cm.CommandText = "[app_admin].[church_get]";
using (SafeDataReader dr = new SafeDataReader(cm.ExecuteReader()))
{
dr.Read();
_id = dr.GetInt32("id");
_name = dr.GetString("name");
_address = dr.GetString("address1");
_address2 = dr.GetString("address2");
_city = dr.GetString("city");
_state = dr.GetString("state");
_zipcode = dr.GetString("zipcode");
_telephone = dr.GetString("telephone");
_taxid = dr.GetString("tax_id");
_signer = dr.GetString("signer");
_fax = dr.GetString("fax");
_updateby = dr.GetString("update_by");
_username = Dothan.ApplicationContext.User.Identity.Name;
dr.GetBytes("lastchanged", 0, _lastchanged, 0, 8);
MarkOld();
}
}
}
}
private void DataPortal_Fetch(Criteria criteria)
{
using (SqlConnection cn = new SqlConnection(Database.ConnectionString))
{
cn.Open();
using (SqlCommand cm = cn.CreateCommand())
{
cm.CommandType = CommandType.StoredProcedure;
cm.CommandText = "[app_cell].[report_get]";
cm.Parameters.AddWithValue("@id", criteria.code);
using (SafeDataReader dr = new SafeDataReader(cm.ExecuteReader()))
{
dr.Read();
_id = dr.GetInt32("Id");
_cellcode = dr.GetInt32("cell_code");
_cellname = dr.GetString("CellName");
_regdate = dr.GetSmartDate("reg_date", _regdate.EmptyIsMin);
_celldate = dr.GetSmartDate("cell_date", _celldate.EmptyIsMin);
_newmember = dr.GetString("new_member");
_leader = dr.GetString("leader");
_cellplace = dr.GetString("cell_place");
_prayer = dr.GetString("prayer");
_memo = dr.GetString("memo");
_request = dr.GetString("Request");
_attfamily = dr.GetInt32("atten_family_count");
_attendence = dr.GetInt32("atten_count");
_createby = dr.GetString("create_by");
_level1 = dr.GetString("cell_leader");
_level2 = dr.GetString("cell_leader2");
dr.GetBytes("Lastchanged", 0, _lastchanged, 0, 8);
}
}
}
}
private void DataPortal_Fetch(Criteria criteria)
{
using (SqlConnection cn = new SqlConnection(Database.ConnectionString))
{
cn.Open();
using (SqlCommand cm = cn.CreateCommand())
{
cm.CommandType = CommandType.StoredProcedure;
cm.CommandText = "[app_admin].[user_get]";
cm.Parameters.AddWithValue("@id", criteria.Id);
using (SafeDataReader dr = new SafeDataReader(cm.ExecuteReader()))
{
dr.Read();
_id = dr.GetInt32("id");
_username = dr.GetString("username");
_password = dr.GetString("password");
_regdate = dr.GetSmartDate("regdate");
_lastlogin = dr.GetSmartDate("lastlogin");
_name = dr.GetString("name");
_email = dr.GetString("email");
_roleList = dr.GetString("roles").TrimEnd(',');
_updateBy = dr.GetString("update_by");
_editor = Dothan.ApplicationContext.User.Identity.Name;
dr.GetBytes("lastchanged", 0, _lastchanged, 0, 8);
}
}
}
}
private void DataPortal_Fetch(Criteria criteria)
{
using (SqlConnection cn = new SqlConnection(Database.ConnectionString))
{
cn.Open();
using (SqlCommand cm = cn.CreateCommand())
{
cm.CommandType = CommandType.StoredProcedure;
cm.CommandText = "[app_member].[visit_get]";
cm.Parameters.AddWithValue("@id", criteria.Id);
using (SafeDataReader dr = new SafeDataReader(cm.ExecuteReader()))
{
dr.Read();
_id = dr.GetInt32("id");
_visittype = dr.GetInt32("visittype");
_visitdate = dr.GetSmartDate("visitdate", _visitdate.EmptyIsMin);
_pastor = dr.GetString("pastor");
_content = dr.GetString("contents");
_attendent = dr.GetString("attendent");
_recorder = dr.GetString("create_by");
_bible = dr.GetString("bible");
_song = dr.GetString("song");
_memberid = dr.GetInt32("memberid");
_fullname = string.Format("{0}{1}", dr.GetString("last_name"), dr.GetString("first_name"));
_username = Dothan.ApplicationContext.User.Identity.Name;
dr.GetBytes("lastChanged", 0, _lastchanged, 0, 8);//Retrived to enable update 031317
}
}
}
}
private void DataPortal_Fetch(Criteria criteria)
{
using (SqlConnection cn = new SqlConnection(Database.ConnectionString))
{
cn.Open();
using (SqlCommand cm = cn.CreateCommand())
{
cm.CommandType = CommandType.StoredProcedure;
cm.CommandText = "app_donate.donatemember_get";
cm.Parameters.AddWithValue("@id", criteria.Id);
using (SafeDataReader dr = new SafeDataReader(cm.ExecuteReader()))
{
dr.Read();
_id = dr.GetInt32("id");
_name = dr.GetString("name");
_enLastName = dr.GetString("en_last");
_enFirstName = dr.GetString("en_first");
_addressId = dr.GetInt32("address_id");
_memberId = dr.GetInt32("member_id");
_memo = dr.GetString("memo");
_regdate = dr.GetSmartDate("regdate");
dr.GetBytes("lastchanged", 0, _lastchanged, 0, 8);
}
}
}
}
private void DataPortal_Fetch(Criteria criteria)
{
using (SqlConnection cn = new SqlConnection(Database.ConnectionString))
{
cn.Open();
using (SqlCommand cm = cn.CreateCommand())
{
cm.CommandType = CommandType.StoredProcedure;
cm.CommandText = "app_member.comment_get";
cm.Parameters.AddWithValue("@id", criteria.Id);
using (SafeDataReader dr = new SafeDataReader(cm.ExecuteReader()))
{
dr.Read();
_id = dr.GetInt32("id");
_comment = dr.GetString("comment");
_regdate = dr.GetSmartDate("regdate", _regdate.EmptyIsMin);
_updatedate = dr.GetSmartDate("update_date", _updatedate.EmptyIsMin);
_updateby = dr.GetString("update_by");
_memberid = dr.GetInt32("memberid");
_membername = dr.GetString("membername");
_username = Dothan.ApplicationContext.User.Identity.Name;
dr.GetBytes("lastChanged", 0, _lastchanged, 0, 8);
}
}
}
}
private JobType(SafeDataReader dr)
{
MarkAsChild();
_idSet = true;
_id = dr.GetInt32("id");
_name = dr.GetString("Name");
dr.GetBytes("lastchanged", 0, _lastchanged, 0, 8);
_username = Dothan.ApplicationContext.User.Identity.Name;
MarkOld();
}
private SubDivision(SafeDataReader dr)
{
MarkAsChild();
_id = dr.GetInt32("id");
_name = dr.GetString("name");
_parentId = dr.GetInt32("parent_id");
_username = Dothan.ApplicationContext.User.Identity.Name;
_updateBy = dr.GetString("update_by");
dr.GetBytes("lastchanged", 0, _lastchanged, 0, 8);
MarkOld();
}
internal MemberFellowship(SafeDataReader dr)
{
MarkAsChild();
_id = dr.GetInt32("id");
_fellowship = dr.GetString("fellowship");
_enddate = dr.GetSmartDate("enddate", _enddate.EmptyIsMin);
_startdate = dr.GetSmartDate("startdate", _startdate.EmptyIsMin);
dr.GetBytes("lastchanged", 0, _lastchanged, 0, 8);
_username = Dothan.ApplicationContext.User.Identity.Name;
MarkOld();
}
private MinistryRole(SafeDataReader dr)
{
MarkAsChild();
_idSet = true;
_code = dr.GetInt32("code");
_name = dr.GetString("name");
_default = dr.GetBoolean("isdefault");
_updateBy = dr.GetString("create_by");
_username = Dothan.ApplicationContext.User.Identity.Name;
dr.GetBytes("lastchanged", 0, _lastchanged, 0, 8);
MarkOld();
}
private DonateType(SafeDataReader dr)
{
MarkAsChild();
_idSet = true;
_code = dr.GetInt32("code");
_name = dr.GetString("name");
_parentcode = dr.GetInt32("parent_code");
_status = dr.GetBoolean("status");
dr.GetBytes("lastchanged", 0, _lastchanged, 0, 8);
_username = Dothan.ApplicationContext.User.Identity.Name;
MarkOld();
}
private CourseMember(SafeDataReader dr)
{
MarkAsChild();
_id = dr.GetInt32("id");
_idSet = true;
_courseid = dr.GetInt32("course_code");
_graduate = dr.GetSmartDate("graduated", _graduate.EmptyIsMin);
_info = MemberInfoBase.Get(dr);
dr.GetBytes("lastchanged", 0, _lastchanged, 0, 8);
_username = Dothan.ApplicationContext.User.Identity.Name;
MarkOld();
}
private FellowshipMember(SafeDataReader dr)
{
MarkAsChild();
_id = dr.GetInt32("id");
_idSet = true;
_fellowshipcode = dr.GetInt32("fellowship_code");
_updateby = dr.GetString("update_by");
_startdate = dr.GetSmartDate("startdate", _startdate.EmptyIsMin);
_enddate = dr.GetSmartDate("enddate", _enddate.EmptyIsMin);
_username = Dothan.ApplicationContext.User.Identity.Name;
dr.GetBytes("lastchanged", 0, _lastchanged, 0, 8);
_info = MemberInfoBase.Get(dr);
MarkOld();
}
private Cell(SafeDataReader dr)
{
MarkAsChild();
_codeSet = true;
_code = dr.GetInt32("code");
_parerntCode = dr.GetInt32("parent_code");
_name = dr.GetString("name");
_createDate = dr.GetSmartDate("create_date");
_assigned = dr.GetInt32("assigned");
_leader = dr.GetString("leader");
_status = dr.GetString("row_status");
_username = Dothan.ApplicationContext.User.Identity.Name;
dr.GetBytes("lastchanged", 0, _lastchanged, 0, 8);
MarkOld();
}
private Ministry(SafeDataReader dr)
{
MarkAsChild();
_idSet = true;
_id = dr.GetInt32("code");
_parentcode = dr.GetInt32("parent_code");
_name = dr.GetString("name");
_assigned = dr.GetInt32("total_assign");
_status = dr.GetString("row_Status");
_updateby = dr.GetString("update_by");
CreateDate = dr.GetSmartDate("create_date", false).ToString();
dr.GetBytes("lastchanged", 0, _lastchanged, 0, 8);
MarkOld();
_username = Dothan.ApplicationContext.User.Identity.Name;
}
private StatusType(SafeDataReader dr)
{
MarkAsChild();
_id = dr.GetInt32("id");
_name = dr.GetString("name");
_isActive = dr.GetBoolean("is_active");
_updateby = dr.GetString("update_by");
dr.GetBytes("lastchanged", 0, _lastchanged, 0, 8);
_username = Dothan.ApplicationContext.User.Identity.Name;
_idSet = true;
MarkOld();
}
private CellRole(SafeDataReader dr)
{
MarkAsChild();
_idSet = true;
_code = dr.GetInt32("code");
_name = dr.GetString("name");
_multipleAssign = dr.GetBoolean("multiple_assign");
_level = dr.GetInt32("levels");
_default = dr.GetBoolean("default_level");
_updateBy = dr.GetString("update_by");
_username = Dothan.ApplicationContext.User.Identity.Name;
dr.GetBytes("lastchanged", 0, _lastchanged, 0, 8);
MarkOld();
}
private Fellowship(SafeDataReader dr)
{
MarkAsChild();
_idSet = true;
_id = dr.GetInt32("code");
_name = dr.GetString("name");
_parentcode = dr.GetInt32("parent_code");
_updateby = dr.GetString("update_by");
_status = dr.GetString("row_status");
Sort = dr.GetString("sort");
dr.GetBytes("lastchanged", 0, _lastchanged, 0, 8);
_username = Dothan.ApplicationContext.User.Identity.Name;
MarkOld();
}
internal MemberCell(SafeDataReader dr)
{
MarkAsChild();
_id = dr.GetInt32("id");
_role = dr.GetInt32("role_code");
_cellname = dr.GetString("cellname");
_enddate = dr.GetSmartDate("enddate", _enddate.EmptyIsMin);
_startdate = dr.GetSmartDate("startdate", _startdate.EmptyIsMin);
_rolename = dr.GetString("rolename");
_username = Dothan.ApplicationContext.User.Identity.Name;
dr.GetBytes("lastchanged", 0, _lastchanged, 0, 8);
MarkOld();
}
private MemberMinistry(SafeDataReader dr)
{
MarkAsChild();
_id = dr.GetInt32("id");
_idSet = true;
_startdate = dr.GetSmartDate("startdate");
_enddate = dr.GetSmartDate("enddate");
_ministrycode = dr.GetInt32("ministry_code");
_role = dr.GetInt32("role_code");
_updateby = dr.GetString("update_by");
_username = Dothan.ApplicationContext.User.Identity.Name;
_memberid = dr.GetInt32("memberid");;
dr.GetBytes("lastchanged", 0, _lastchanged, 0, 8);
MarkOld();
}
private Donate(SafeDataReader dr)
{
MarkAsChild();
_donateid = dr.GetInt32("donate_id");
_name = dr.GetString("name");
_memberid = dr.GetInt32("memberid");
_id = dr.GetInt32("no");
_paidtype = Convert.ToInt32(dr.GetByte("pay_code"));
_amount = dr.GetDecimal("amount");
_donatecode = dr.GetInt32("donate_code");
_regdate = dr.GetSmartDate("donate_date", _regdate.EmptyIsMin);
_username = (Dothan.ApplicationContext.User as Dothan.Library.Security.PTPrincipal).UserName;
dr.GetBytes("lastchanged", 0, _lastchanged, 0, 8);
_memo = dr.GetString("memo");//v3.3.4 Display memo
_idset = true;
MarkOld();
}
private void DataPortal_Fetch(Criteria criteria)
{
using (SqlConnection cn = new SqlConnection(Database.ConnectionString))
{
cn.Open();
using (SqlCommand cm = cn.CreateCommand())
{
cm.CommandType = CommandType.StoredProcedure;
cm.CommandText = "app_member.member_get";
cm.Parameters.AddWithValue("@id", criteria.code);
using (SafeDataReader dr = new SafeDataReader(cm.ExecuteReader()))
{
dr.Read();
_id = dr.GetInt32("id");
_firstName = dr.GetString("first_name");
_lastName = dr.GetString("last_name");
_enFirstName = dr.GetString("en_first_name");
_enLastName = dr.GetString("en_last_name");
_email = dr.GetString("email");
_cell = dr.GetString("cell");
_addressId = dr.GetInt32("address_id");
_sex = dr.GetBoolean("sex");
_marriage = dr.GetBoolean("married");
_regDate = dr.GetSmartDate("regdate", _regDate.EmptyIsMin);
_statusDate = dr.GetSmartDate("statuschanged", _statusDate.EmptyIsMin);
_status = dr.GetInt32("statuscode");
_familyName = dr.GetString("familyName");
_familyCode = dr.GetInt32("family_code");
_baptismId = dr.GetInt32("baptism_id");
_baptismyear = dr.GetSmartDate("baptism_year");
_birthday = dr.GetSmartDate("birthday", _birthday.EmptyIsMin);
_entrytypeId = dr.GetInt32("entrytype");
_job = dr.GetString("job");
_work = dr.GetString("work_phone");
_cellName = dr.GetString("cellname");
_subDivId = dr.GetInt32("subdiv_id");
_jobtype = dr.GetInt32("jobtype");
_fellowshipName = dr.GetString("fellowshipname");
_relationshipId = (int)dr.GetByte("family_relationship");
_ministryName = dr.GetString("ministry");
dr.GetBytes("lastChanged", 0, _lastchanged, 0, 8);
}
}
_username = Dothan.ApplicationContext.User.Identity.Name;
}
}
public Course(SafeDataReader dr)
{
MarkAsChild();
_idSet = true;
_code = dr.GetInt32("code");
_parentcode = dr.GetInt32("parent_code");
_name = dr.GetString("name");
_active = dr.GetString("row_status");
_total = dr.GetInt32("total");
Sort = dr.GetString("sort");
_regdate = dr.GetSmartDate("regdate", _regdate.EmptyIsMin);
_regdate.FormatString = Configurations.DateFomating;
dr.GetBytes("lastchanged", 0, _lastchanged, 0, 8);
_username = Dothan.ApplicationContext.User.Identity.Name;
MarkOld();
}
/// <summary>
/// Returns the Bytes stored in a binary column.
/// </summary>
/// <param name="reader">The reader.</param>
/// <param name="columnName">The column name.</param>
/// <returns>Bytes Stored in a column.</returns>
public static byte[] GetBytes(SafeDataReader reader, string columnName)
{
var buffer = new byte[1024];
long fieldOffset = 0;
using (var stream = new MemoryStream())
{
long bytesRead;
while ((bytesRead = reader.GetBytes(columnName, fieldOffset, buffer, 0, buffer.Length)) > 0)
{
var actualRead = new byte[bytesRead];
Buffer.BlockCopy(buffer, 0, actualRead, 0, (int)bytesRead);
stream.Write(actualRead, 0, actualRead.Length);
fieldOffset += bytesRead;
}
return(stream.ToArray());
}
}
private CellReportDetail(SafeDataReader dr, bool idSet)
{
MarkAsChild();
_idset = idSet;
FetchData(dr);
if (idSet)
{
_id = dr.GetInt32("id");
_attendence = dr.GetBoolean("Attendance");
_memo = dr.GetString("Memo");
_reason = dr.GetString("Reason");
_regdate = dr.GetSmartDate("RegDate", _regdate.EmptyIsMin);
_serviceTimePlaceID = dr.GetInt32("service_time_place_id");
dr.GetBytes("Lastchanged", 0, _lastchanged, 0, 8);
MarkOld();
}
else
{
_regdate.Date = DateTime.Today;
}
}
private void DataPortal_Fetch(Criteria criteria)
{
using (SqlConnection cn = new SqlConnection(Database.ConnectionString))
{
cn.Open();
using (SqlCommand cm = cn.CreateCommand())
{
cm.CommandType = CommandType.StoredProcedure;
cm.CommandText = "app_donate.donatebook_get";
cm.Parameters.AddWithValue("@id", criteria.Id);
using (SafeDataReader dr = new SafeDataReader(cm.ExecuteReader()))
{
dr.Read();
_id = dr.GetInt32("id");
_total = dr.GetDecimal("total");
_detail = dr.GetString("detail");
_hundred = dr.GetInt32("hundred");
_fifty = dr.GetInt32("fifty");
_twenty = dr.GetInt32("twenty");
_ten = dr.GetInt32("ten");
_five = dr.GetInt32("five");
_one = dr.GetInt32("one");
_coins = dr.GetDecimal("coins");
_checks = dr.GetDecimal("checks");
_regdate = dr.GetSmartDate("regdate");
_checkcnt = dr.GetInt32("checkcnt");
_donate_code = dr.GetInt32("donate_code");
_createby = dr.GetString("create_by");
_typename = dr.GetString("typename");
_username = Dothan.ApplicationContext.User.Identity.Name;
dr.GetBytes("lastchanged", 0, _lastchanged, 0, 8);
dr.NextResult();
_donates = Donates.Get(dr);
}
MarkOld();
}
}
}
private void DataPortal_Fetch(Criteria criteria)
{
using (SqlConnection cn = new SqlConnection(Database.ConnectionString))
{
cn.Open();
using (SqlCommand cm = cn.CreateCommand())
{
cm.CommandType = CommandType.StoredProcedure;
cm.CommandText = "[app_common].[address_get]";
cm.Parameters.AddWithValue("@id", criteria.ID);
using (SafeDataReader dr = new SafeDataReader(cm.ExecuteReader()))
{
dr.Read();
_id = dr.GetInt32("id");
_address = dr.GetString("address");
_city = dr.GetString("city");
_statecode = dr.GetString("statecode");
_zipcode = dr.GetString("zipcode");
_home = dr.GetString("home");
dr.GetBytes("lastchanged", 0, _lastchanged, 0, 8);
}
}
}
}
