/// <summary>
/// Converts a <see cref="SmartDate"/> to a <see cref="NullableDateTime"/>.
/// </summary>
/// <param name="smartDate">A <see cref="SmartDate"/> instance object.</param>
/// <returns>A <see cref="NullableDateTime"/> instance object.</returns>
public static NullableDateTime ToNullableDateTime(SmartDate smartDate)
{
if (smartDate.IsEmpty)
return new NullableDateTime();
else
return new NullableDateTime(smartDate.Date);
}
/// <summary>
/// Converts a <see cref="SmartDate"/> to a <see cref="DateTime"/>.
/// </summary>
/// <param name="smartDate"></param>
/// <returns>A new <see cref="System.DateTime"/> instance object.</returns>
public static DateTime ToDateTime(SmartDate smartDate)
{
if (smartDate.IsEmpty)
throw new Exception("Cannot convert an empty SmartDate to a DateTime");
else
return new DateTime(smartDate.Date.Ticks);
}
private Family(SafeDataReader dr)
{
MarkAsChild();
_memberid = dr.GetInt32("id");
_firstname = dr.GetString("first_name");
_lastname = dr.GetString("last_name");
_en_firstname = dr.GetString("en_first_name");
_en_lastname = dr.GetString("en_last_name");
_sex = (int)dr.GetByte("sex");
_marriage = (int)dr.GetByte("married");
_baptismcode = dr.GetInt32("baptism_memberid");
_baptismyear = dr.GetSmartDate("baptism_year");
_birth = dr.GetSmartDate("birthday");
_cell = dr.GetString("cell");
_job = dr.GetString("job");
_familycode = dr.GetInt32("family_memberid");
_baptism = dr.GetString("baptism_name");
_subdiv = dr.GetString("SubDivisionName");
_fellowshipcode = dr.GetInt32("fellowship_memberid");
_work = dr.GetString("work");
_age = dr.GetInt32("age");
_subdivisioncode = dr.GetInt32("subdiv_memberid");
_status = dr.GetInt32("statusCode");
_entrytype = dr.GetInt32("entrytype");
_relationship = (int)dr.GetByte("family_relationship");
MarkOld();
}
internal StatusLog(SafeDataReader dr)
{
_id = dr.GetInt32("no");
_memo = dr.GetString("memo");
_eventlog = dr.GetString("eventlog");
_regdate = dr.GetSmartDate("regdate", _regdate.EmptyIsMin);
}
private void FetchObject(SafeDataReader dr)
{
_id = dr.GetGuid("Id");
_entryId = dr.GetGuid("EntryId");
_juryid = dr.GetGuid("Juryid");
_scoresc = dr.GetInt32("ScoreSC");
_scoreid = dr.GetInt32("ScoreID");
_scoreil = dr.GetInt32("ScoreIL");
_scorere = dr.GetInt32("ScoreRE");
_scorecomposite = dr.GetDouble("ScoreComposite");
_feedbackStrong = dr.GetString("FeedbackStrong");
_feedbackWeak = dr.GetString("FeedbackWeak");
_flag = dr.GetString("Flag");
_flagOthers = dr.GetString("FlagOthers");
_isRecuse = dr.GetBoolean("IsRecuse");
_isSubmitted = dr.GetBoolean("IsSubmitted");
_isAdminRecuse = dr.GetBoolean("IsAdminRecuse");
_recuseRemarks = dr.GetString("RecuseRemarks");
_additionalComments = dr.GetString("AdditionalComments");
_isAdvancement = dr.GetBoolean("IsAdvancement");
_dateSubmitted = dr.GetSmartDate("DateSubmitted", _dateSubmitted.EmptyIsMin);
_dateCreated = dr.GetSmartDate("DateCreated", _dateCreated.EmptyIsMin);
_round = dr.GetString("Round");
_Nomination = dr.GetString("Nomination");
}
private void FetchObject(SafeDataReader dr)
{
_id = dr.GetGuid("Id");
_tableCount = dr.GetInt32("TableCount");
_seatCount = dr.GetInt32("SeatCount");
_shipping = dr.GetString("Shipping");
_payCompany = dr.GetString("PayCompany");
_payAddress1 = dr.GetString("PayAddress1");
_payAddress2 = dr.GetString("PayAddress2");
_payCity = dr.GetString("PayCity");
_payPostal = dr.GetString("PayPostal");
_payCountry = dr.GetString("PayCountry");
_payFirstname = dr.GetString("PayFirstname");
_payLastname = dr.GetString("PayLastname");
_payContact = dr.GetString("PayContact");
_payEmail = dr.GetString("PayEmail");
_paymentMethod = dr.GetString("PaymentMethod");
_status = dr.GetString("Status");
_payStatus = dr.GetString("PayStatus");
_isReminded = dr.GetInt32("IsReminded");
_lastSendPaymentReminderEmailDate = dr.GetSmartDate("LastSendPaymentReminderEmailDate", _lastSendPaymentReminderEmailDate.EmptyIsMin);
_amount = dr.GetDecimal("Amount");
_fee = dr.GetDecimal("Fee");
_feeShipping = dr.GetDecimal("FeeShipping");
_tax = dr.GetDecimal("Tax");
_amountReceived = dr.GetDecimal("AmountReceived");
_invoice = dr.GetString("Invoice");
_dateCreated = dr.GetSmartDate("DateCreated", _dateCreated.EmptyIsMin);
_dateModified = dr.GetSmartDate("DateModified", _dateModified.EmptyIsMin);
_datePaid = dr.GetSmartDate("Datepaid", _datePaid.EmptyIsMin);
_remarksPayment = dr.GetString("RemarksPayment");
}
internal MemberInfo(SafeDataReader dr)
{
_id = dr.GetInt32("id");
_ko_name = dr.GetString("ko_name");
_en_name = dr.GetString("en_name");
_email = dr.GetString("email");
_address = dr.GetString("address");
_city = dr.GetString("city");
_statecode = dr.GetString("statecode");
_zipcode = dr.GetString("zipcode");
_home = dr.GetString("home");
_age = dr.GetInt32("age");
if (dr.GetByte("sex") == 0)
{
_sex = Resources.Female.ToString();
}
else
{
_sex = Resources.Male.ToString();
}
_cell = dr.GetString("cell");
_regdate = dr.GetSmartDate("regdate");
_baptismname = dr.GetString("baptism_name");
_baptism_year = dr.GetSmartDate("baptism_year");
}
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_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_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);
}
}
}
}
public DeliveryBookCriteriaGet(SmartDate criteriaStartDate, SmartDate criteriaEndDate, string fullText)
{
var dateTypeList = CriteriaDateTypeList.GetCriteriaDateTypeList(false);
LoadProperty(DateTypeListProperty, dateTypeList);
LoadProperty(SelectedDateTypeIndexProperty, 0);
}
protected override void DataPortal_Insert()
{
using (var manager =
ObjectContextManager <RolodexEF.RolodexEntities> .GetManager(DataConnection.EFConnectionName, true))
{
var newCompany = new Companies();
newCompany.CompanyName = ReadProperty(CompanyNameProperty);
SmartDate added = ReadProperty(DateAddedProperty);
if (!added.IsEmpty)
{
newCompany.DateAdded = added.Date;
}
DataPortal.UpdateChild(ReadProperty(ContactsProperty), this, newCompany);
manager.ObjectContext.AddToCompanies(newCompany);
if (ReadProperty(CompanyIdProperty) == 0)
{
newCompany.PropertyChanged += newCompany_PropertyChanged;
}
DataPortal.UpdateChild(ReadProperty(ContactsProperty), this, newCompany);
manager.ObjectContext.SaveChanges();
LoadProperty(CompanyIdProperty, newCompany.CompanyId);
}
}
private void FetchObject(SafeDataReader dr)
{
_id = dr.GetGuid("Id");
_registrationId = dr.GetGuid("RegistrationId");
_remarks = dr.GetString("Remarks");
_dateCreated = dr.GetSmartDate("DateCreated", _dateCreated.EmptyIsMin);
}
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 FetchObject(SafeDataReader dr)
{
_id = dr.GetGuid("ID");
_type = dr.GetInt32("Type");
_data = dr.GetString("Data");
_date = dr.GetSmartDate("Date", _date.EmptyIsMin);
}
/// <summary>
/// Inserts a new IncomingRegister object in the database.
/// </summary>
/// <param name="registerId">The Register Id.</param>
/// <param name="registerDate">The Register Date.</param>
/// <param name="documentType">The Document Type.</param>
/// <param name="documentReference">The Document Reference.</param>
/// <param name="documentEntity">The Document Entity.</param>
/// <param name="documentDept">The Document Dept.</param>
/// <param name="documentClass">The Document Class.</param>
/// <param name="documentDate">The Document Date.</param>
/// <param name="subject">The Subject.</param>
/// <param name="senderName">The Sender Name.</param>
/// <param name="receptionDate">The Reception Date.</param>
/// <param name="routedTo">The Routed To.</param>
/// <param name="notes">The Notes.</param>
/// <param name="archiveLocation">The Archive Location.</param>
/// <param name="createDate">The Create Date.</param>
/// <param name="changeDate">The Change Date.</param>
public void Insert(out int registerId, SmartDate registerDate, string documentType, string documentReference, string documentEntity, string documentDept, string documentClass, SmartDate documentDate, string subject, string senderName, SmartDate receptionDate, string routedTo, string notes, string archiveLocation, SmartDate createDate, SmartDate changeDate)
{
registerId = -1;
using (var ctx = ConnectionManager <SqlConnection> .GetManager("InterwayDocs"))
{
using (var cmd = new SqlCommand("dbo.AddIncomingRegister", ctx.Connection))
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@RegisterId", registerId).Direction = ParameterDirection.Output;
cmd.Parameters.AddWithValue("@RegisterDate", registerDate.DBValue).DbType = DbType.Date;
cmd.Parameters.AddWithValue("@DocumentType", documentType).DbType = DbType.String;
cmd.Parameters.AddWithValue("@DocumentReference", documentReference).DbType = DbType.String;
cmd.Parameters.AddWithValue("@DocumentEntity", documentEntity).DbType = DbType.String;
cmd.Parameters.AddWithValue("@DocumentDept", documentDept).DbType = DbType.String;
cmd.Parameters.AddWithValue("@DocumentClass", documentClass).DbType = DbType.String;
cmd.Parameters.AddWithValue("@DocumentDate", documentDate.DBValue).DbType = DbType.Date;
cmd.Parameters.AddWithValue("@Subject", subject).DbType = DbType.String;
cmd.Parameters.AddWithValue("@SenderName", senderName).DbType = DbType.String;
cmd.Parameters.AddWithValue("@ReceptionDate", receptionDate.DBValue).DbType = DbType.Date;
cmd.Parameters.AddWithValue("@RoutedTo", routedTo).DbType = DbType.String;
cmd.Parameters.AddWithValue("@Notes", notes).DbType = DbType.String;
cmd.Parameters.AddWithValue("@ArchiveLocation", archiveLocation).DbType = DbType.String;
cmd.Parameters.AddWithValue("@CreateDate", createDate.DBValue).DbType = DbType.DateTime2;
cmd.Parameters.AddWithValue("@ChangeDate", changeDate.DBValue).DbType = DbType.DateTime2;
cmd.ExecuteNonQuery();
registerId = (int)cmd.Parameters["@RegisterId"].Value;
}
}
}
public void ShortForm_DayMonthYear_Small()
{
//presume month before day
var success = "1" + Separator + "3";
var fail = "4" + Separator + "2";
if (_dayBeforeMonth)
{
success = "3" + Separator + "1";
fail = "2" + Separator + "4";
}
if (_yearIsLast)
{
success += Separator + "5";
fail += Separator + "5";
}
else
{
success = "5" + Separator + success;
fail = "5" + Separator + fail;
}
var smartDate = new SmartDate(success);
Assert.AreEqual(new DateTime(2005, 1, 3).ToString("d"), smartDate);
try
{
smartDate = new SmartDate(fail);
Assert.AreEqual(new DateTime(2005, 4, 2).ToString("d"), smartDate);
}
catch (ArgumentException)
{
Assert.AreEqual(new DateTime(2015, 12, 31).ToString("d"), smartDate);
}
}
/// <summary>
/// Updates in the database all changes made to the InvoiceEdit object.
/// </summary>
/// <param name="invoiceId">The Invoice Id.</param>
/// <param name="invoiceNumber">The Invoice Number.</param>
/// <param name="customerId">The Customer Id.</param>
/// <param name="invoiceDate">The Invoice Date.</param>
/// <param name="changeDate">The Change Date.</param>
/// <param name="changeUser">The Change User.</param>
/// <param name="rowVersion">The Row Version.</param>
/// <returns>The updated Row Version.</returns>
public long Update(Guid invoiceId, string invoiceNumber, string customerId, SmartDate invoiceDate, SmartDate changeDate, int changeUser, long rowVersion)
{
using (var ctx = ConnectionManager <SqlConnection> .GetManager("Invoices"))
{
using (var cmd = new SqlCommand("dbo.UpdateInvoiceEdit", ctx.Connection))
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@InvoiceId", invoiceId).DbType = DbType.Guid;
cmd.Parameters.AddWithValue("@InvoiceNumber", invoiceNumber).DbType = DbType.String;
cmd.Parameters.AddWithValue("@CustomerId", customerId).DbType = DbType.StringFixedLength;
cmd.Parameters.AddWithValue("@InvoiceDate", invoiceDate.DBValue).DbType = DbType.Date;
cmd.Parameters.AddWithValue("@ChangeDate", changeDate.DBValue).DbType = DbType.DateTime2;
cmd.Parameters.AddWithValue("@ChangeUser", changeUser).DbType = DbType.Int32;
cmd.Parameters.AddWithValue("@RowVersion", rowVersion).DbType = DbType.Int64;
cmd.Parameters.Add("@NewRowVersion", SqlDbType.BigInt).Direction = ParameterDirection.Output;
var rowsAffected = cmd.ExecuteNonQuery();
if (rowsAffected == 0)
{
throw new DataNotFoundException("InvoiceEdit");
}
return((long)cmd.Parameters["@NewRowVersion"].Value);
}
}
}
/// <summary>
/// Updates in the database all changes made to the IncomingRegister object.
/// </summary>
/// <param name="registerId">The Register Id.</param>
/// <param name="registerDate">The Register Date.</param>
/// <param name="documentType">The Document Type.</param>
/// <param name="documentReference">The Document Reference.</param>
/// <param name="documentEntity">The Document Entity.</param>
/// <param name="documentDept">The Document Dept.</param>
/// <param name="documentClass">The Document Class.</param>
/// <param name="documentDate">The Document Date.</param>
/// <param name="subject">The Subject.</param>
/// <param name="senderName">The Sender Name.</param>
/// <param name="receptionDate">The Reception Date.</param>
/// <param name="routedTo">The Routed To.</param>
/// <param name="notes">The Notes.</param>
/// <param name="archiveLocation">The Archive Location.</param>
/// <param name="changeDate">The Change Date.</param>
public void Update(int registerId, SmartDate registerDate, string documentType, string documentReference, string documentEntity, string documentDept, string documentClass, SmartDate documentDate, string subject, string senderName, SmartDate receptionDate, string routedTo, string notes, string archiveLocation, SmartDate changeDate)
{
using (var ctx = ConnectionManager <SqlConnection> .GetManager("InterwayDocs"))
{
using (var cmd = new SqlCommand("dbo.UpdateIncomingRegister", ctx.Connection))
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@RegisterId", registerId).DbType = DbType.Int32;
cmd.Parameters.AddWithValue("@RegisterDate", registerDate.DBValue).DbType = DbType.Date;
cmd.Parameters.AddWithValue("@DocumentType", documentType).DbType = DbType.String;
cmd.Parameters.AddWithValue("@DocumentReference", documentReference).DbType = DbType.String;
cmd.Parameters.AddWithValue("@DocumentEntity", documentEntity).DbType = DbType.String;
cmd.Parameters.AddWithValue("@DocumentDept", documentDept).DbType = DbType.String;
cmd.Parameters.AddWithValue("@DocumentClass", documentClass).DbType = DbType.String;
cmd.Parameters.AddWithValue("@DocumentDate", documentDate.DBValue).DbType = DbType.Date;
cmd.Parameters.AddWithValue("@Subject", subject).DbType = DbType.String;
cmd.Parameters.AddWithValue("@SenderName", senderName).DbType = DbType.String;
cmd.Parameters.AddWithValue("@ReceptionDate", receptionDate.DBValue).DbType = DbType.Date;
cmd.Parameters.AddWithValue("@RoutedTo", routedTo).DbType = DbType.String;
cmd.Parameters.AddWithValue("@Notes", notes).DbType = DbType.String;
cmd.Parameters.AddWithValue("@ArchiveLocation", archiveLocation).DbType = DbType.String;
cmd.Parameters.AddWithValue("@ChangeDate", changeDate.DBValue).DbType = DbType.DateTime2;
var rowsAffected = cmd.ExecuteNonQuery();
if (rowsAffected == 0)
{
throw new DataNotFoundException("IncomingRegister");
}
}
}
}
private void FetchObject(SafeDataReader dr)
{
_id = dr.GetGuid("Id");
_type = dr.GetString("Type");
_salutation = dr.GetString("Salutation");
_firstName = dr.GetString("FirstName");
_lastName = dr.GetString("LastName");
_email = dr.GetString("Email");
_company = dr.GetString("Company");
_dietary = dr.GetString("Dietary");
_isJuryCocktail = dr.GetBoolean("IsJuryCocktail");
_isWelcomeDinner = dr.GetBoolean("IsWelcomeDinner");
_isGalaDinner = dr.GetBoolean("IsGalaDinner");
_respond = dr.GetBoolean("RSVPRespond");
_userData1 = dr.GetString("UserData1");
_userData2 = dr.GetString("UserData2");
_userData3 = dr.GetString("UserData3");
_userData4 = dr.GetString("UserData4");
_userData5 = dr.GetString("UserData5");
_isInvitingGalaDinner = dr.GetBoolean("IsInvitingGalaDinner");
_round1PanelID = dr.GetString("Round1PanelID");
_round2PanelID = dr.GetString("Round2PanelID");
_workflowStatus = dr.GetString("WorkflowStatus");
_location = dr.GetString("Location");
_dateCreated = dr.GetSmartDate("DateCreated", _dateCreated.EmptyIsMin);
_dateModified = dr.GetSmartDate("DateModified", _dateModified.EmptyIsMin);
}
private void FetchObject(SafeDataReader dr)
{
_id = dr.GetGuid("Id");
_registrationId = dr.GetGuid("RegistrationId");
_amount = dr.GetDecimal("Amount");
_fee = dr.GetDecimal("Fee");
_tax = dr.GetDecimal("Tax");
_grandAmount = dr.GetDecimal("GrandAmount");
_payGroupId = dr.GetGuid("PayGroupId");
_paymentMethod = dr.GetString("PaymentMethod");
_payCompany = dr.GetString("PayCompany");
_payAddress1 = dr.GetString("PayAddress1");
_payAddress2 = dr.GetString("PayAddress2");
_payCity = dr.GetString("PayCity");
_payPostal = dr.GetString("PayPostal");
_payCountry = dr.GetString("PayCountry");
_payFirstname = dr.GetString("PayFirstname");
_payLastname = dr.GetString("PayLastname");
_payContact = dr.GetString("PayContact");
_payStatus = dr.GetString("PayStatus");
_amountReceived = dr.GetDecimal("AmountReceived");
_isReminded = dr.GetBoolean("IsReminded");
_lastSendPaidEmailDate = dr.GetSmartDate("LastSendPaidEmailDate", _lastSendPaidEmailDate.EmptyIsMin);
_lastSendPaymentReminderEmailDate = dr.GetSmartDate("LastSendPaymentReminderEmailDate", _lastSendPaymentReminderEmailDate.EmptyIsMin);
_invoiceDate = dr.GetSmartDate("InvoiceDate", _invoiceDate.EmptyIsMin);
_dateCreated = dr.GetSmartDate("DateCreated", _dateCreated.EmptyIsMin);
_dateModified = dr.GetSmartDate("DateModified", _dateModified.EmptyIsMin);
_invoice = dr.GetString("Invoice");
}
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);
}
}
}
}
public void ExactDigits_Eight()
{
//presume month before day
var success = "1231";
var fail = "3011";
if (_dayBeforeMonth)
{
success = "3112";
fail = "1130";
}
if (_yearIsLast)
{
success += "2015";
fail += "2015";
}
else
{
success = "2015" + success;
fail = "2015" + fail;
}
var smartDate = new SmartDate(success);
Assert.AreEqual(new DateTime(2015, 12, 31).ToString("d"), smartDate);
try
{
smartDate = new SmartDate(fail);
Assert.Fail(fail + ": string value shouldn't be convertible to a date");
}
catch (ArgumentException)
{
Assert.AreEqual(new DateTime(2015, 12, 31).ToString("d"), smartDate);
}
}
private void FetchObject(SafeDataReader dr)
{
Id = dr.GetString("UserName");
PasswordHash = dr.GetString("Password");
IsActive = dr.GetBoolean("IsActive");
IsAutoUser = dr.GetBoolean("IsAutoUser");
MustChangePassword = dr.GetBoolean("MustChangePassword");
FkUserprofile = dr.GetInt32("fk_UserProfile");
Email = dr.GetString("Email");
EmailConfirmed = dr.GetBoolean("EmailConfirmed");
PhoneNumber = dr.GetString("PhoneNumber");
PhoneNumberConfirmed = dr.GetBoolean("PhoneNumberConfirmed");
_createdDate = dr.GetSmartDate("CreatedDate", _createdDate.EmptyIsMin);
_createdDate.FormatString = "g";
_lastLoginDate = dr.GetSmartDate("LastLoginDate", _lastLoginDate.EmptyIsMin);
_lastLoginDate.FormatString = "g";
_lastPasswordChangedDate = dr.GetSmartDate("LastPasswordChangedDate", _lastPasswordChangedDate.EmptyIsMin);
_lastPasswordChangedDate.FormatString = "g";
_lastLockoutDate = dr.GetSmartDate("LastLockoutDate", _lastLockoutDate.EmptyIsMin);
_lastLockoutDate.FormatString = "g";
FailedPasswordAttemptCount = dr.GetInt32("FailedPasswordAttemptCount");
Comment = dr.GetString("Comment");
Position = dr.GetString("Position");
FirstName = dr.GetString("FirstName");
MiddleName = dr.GetString("MiddleName");
LastName = dr.GetString("LastName");
LockoutEnabled = dr.GetBoolean("LockoutEnabled");
TwoFactorEnabled = dr.GetBoolean("TwoFactorEnabled");
SecurityStamp = dr.GetString("SecurityStamp");
_lockoutEndDateUtc = dr.GetSmartDate("LockoutEndDateUtc", _lockoutEndDateUtc.EmptyIsMin);
_lockoutEndDateUtc.FormatString = "g";
}
public void ShortForm_DayMonth_Small()
{
//presume month before day
var success = "1" + Separator + "3";
var fail = "4" + Separator + "2";
if (_dayBeforeMonth)
{
success = "3" + Separator + "1";
fail = "2" + Separator + "4";
}
var smartDate = new SmartDate(success);
Assert.AreEqual(new DateTime(DateTime.Now.Year, 1, 3).ToString("d"), smartDate);
try
{
smartDate = new SmartDate(fail);
Assert.AreEqual(new DateTime(DateTime.Now.Year, 4, 2).ToString("d"), smartDate);
}
catch (ArgumentException)
{
Assert.AreEqual(new DateTime(DateTime.Now.Year, 1, 3).ToString("d"), smartDate);
}
}
private void FetchObject(SafeDataReader dr)
{
_id = dr.GetGuid("Id");
_entryId = dr.GetGuid("EntryId");
_no = dr.GetInt32("No");
_contactType = dr.GetString("ContactType");
_company = dr.GetString("Company");
_address1 = dr.GetString("Address1");
_address2 = dr.GetString("Address2");
_city = dr.GetString("City");
_postal = dr.GetString("Postal");
_country = dr.GetString("Country");
_salutation = dr.GetString("Salutation");
_fullname = dr.GetString("Fullname");
_job = dr.GetString("Job");
_contact = dr.GetString("Contact");
_email = dr.GetString("Email");
_clientCompanyNetwork = dr.GetString("ClientCompanyNetwork");
_clientCompanyNetworkOthers = dr.GetString("ClientCompanyNetworkOthers");
_network = dr.GetString("Network");
_networkOthers = dr.GetString("NetworkOthers");
_holdingCompany = dr.GetString("HoldingCompany");
_holdingCompanyOthers = dr.GetString("HoldingCompanyOthers");
_companyType = dr.GetString("CompanyType");
_companyTypeOther = dr.GetString("CompanyTypeOther");
_status = dr.GetString("Status");
_dateCreated = dr.GetSmartDate("DateCreated", _dateCreated.EmptyIsMin);
_dateModified = dr.GetSmartDate("DateModified", _dateModified.EmptyIsMin);
}
public void ShortForm_DayMonthYear_Big()
{
//presume month before day
var success = "12" + Separator + "31";
var fail = "30" + Separator + "11";
if (_dayBeforeMonth)
{
success = "31" + Separator + "12";
fail = "11" + Separator + "30";
}
if (_yearIsLast)
{
success += Separator + "2015";
fail += Separator + "2015";
}
else
{
success = "2015" + Separator + success;
fail = "2015" + Separator + fail;
}
var smartDate = new SmartDate(success);
Assert.AreEqual(new DateTime(2015, 12, 31).ToString("d"), smartDate);
try
{
smartDate = new SmartDate(fail);
Assert.Fail(fail + ": string value shouldn't be convertible to a date");
}
catch (ArgumentException)
{
Assert.AreEqual(new DateTime(2015, 12, 31).ToString("d"), smartDate);
}
}
public OutgoingBookCriteriaGet(SmartDate criteriaStartDate, SmartDate criteriaEndDate, string archiveLocation, string fullText)
{
var dateTypeList = CriteriaDateTypeList.GetCriteriaDateTypeList(true);
LoadProperty(DateTypeListProperty, dateTypeList);
LoadProperty(SelectedDateTypeIndexProperty, 0);
}
public void ExactDigits_Four()
{
//presume month before day
var success = "1231";
var fail = "3011";
if (_dayBeforeMonth)
{
success = "3112";
fail = "1130";
}
var smartDate = new SmartDate(success);
Assert.AreEqual(new DateTime(DateTime.Now.Year, 12, 31).ToString("d"), smartDate);
try
{
smartDate = new SmartDate(fail);
Assert.Fail(fail + ": string value shouldn't be convertible to a date");
}
catch (ArgumentException)
{
Assert.AreEqual(new DateTime(DateTime.Now.Year, 12, 31).ToString("d"), smartDate);
}
}
internal MemberInfo(SafeDataReader dr)
{
_id = dr.GetInt32("id");
_first_name = dr.GetString("first_name");
_last_name = dr.GetString("last_name");
_en_first = dr.GetString("en_first_name");
_en_last = dr.GetString("en_last_name");
_email = dr.GetString("email");
_address = dr.GetString("address");
_city = dr.GetString("city");
_statecode = dr.GetString("statecode");
_zipcode = dr.GetString("zipcode");
_home = dr.GetString("home");
_age = dr.GetInt32("age");
_familyname = dr.GetString("family_name");
_fellowshipdate = dr.GetSmartDate("fellowship_date", _fellowshipdate.EmptyIsMin);
_fellowship = dr.GetString("fellowshipname");
_birthday = dr.GetSmartDate("birthday", _birthday.EmptyIsMin);
if (dr.GetBoolean("sex"))
{
_sex = Resources.Male.ToString();
}
else
{
_sex = Resources.Female.ToString();
}
if (dr.GetBoolean("married"))
{
_marrige = Resources.Married;
}
else
{
_marrige = Resources.Single;
}
_relastionship = dr.GetString("relationship");
_spousename = dr.GetString("spousename");
_spouseid = dr.GetInt32("spouse");
_job = dr.GetString("job");
_cell = dr.GetString("cell");
_cellname = dr.GetString("cellname");
_regdate = dr.GetSmartDate("regdate");
_regdate.FormatString = "yyyy-MM-dd";
_baptismname = dr.GetString("baptismName");
_baptism_year = dr.GetSmartDate("baptism_year");
_subdivision = dr.GetString("SubDivisionName");
_familycode = dr.GetInt32("family_code");
_statuscode = dr.GetInt32("StatusCode");
_statusname = dr.GetString("StatusName");
if (dr.GetBoolean("active"))
{
_active = Resources.Active;
}
else
{
_active = Resources.InActive;
}
}
public int Update(int?id, int?categoryId, string name, Guid rowGuidId, SmartDate modifiedDate)
{
string stmt = @"
UPDATE Production.ProductSubcategory
SET ProductCategoryID = @ProductCategoryID,
Name = @Name,
rowguid = @rowguid,
ModifiedDate = GETDATE()
WHERE ProductSubcategoryID = @Id and ModifiedDate = @ModDate
";
using (SqlConnection connection = new SqlConnection(ConfigurationManager.ConnectionStrings["AdventureWorks"].ConnectionString))
{
connection.Open();
using (SqlCommand cmd = new SqlCommand(stmt, connection))
{
cmd.Parameters.Add("@Id", SqlDbType.Int).Value = id;
cmd.Parameters.Add("@ProductCategoryID", SqlDbType.Int).Value = categoryId;
cmd.Parameters.Add("@Name", SqlDbType.NVarChar, 50).Value = name;
cmd.Parameters.Add("@rowguid", SqlDbType.UniqueIdentifier).Value = rowGuidId;
cmd.Parameters.Add("@ModDate", SqlDbType.DateTime).Value = modifiedDate;
return((int)cmd.ExecuteNonQuery());
}
}
}
public int Read(int?id)
{
string query = @"
select ProductSubcategoryID, ProductCategoryID, Name, rowguid, ModifiedDate
from Production.ProductSubcategory
where ProductSubcategoryID = @Id
";
int rowCount = 0;
using (SqlConnection connection = new SqlConnection(ConfigurationManager.ConnectionStrings["AdventureWorks"].ConnectionString))
{
connection.Open();
using (SqlCommand cmd = new SqlCommand(query, connection))
{
cmd.Parameters.Add("@Id", SqlDbType.Int).Value = id;
using (SafeDataReader sdr = new SafeDataReader(cmd.ExecuteReader()))
{
while (sdr.Read())
{
rowCount++;
this.Id = sdr.GetInt32("ProductSubcategoryID");
this.CategoryId = sdr.GetInt32("ProductCategoryID");
this.Name = sdr.GetString("Name");
this.RowGuidId = sdr.GetGuid("rowguid");
this.ModifiedDate = sdr.GetSmartDate("ModifiedDate");
}
}
}
}
return(rowCount);
}
private void Populate(SafeDataReader dr)
{
_ID = dr.GetInt32();
_EventID = dr.GetInt32();
_MatchDate = dr.GetDateTime();
_WinnerID = dr.GetInt32();
_LoserID = dr.GetInt32();
_Score.Fetch(dr);
ValidationRules.CheckRules();
}
private void Fetch(SafeDataReader dr)
{
//todo: load object data from data reader
//_TennisEvent = TennisObjects.TennisEvent.GetTennisEvent()
_ID = dr.GetInt32();
_Name = dr.GetString();
_startDate = dr.GetDateTime();
_endDate = dr.GetDateTime();
_eventType = (EventTypeEnum)dr.GetInt16();
_teamPlay = dr.GetBoolean();
_classificationID = dr.GetInt32();
_classification = dr.GetString();
_firstMatchDate = dr.GetDateTime();
_lastMatchDate = dr.GetDateTime();
_Matches.Won = dr.GetInt32();
_Matches.Lost = dr.GetInt32();
_Sets.Won = dr.GetInt32();
_Sets.Lost = dr.GetInt32();
_Games.Won = dr.GetInt32();
_Games.Lost = dr.GetInt32();
}
public void E1212()
{
SmartDate date = new SmartDate(1879, 3, 9);
Assert.AreEqual(Week.Sunday.ToString(), date.DayOfWeek());
}
protected override void DataPortal_Create()
{
Today = new SmartDate();
OtherDate = DateTime.Now;
base.DataPortal_Create();
}
private void _Fetch(SafeDataReader dr)
{
_ID = dr.GetInt32();
_Name = dr.GetString();
_ClassificationID = dr.GetInt32();
_BeginDate = dr.GetDateTime();
_EndDate = dr.GetDateTime();
_EventType = (EventTypeEnum)dr.GetInt16();
_TeamPlay = dr.GetBoolean();
}
private void _Fetch(SafeDataReader dr)
{
_ID = dr.GetInt32();
_MatchDate = dr.GetDateTime();
_EventID = dr.GetInt32();
_EventName = dr.GetString();
_ClassID = dr.GetInt32();
_ClassName = dr.GetString();
_Result = dr.GetString();
_OpponentID = dr.GetInt32();
_OpponentName = dr.GetString();
_Score.Fetch(dr);
//Log.Info("Fetched PlayerMatch {0}", _ID);
}
