public static Event CreateEvent(Proposal proposal)
{
Event e = new Event();
e.CreatorId = proposal.CreatorId;
e.ProposalId = proposal.Id;
e.CreateTime = DateTime.Now;
e.GuestLimit = GetEventCapacity(proposal.Content);
e.HostOrg = GetHostOrg(proposal.Content);
e.HostName = GetContactName(proposal.Content);
e.HostEmail = GetContactEmail(proposal.Content);
e.HostPhone = GetContactPhone(proposal.Content);
e.EventName = GetEventName(proposal.Content);
e.StartTime = GetEventStartTime(proposal.Content);
e.EndTime = GetEventEndTime(proposal.Content);
e.RegDeadline = GetRegDeadline(proposal.Content);
e.Location = GetEventLocation(proposal.Content);
e.Descr = GetEventDesc(proposal.Content);
e.MeetLocation = GetMeetingLocation(proposal.Content);
e.MeetTime = GetMeetingTime(proposal.Content);
e.Transportation = GetTrasportation(proposal.Content);
e.RequestDrivers = GetRequestDrivers(proposal.Content);
e.Costs = GetCost(proposal.Content);
e.Equipment = GetEquipment(proposal.Content);
e.Food = GetFood(proposal.Content);
e.Other = GetOther(proposal.Content);
return e;
}
/// <summary>
/// Make an Event object from form inputs.
/// </summary>
/// <returns>An event object.</returns>
private Event MakeEvent()
{
Event e = new Event();
e.CreatorId = ((DataModels.User)Session[Const.User]).Uid;
e.CreateTime = DateTime.Now;
e.GuestLimit = ParseGuestLimit();
e.HostOrg = string.IsNullOrEmpty(HostOrg.Text.Trim()) ? null : HostOrg.Text.Trim();
e.HostName = HostName.Text.Trim();
e.HostEmail = HostEmail.Text.Trim();
e.HostPhone = FormatHelper.ParsePhoneNum(HostPhone.Text);
e.EventName = EventName.Text.Trim();
e.StartTime = DateTime.Parse(StartTimeCtr.Text);
e.EndTime = DateTime.Parse(EndTimeCtr.Text);
e.RegDeadline = DateTime.Parse(RegDeadlineCtr.Text);
e.Location = Location.Text.Trim();
e.Descr = Desc.Text.Trim();
e.MeetLocation = MeetLocation.Text.Trim();
e.MeetTime = DateTime.Parse(MeetTime.Text);
e.Transportation = Transport.Text.Trim();
e.RequestDrivers = RequestDrivers.Checked;
e.Costs = string.IsNullOrEmpty(Costs.Text.Trim()) ? null : Costs.Text.Trim();
e.Equipment = string.IsNullOrEmpty(Equipment.Text.Trim()) ? null : Equipment.Text.Trim();
e.Food = string.IsNullOrEmpty(Food.Text.Trim()) ? null : Food.Text.Trim();
e.Other = string.IsNullOrEmpty(Other.Text.Trim()) ? null : Other.Text.Trim();
return e;
}
public static int Insert(int creatorId, Event _event, string tempate)
{
return Insert(creatorId, _event.EventName,
MakeProposalHtmlContent(_event, tempate));
}
public static string MakeProposalHtmlContent(Event ev, string template)
{
StringBuilder result = new StringBuilder(template);
result.Replace("[EventName]", ev.EventName);
result.Replace("[HostOrg]", GetString(ev.HostOrg));
result.Replace("[ContactName]", ev.HostName);
result.Replace("[ContactPhone]", FormatPhoneNum(ev.HostPhone));
result.Replace("[ContactEmail]", ev.HostEmail);
result.Replace("[EventDescription]", ev.Descr);
result.Replace("[StartTime]", ev.StartTime.ToString("g"));
result.Replace("[EndTime]", ev.EndTime.ToString("g"));
result.Replace("[MeetTime]", ev.MeetTime.ToString("g"));
result.Replace("[MeetingLocation]", ev.MeetLocation);
result.Replace("[EventLocation]", ev.Location);
result.Replace("[Transporation]", ev.Transportation);
result.Replace("[RequestDrivers]", ev.RequestDrivers ? "Yes" : "No");
result.Replace("[Equipment]", GetString(ev.Equipment));
result.Replace("[Food]", GetString(ev.Food));
result.Replace("[Cost]", GetString(ev.Costs));
result.Replace("[Other]", GetString(ev.Other));
result.Replace("[EventCapacity]", GetEventCapacityString(ev.GuestLimit));
result.Replace("[RegDeadline]", ev.RegDeadline.ToString("g"));
return result.ToString();
}
/// <summary>
/// Inserts a new Event into the database.
/// </summary>
/// <param name="e">The event to be inserted.</param>
/// <returns>The number of rows affected from this operation.</returns>
public static int Insert(Event e)
{
string queryStr =
"INSERT INTO Events (creatorId, proposalId, createTime, guestLimit, hostOrg, " +
"hostName, hostEmail, hostPhone, eventName, startTime, endTime, regDeadline, " +
"location, descr, meetLocation, meetTime, transportation, requestDrivers, " +
"costs, equipment, food, other, approved) " +
"VALUES (@creatorId, @proposalId, @createTime, @guestLimit, @hostOrg, @hostName, " +
"@hostEmail, @hostPhone, @eventName, @startTime, @endTime, @regDeadline, " +
"@location, @descr, @meetLocation, @meetTime, @transportation, " +
"@requestDrivers, @costs, @equipment, @food, @other, @approved)";
using (SqlConnection con = new SqlConnection(Config.SqlConStr))
{
SqlCommand command = new SqlCommand(queryStr, con);
command.Parameters.Add(new SqlParameter("creatorId", e.CreatorId));
command.Parameters.Add(new SqlParameter("proposalId", e.ProposalId));
command.Parameters.Add(new SqlParameter("createTime", DateTime.Now));
command.Parameters.Add(e.GuestLimit == Event.EventCapacityUnlimited ?
new SqlParameter("guestLimit", DBNull.Value) :
new SqlParameter("guestLimit", e.GuestLimit));
command.Parameters.Add(new SqlParameter("hostOrg", GetNullableValue(e.HostOrg)));
command.Parameters.Add(new SqlParameter("hostName", e.HostName));
command.Parameters.Add(new SqlParameter("hostEmail", e.HostEmail));
command.Parameters.Add(new SqlParameter("hostPhone", e.HostPhone));
command.Parameters.Add(new SqlParameter("eventName", e.EventName));
command.Parameters.Add(new SqlParameter("startTime", e.StartTime));
command.Parameters.Add(new SqlParameter("endTime", e.EndTime));
command.Parameters.Add(new SqlParameter("regDeadline", e.RegDeadline));
command.Parameters.Add(new SqlParameter("location", e.Location));
command.Parameters.Add(new SqlParameter("descr", e.Descr));
command.Parameters.Add(new SqlParameter("meetLocation", e.MeetLocation));
command.Parameters.Add(new SqlParameter("meetTime", e.MeetTime));
command.Parameters.Add(new SqlParameter("transportation", e.Transportation));
command.Parameters.Add(new SqlParameter("requestDrivers", e.RequestDrivers));
command.Parameters.Add(new SqlParameter("costs", GetNullableValue(e.Costs)));
command.Parameters.Add(new SqlParameter("equipment", GetNullableValue(e.Equipment)));
command.Parameters.Add(new SqlParameter("food", GetNullableValue(e.Food)));
command.Parameters.Add(new SqlParameter("other", GetNullableValue(e.Other)));
command.Parameters.Add(new SqlParameter("approved", true));
con.Open();
return command.ExecuteNonQuery();
}
}