public static List <HeatData> CreateTicket(string staffNumber, string crn, string termCode)
{
List <HeatData> heatData = new List <HeatData>();
string sentToEmail = WebConfigurationManager.AppSettings["ToEmail"];
try
{
UtilResultObject res = new UtilResultObject();
StudentAttendanceClient response = new StudentAttendanceClient();
Files.dbConnection con = new Files.dbConnection(); // 218720 VP // 22178 VS
string sclearsql = string.Concat("SELECT * FROM [IntHub].[dbo].[StaffBKI] " +
"WHERE BarCode = @staffNumber" +
" and isActive = 1 and StaffType in ('Payroll BT','Payroll KI')"
);
SqlParameter[] parameter =
{
new SqlParameter("@staffNumber", SqlDbType.VarChar)
{
Value = staffNumber
}
};
DataTable tempTable = null;
tempTable = con.executeSelectQuery(sclearsql, parameter);
string emailTofromDB = WebConfigurationManager.AppSettings["ToEmail"];
if ((tempTable == null) || (tempTable.Rows.Count == 0))
{
emailTofromDB = WebConfigurationManager.AppSettings["ToEmailLogin"];
}
else
{
foreach (DataRow dr in tempTable.Rows)
{
emailTofromDB = dr["Login"].ToString();
sentToEmail = dr["EmailInstitute"].ToString();
}
}
res = response.CreateHEATTicket(WebConfigurationManager.AppSettings["webServiceUsername"],
WebConfigurationManager.AppSettings["webServicePassword"],
emailTofromDB,
staffNumber,
crn,
termCode);
if (res.Status)
{
try
{
MailMessage mail = new MailMessage();
SmtpClient SmtpServer = new SmtpClient("mail-relay.kbtm.kangan.edu.au");
mail.From = new MailAddress(WebConfigurationManager.AppSettings["FromEmail"]);
//Files.dbConnection con = new Files.dbConnection(); // 218720 VP // 22178 VS
//string sclearsql = string.Concat("SELECT * FROM [IntHub].[dbo].[StaffBKI] " +
// "WHERE BarCode = @staffNumber" +
// " and isActive = 1 and StaffType in ('Payroll BT','Payroll KI')"
// );
//SqlParameter[] parameter = {
// new SqlParameter("@staffNumber", SqlDbType.VarChar) { Value =staffNumber }
// };
//DataTable tempTable = null;
//tempTable = con.executeSelectQuery(sclearsql, parameter);
//if ((tempTable == null) || (tempTable.Rows.Count == 0))
//{
// mail.To.Add(WebConfigurationManager.AppSettings["ToEmail"]);
//}
//else
//{
// foreach (DataRow dr in tempTable.Rows)
// {
// //dr["EmailInstitute"].ToString();
// mail.To.Add(dr["EmailInstitute"].ToString());
// sentToEmail = dr["EmailInstitute"].ToString();
// }
//}
//where BarCode = CONVERT(varchar(50), 218720 )
mail.To.Add(sentToEmail);
mail.Subject = "Student Attendance Missing";
string heatCloseUrl = WebConfigurationManager.AppSettings["AttendanceSubmission"];
//string heatCloseUrl = WebConfigurationManager.AppSettings["HeatTicketClose"];
string url = heatCloseUrl + "?heatId=" + res.Message +
"&teacherId=" + staffNumber
+ "&crn=" + crn
+ "&termCode=" + termCode
+ "&classDate=" + DateTime.Now.ToString("dd'/'MM'/'yyyy");
mail.Body = @"Heat Ticket is created." + " The id is:- " + res.Message + "\n" + url;
SmtpServer.Port = 25;
//SmtpServer.Send(mail);
HeatData hd = new HeatData();
hd.heatId = res.Message;
hd.message = res.Status.ToString();
hd.sentToEmail = sentToEmail;
hd.emailTofromDB = emailTofromDB;
heatData.Add(hd);
return(heatData);
}
catch (Exception ex)
{
return(heatData);
throw ex;
//MessageBox.Show(ex.ToString());
}
}
}
catch (Exception)
{
throw;
}
//return message;
return(heatData);
}
public static StudentApplicationData GetFormData(string applicationId) //string applicationId
{
Files.dbConnection con = new Files.dbConnection();
StudentApplicationData applicationDetails = new StudentApplicationData();
try
{
string sql_getApplicationDetails = string.Concat("[dbo].[sp_getApplicationDetails]");
DataTable tempTable_getApplicationDetails = null;
SqlParameter[] parameter =
{
new SqlParameter("@applicationId", SqlDbType.VarChar)
{
Value = applicationId
}
};
tempTable_getApplicationDetails = con.executeSelectQuery(sql_getApplicationDetails, parameter);
if ((tempTable_getApplicationDetails != null) || (tempTable_getApplicationDetails.Rows.Count >= 0))
{
foreach (DataRow drr in tempTable_getApplicationDetails.Rows)
{
applicationDetails.vrt_title = drr["Title"].ToString();
applicationDetails.firstName = drr["FirstName"].ToString();
applicationDetails.lastname = drr["Lastname"].ToString();
applicationDetails.emailaddress1 = drr["Email"].ToString();
applicationDetails.isEmailValid = drr["IsEmailValid"].ToString();
applicationDetails.mobilephone = drr["MobilePhone"].ToString();
applicationDetails.isNumberValid = drr["IsNumberValid"].ToString();
applicationDetails.birthdate = drr["BirthdateFormatted"].ToString();//Birthdate
#region Get course and campus lookup
string sql_getApplicationCourseCampus = string.Concat("[dbo].[sp_getApplicationCourseCampus]");
DataTable tempTable_getApplicationCourseCampus = null;
SqlParameter[] parameterApplicationCourseCampus =
{
new SqlParameter("@applicationId", SqlDbType.VarChar)
{
Value = applicationId
}
};
tempTable_getApplicationCourseCampus = con.executeSelectQuery(sql_getApplicationCourseCampus, parameterApplicationCourseCampus);
applicationDetails.courseNCampus = new List <CourseNCampus>();
if ((tempTable_getApplicationCourseCampus != null) && (tempTable_getApplicationCourseCampus.Rows.Count > 0))
{
foreach (DataRow dr in tempTable_getApplicationCourseCampus.Rows)
{
CourseNCampus cc = new CourseNCampus();
cc.vrt_course = dr["CourseID"].ToString();
cc.vrt_courseCode = dr["CourseCode"].ToString();
cc.vrt_courseName = dr["Course"].ToString();
cc.txtCampus = dr["CampusID"].ToString();
cc.txtCampusName = dr["Campus"].ToString();
cc.courseCampusID = Int32.Parse(dr["CourseCampusID"].ToString());
applicationDetails.courseNCampus.Add(cc);
}
}
else
{
applicationDetails.courseNCampus.Add(new CourseNCampus());
}
#endregion
applicationDetails.studentGender = drr["Gender"].ToString();
applicationDetails.address1_postalcode = drr["Postcode"].ToString();
#region Get Qualification Lookup
string sql_getApplicationQualifications = string.Concat("[dbo].[sp_getApplicationQualifications]");
DataTable tempTable_getApplicationQualifications = null;
SqlParameter[] parameterApplicationQualifications =
{
new SqlParameter("@applicationId", SqlDbType.VarChar)
{
Value = applicationId
}
};
tempTable_getApplicationQualifications = con.executeSelectQuery(sql_getApplicationQualifications, parameterApplicationQualifications);
applicationDetails.txtQualification = new List <Qualification>();
if ((tempTable_getApplicationQualifications != null) && (tempTable_getApplicationQualifications.Rows.Count > 0))
{
foreach (DataRow dr in tempTable_getApplicationQualifications.Rows)
{
Qualification qual = new Qualification();
qual.qualificationID = Int32.Parse(dr["QualificationID"].ToString());
qual.qualification = dr["Qualification"].ToString();
qual.internalName = dr["InternalName"].ToString();
qual.qualificationCode = dr["QualificationCode"].ToString();
qual.selected = Boolean.Parse(dr["selected"].ToString());
applicationDetails.txtQualification.Add(qual);
}
}
#endregion
applicationDetails.vrt_successfullycompletedqualifications = drr["CompletedQualification"].ToString();
applicationDetails.vrt_whatbroughtyoutothekanganinstitutewebsite = new WhatBroughtYouHere();
applicationDetails.vrt_whatbroughtyoutothekanganinstitutewebsite.vrt_whatbroughtyoutothekanganinstitutewebsite = drr["ReasonToChooseBKI"].ToString();
applicationDetails.vrt_whatbroughtyoutothekanganinstitutewebsite.reasonToChooseBKIID = Int32.Parse(drr["ReasonToChooseBKIID"].ToString());
applicationDetails.vrt_studiedatkanganinstitutebendigotafebefore = drr["StudiedHereBefore"].ToString();
applicationDetails.vrt_kibtstudentidnumber = drr["PrevStudentNumber"].ToString();
applicationDetails.vrt_australiancitizenshipresidency = new Residency();
applicationDetails.vrt_australiancitizenshipresidency.vrt_australiancitizenshipresidency = drr["Residency"].ToString();
applicationDetails.vrt_australiancitizenshipresidency.residencyId = Int32.Parse(drr["ResidencyID"].ToString());
applicationDetails.vrt_australiancitizenshipresidency.type = drr["ResidencyType"].ToString();
applicationDetails.vrt_aboriginalortorresstraitislander = new Aboriginal();
applicationDetails.vrt_aboriginalortorresstraitislander.vrt_aboriginalortorresstraitislander = drr["Status"].ToString();
applicationDetails.vrt_aboriginalortorresstraitislander.statusId = Int32.Parse(drr["IndigenousStatusID"].ToString());
applicationDetails.hasUSI = drr["HasUSI"].ToString();
applicationDetails.vrt_uniquestudentidentifier = drr["USI"].ToString();
applicationDetails.vrt_permissiontocheckfororcreateausi = drr["VerifyUSI"].ToString();
applicationDetails.applyUSI = drr["ApplyUSI"].ToString();
applicationDetails.streetNumber = drr["StreetNumber"].ToString();
applicationDetails.streetName = drr["StreetName"].ToString();
applicationDetails.city = drr["CityOfResidence"].ToString();
applicationDetails.state = new State();
applicationDetails.state.state = drr["State"].ToString();
applicationDetails.state.stateID = Int32.Parse(drr["StateOfResidenceId"].ToString());
applicationDetails.vrt_CityorTownofBirth = drr["CityOfBirth"].ToString();
applicationDetails.isAddressValid = drr["IsAddressValid"].ToString(); // Accepts True or False
applicationDetails.vrt_CountryofBirth = new Country();
applicationDetails.vrt_CountryofBirth.country = drr["CountryOfBirth"].ToString();
applicationDetails.vrt_CountryofBirth.countryID = Int32.Parse(drr["CountryOfBirthID"].ToString());
applicationDetails.vrt_CountryofResidence = new Country();
applicationDetails.vrt_CountryofResidence.country = drr["CountryOfResidence"].ToString();
applicationDetails.vrt_CountryofResidence.countryID = Int32.Parse(drr["CountryOfResidenceID"].ToString());
applicationDetails.idProof = new IdProof();
applicationDetails.idProof.internalName = drr["InternalName"].ToString();
applicationDetails.idProof.type = drr["Type"].ToString();
applicationDetails.idProof.proofId = Int32.Parse(drr["ProofTypeID"].ToString());
applicationDetails.idProof.idProofName = drr["IdentityProof"].ToString();
applicationDetails.idProofText = drr["ProofNumber"].ToString();
applicationDetails.partialSave = drr["PartialSave"].ToString();
}
}
}
catch (Exception e)
{
}
return(applicationDetails);
}