private void InsertOrUpateVolunteer(SmsCsvModel item)
{
var v = db.Volunteers.Where(model => model.constituentCode == item.constituentCode);
if (v.FirstOrDefault() == null)
{
// insert into database
Volunteer volunteer = new Volunteer();
volunteer.importID = convertNullToString(item.importID);
volunteer.constituentCode = convertNullToString(item.constituentCode);
volunteer.title = convertNullToString(item.title);
volunteer.firstName = convertNullToString(item.firstName);
volunteer.lastName = convertNullToString(item.lastName);
volunteer.nickName = "";
volunteer.birthday = null;
volunteer.status = "Activate";
volunteer.gender = convertNullToString(item.gender, "Unknown");
volunteer.homePhone = convertNullToString(item.homePhone);
volunteer.cellPhone = convertNullToString(item.cellPhone);
volunteer.orientation = convertNullToString(item.orientation, "No");
volunteer.transitPass = convertNullToString(item.transitPass, "N/A");
volunteer.createOn = DateTime.Now;
volunteer.createBy = WebSecurity.CurrentUserName;
volunteer.modifiedOn = DateTime.Now;
volunteer.modifiedBy = WebSecurity.CurrentUserName;
volunteer.activatedOn = DateTime.Now;
// volunteer.deactivatedOn ;
// volunteer.note;
// volunteer.token;
volunteer.email = convertNullToString(item.email);
db.Volunteers.Add(volunteer);
db.SaveChanges();
}
else
{
// update database
Volunteer volunteer = v.FirstOrDefault();
volunteer.importID = convertNullToString(item.importID);
volunteer.title = convertNullToString(item.title);
volunteer.firstName = convertNullToString(item.firstName);
volunteer.lastName = convertNullToString(item.lastName);
volunteer.nickName = "";
//volunteer.birthday ;
volunteer.status = "Activate";
volunteer.gender = convertNullToString(item.gender, "Unknown");
volunteer.homePhone = convertNullToString(item.homePhone);
volunteer.cellPhone = convertNullToString(item.cellPhone);
volunteer.modifiedOn = DateTime.Now;
volunteer.modifiedBy = WebSecurity.CurrentUserName;
volunteer.activatedOn = DateTime.Now;
volunteer.orientation = convertNullToString(item.orientation, "No");
volunteer.transitPass = convertNullToString(item.transitPass, "N/A");
// volunteer.deactivatedOn ;
// volunteer.note;
// volunteer.token;
volunteer.email = convertNullToString(item.email);
db.Entry(volunteer).State = EntityState.Modified;
db.SaveChanges();
}
}
private void InsertOrUpateLocation(SmsCsvModel item)
{
var v = db.Volunteers.Where(model => model.constituentCode == item.constituentCode);
if (v.FirstOrDefault() != null)
{
Volunteer volunteer = v.FirstOrDefault();
var location = db.Locations.Where(l => l.volunteerId == volunteer.volunteerId && l.locationType == "Canada");
if (location.FirstOrDefault() == null)
{
// insert into database
Location newLocation = new Location();
newLocation.volunteerId = volunteer.volunteerId;
//contactId=
newLocation.locationType = "Canada";
newLocation.address = convertNullToString(item.address);
newLocation.city = convertNullToString(item.city);
newLocation.province = convertNullToString(item.province);
newLocation.postalcode = convertNullToString(item.postalcode);
db.Locations.Add(newLocation);
db.SaveChanges();
}
else
{
Location existLocation = location.FirstOrDefault();
existLocation.volunteerId = volunteer.volunteerId;
//contactId=
existLocation.locationType = "Canada";
existLocation.address = convertNullToString(item.address);
existLocation.city = convertNullToString(item.city);
existLocation.province = convertNullToString(item.province);
existLocation.postalcode = convertNullToString(item.postalcode);
db.Entry(existLocation).State = EntityState.Modified;
db.SaveChanges();
}
}
}
public SmsCsvModel checkSMSCsvModel(SmsCsvModel model)
{
SmsCsvModel result = new SmsCsvModel();
result.title = convertNullToString(model.title);
result.importID = convertNullToString(model.importID);
result.firstName = stringToTitleCase(convertNullToString(model.firstName));
result.lastName = stringToTitleCase(convertNullToString(model.lastName));
result.gender = stringToTitleCase(convertNullToString(model.gender, "Unknown"));
result.constituentCode = convertNullToString(model.constituentCode);
result.address = convertNullToString(model.address);
result.relationship = convertNullToString(model.relationship);
result.city = stringToTitleCase(convertNullToString(model.city));
result.province = stringToUpperCase(convertNullToString(model.province));
result.postalcode = stringToUpperCase(convertNullToString(model.postalcode));
#region check home type
if (model.homeType.Equals("Home", StringComparison.CurrentCultureIgnoreCase))
{
result.homeType = convertNullToString(model.homeType);
result.homePhone = convertNullToString(model.homePhone);
}
if (model.homeType.Equals("Cell", StringComparison.CurrentCultureIgnoreCase))
{
result.cellType = convertNullToString(model.homeType);
result.cellPhone = convertNullToString(model.homePhone);
}
if (model.homeType.Equals("Emergency Contact", StringComparison.CurrentCultureIgnoreCase))
{
result.emergencyType = convertNullToString(model.homeType);
result.emergencyPhone = convertNullToString(model.homePhone);
}
if (model.homeType.Equals("Personal Email", StringComparison.CurrentCultureIgnoreCase))
{
result.emailType = convertNullToString(model.homeType);
result.email = convertNullToString(model.homePhone);
}
#endregion
#region check cell type
if (model.cellType.Equals("Cell", StringComparison.CurrentCultureIgnoreCase))
{
result.cellType = convertNullToString(model.cellType);
result.cellPhone = convertNullToString(model.cellPhone);
}
if (model.cellType.Equals("Home", StringComparison.CurrentCultureIgnoreCase))
{
result.homeType = convertNullToString(model.cellType);
result.homePhone = convertNullToString(model.cellPhone);
}
if (model.cellType.Equals("Emergency Contact", StringComparison.CurrentCultureIgnoreCase))
{
result.emergencyType = convertNullToString(model.cellType);
result.emergencyPhone = convertNullToString(model.cellPhone);
}
if (model.cellType.Equals("Personal Email", StringComparison.CurrentCultureIgnoreCase))
{
result.emailType = convertNullToString(model.cellType);
result.email = convertNullToString(model.cellPhone);
}
#endregion
#region Emergency Contact
if (model.emergencyType.Equals("Emergency Contact", StringComparison.CurrentCultureIgnoreCase))
{
result.emergencyType = convertNullToString(model.emergencyType);
result.emergencyPhone = convertNullToString(model.emergencyPhone);
}
if (model.emergencyType.Equals("Cell", StringComparison.CurrentCultureIgnoreCase))
{
result.cellType = convertNullToString(model.emergencyType);
result.cellPhone = convertNullToString(model.emergencyPhone);
}
if (model.emergencyType.Equals("Home", StringComparison.CurrentCultureIgnoreCase))
{
result.homeType = convertNullToString(model.emergencyType);
result.homePhone = convertNullToString(model.emergencyPhone);
}
if (model.emergencyType.Equals("Personal Email", StringComparison.CurrentCultureIgnoreCase))
{
result.emailType = convertNullToString(model.emergencyType);
result.email = convertNullToString(model.emergencyPhone);
}
#endregion
#region Personal Email
if (model.emailType.Equals("Personal Email", StringComparison.CurrentCultureIgnoreCase))
{
result.emailType = convertNullToString(model.emailType);
result.email = convertNullToString(model.email);
}
if (model.emailType.Equals("Cell", StringComparison.CurrentCultureIgnoreCase))
{
result.cellType = convertNullToString(model.emailType);
result.cellPhone = convertNullToString(model.email);
}
if (model.emailType.Equals("Emergency Contact", StringComparison.CurrentCultureIgnoreCase))
{
result.emergencyType = convertNullToString(model.emailType);
result.emergencyPhone = convertNullToString(model.email);
}
if (model.emailType.Equals("Home", StringComparison.CurrentCultureIgnoreCase))
{
result.homeType = convertNullToString(model.emailType);
result.homePhone = convertNullToString(model.email);
}
#endregion
result.contactName = convertNullToString(model.contactName);
result.dateGiven = convertNullToString(model.dateGiven, DateTime.Now.ToShortDateString());
result.comment = convertNullToString(model.comment, "N/A");
result.orientation = convertNullToString(model.orientation, "N/A");
result.transitPass = convertNullToString(model.transitPass, "N/A");
return result;
}
private void InsertOrUpateEmergencyContact(SmsCsvModel item)
{
var v = db.Volunteers.Where(model => model.constituentCode == item.constituentCode);
if (v.FirstOrDefault() != null)
{
Volunteer volunteer = v.FirstOrDefault();
var contact = db.EmergencyContacts.Where(l => l.volunteerId == volunteer.volunteerId);
if (contact.FirstOrDefault() == null)
{
// insert into database
EmergencyContact newContact = new EmergencyContact();
newContact.volunteerId = volunteer.volunteerId;
newContact.contactName = convertNullToString(item.contactName);
newContact.relationship = convertNullToString(item.relationship);
newContact.emergencyPhone = convertNullToString(item.emergencyPhone);
newContact.comment = convertNullToString(item.comment);
DateTime dateTime = parseStringToDateTime(item.dateGiven);
newContact.createDate = dateTime;
db.EmergencyContacts.Add(newContact);
db.SaveChanges();
}
else
{
// update into database
EmergencyContact existContact = contact.FirstOrDefault();
existContact.volunteerId = volunteer.volunteerId;
existContact.contactName = convertNullToString(item.contactName);
existContact.relationship = convertNullToString(item.relationship);
existContact.emergencyPhone = convertNullToString(item.emergencyPhone);
existContact.comment = convertNullToString(item.comment);
DateTime dateTime = parseStringToDateTime(item.dateGiven);
existContact.createDate = dateTime;
db.Entry(existContact).State = EntityState.Modified;
db.SaveChanges();
}
}
}
public ActionResult ExportVolunteerSingleTeamCsv()
{
List<Volunteer> volunteers = GetVolunteersWhoInSingleTeam();
List<SmsCsvModel> data = new List<SmsCsvModel>();
SmsCsvModel model;
Location location;
volunteers.Sort((x, y) => { return -x.constituentCode.CompareTo(y.constituentCode); });
foreach (Volunteer v in volunteers)
{
model = new SmsCsvModel();
model.title = v.title;
model.firstName = v.firstName;
model.lastName = v.lastName;
model.gender = v.gender;
model.importID = v.importID;
model.constituentCode = v.constituentCode;
model.orientation = v.orientation == "N/A" ? "" : v.orientation;
model.orientationDate = (DateTime.Now).ToString("MM/dd/yyyy");
model.orientationComment = "Festival " + DateTime.Now.Year;
model.transitPass = v.transitPass == "N/A" ? "" : v.transitPass;
model.transitPassDate = (DateTime.Now).ToString("MM/dd/yyyy");
model.transitPassComment = "Festival " + DateTime.Now.Year;
location = db.Locations.Where(l => l.volunteerId == v.volunteerId).FirstOrDefault();
if (location != null)
{
if (location.locationType == "International")
{
model.address = convertNullToString(location.address);
model.city = "";
model.province = "";
model.postalcode = "";
}
else
{
model.address = convertNullToString(location.address);
model.city = convertNullToString(location.city);
model.province = convertNullToString(location.province);
model.postalcode = convertNullToString(location.postalcode);
}
}
else
{
model.address = "";
model.city = "";
model.province = "";
model.postalcode = "";
}
model.homeType = "Home";
model.homePhone = v.homePhone;
model.cellType = "Cell";
model.cellPhone = v.cellPhone;
model.emailType = "Personal Email";
model.email = v.email;
EmergencyContact ec = db.EmergencyContacts.Where(e => e.volunteerId == v.volunteerId).FirstOrDefault();
if (ec != null)
{
model.emergencyType = "Emergency Contact";
model.emergencyPhone = ec.emergencyPhone;
model.contactName = ec.contactName;
model.comment = ec.comment;
model.dateGiven = ((DateTime)ec.createDate).ToString("MM/dd/yyyy");
model.relationship = ec.relationship;
model.relationshipDate = (DateTime.Now).ToString("MM/dd/yyyy");
model.relationshipComments = "Festival " + DateTime.Now.Year;
}
model.earnedBucks = getTotalEarnedBucks(v.volunteerId);
model.earnedBucksDate = (DateTime.Now).ToString("MM/dd/yyyy");
model.earnedBucksComment = "Festival " + DateTime.Now.Year;
model.earnHours = getTotalEarnedHours(v.volunteerId);
model.earnHoursDate = (DateTime.Now).ToString("MM/dd/yyyy");
model.earnHoursComment = "Festival " + DateTime.Now.Year;
model.teamName = db.ShiftRecords.Where(s => s.volunteerId == v.volunteerId).Select(s => s.teamName).FirstOrDefault();
model.teamNameDate = (DateTime.Now).ToString("MM/dd/yyyy");
model.teamNameComment = "Festival " + DateTime.Now.Year;
data.Add(model);
}
data.Sort((x, y) => { return -x.postalcode.CompareTo(y.postalcode); });
data.Sort((x, y) => { return -x.constituentCode.CompareTo(y.constituentCode); });
string file_path = Server.MapPath("~/CsvDownload/");
String todayString = DateTime.Now.ToString("MMM_dd_yyyy");
string file_name = "Volunteer_sms_Single" + todayString + ".csv";
CsvContext cc = new CsvContext();
cc.Write(data, file_path + file_name);
System.Web.HttpResponse response = System.Web.HttpContext.Current.Response;
response.ClearContent();
response.Clear();
response.ContentType = "application/vnd.xls";
response.AddHeader("Content-Disposition", "attachment; filename=" + file_name + ";");
response.TransmitFile(file_path + file_name);
response.End();
return View();
}