protected void btn_submit_Click(object sender, EventArgs e)
{
ClassSchoolRegistration classSchool = new ClassSchoolRegistration();
string result = string.Empty;
try
{
string selectedpackage = this.hiddenFieild.Value.ToString();
if (selectedpackage == "Gold" || selectedpackage == "Silver" || selectedpackage == "Platinum")
{
if (JFunctions.UploadSingleFile(fileupload, "images/registeredSchools/") == "true")
{
result = classSchool.RegisterSchool(1, Convert.ToInt32(ddl_city.SelectedValue),
Convert.ToInt32(txt_postalcode.Text), txt_username.Text, txt_password.Text,
Convert.ToInt32(txt_accountPin.Text),
txt_primaryEmailAddress.Text, txt_secondaryEmailAddress.Text, txt_contact_primary.Text, txt_contact_secondary.Text, txt_schoolName.Text,
txt_ownername.Text,
txt_foundedIn.Text, fileupload.FileName, Convert.ToInt32(ddl_schooltype.SelectedValue),
txt_campusname.Text);
if (result == "true")
{
Package objPackage = new Package();
objPackage.InitializePackageAttributes(selectedpackage, classSchool.myDatabase.GetLastValueByColumnName("school_id", "tbl_school"));
if (objPackage.AssignPackage() == "true")
{
JFunctions.SendEmail(txt_primaryEmailAddress.Text, "CES - Registration", EmailBody());
Response.Write("<script>alert('An email has been sent to your primary email address which contain basic information about your account. You will be redirected to home page.');</script>");
}
else
{
Response.Write("Regisration completed successfully, but package assingment is not completed due to an error.");
}
}
else
{
Response.Write("not register");
}
}
else
{
Response.Redirect("image was not uploaded to server. Hence the registration process is cancelled. Please try again");
}
}
else
{
Response.Write("<script>alert('You have to select atleast one package.');</script>");
}
}
catch (Exception exception)
{
result = exception.ToString();
Response.Write(result);
}
}
private string GenerateCampusID(string schoolName)
{
StringBuilder builder = new StringBuilder();
builder.Append(random.Next(1, 5000).ToString());
builder.Append(schoolName.Substring(0, 5));
builder.Append("/CES/");
builder.Append(JFunctions.GetSystemDate());
builder.Append("/");
builder.Append(JFunctions.GetSystemTime());
return(builder.ToString());
}
protected void Page_Load(object sender, EventArgs e)
{
rbtnFemale.Checked = false;
rbtnMale.Checked = false;
if (!string.IsNullOrWhiteSpace(Request.QueryString["IAC"]))
{
txtTeacherIDToPopulateDetails.Text = Request.QueryString["IAC"];
}
JFunctions.BindDropDownList(ddlCity, "city", "city_id", "select * from tbl_city");
JFunctions.BindDropDownList(ddlCountry, "country", "country_id", "select * from tbl_country");
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
JFunctions.BindDropDownList(ddlCity, "city", "city_id", "select * from tbl_city");
JFunctions.BindDropDownList(ddlClass, "class", "Class_id", "select * from tbl_class");
JFunctions.BindDropDownList(ddlSection, "section", "Section_id", "select * from tbl_section");
}
if (!string.IsNullOrWhiteSpace(Request.QueryString["SIAC"]))
{
txtStudentIDForGettingInformation.Text = Request.QueryString["SIAC"];
}
}
private string GenerateSchoolID(string SchoolName, string OwnerName)
{
StringBuilder id = new StringBuilder();
id.Append(random.Next(3, 10));
id.Append("/C/");
id.Append(SchoolName.Substring(0, 3));
id.Append("/E/");
id.Append(OwnerName.Substring(0, 3));
id.Append("/S/");
id.Append(JFunctions.GetSystemDate());
id.Append("/");
id.Append(JFunctions.GetSystemTime());
id.Append("/");
id.Append(random.Next(3, 10));
return(id.ToString());
}
protected void Page_Load(object sender, EventArgs e)
{
lbl_error.Visible = false;
if (!IsPostBack)
{
JFunctions.BindDropDownList(ddl_type, "usertype", "usertype_id", "select * from tbl_usertype");
ddl_type.Items.Insert(0, "--- Select User Type ---");
if (Session["userid"] != null)
{
Session.Remove("userid");
lbl_error.Text = "You are logged in, you need to go back to your logged in page by loggin in again.";
lbl_error.Visible = true;
lbl_error.ForeColor = Color.Blue;
}
}
}
private string GenerateParentID(string Firstname, string Lastname)
{
Random random = new Random();
StringBuilder id = new StringBuilder();
id.Append("C/");
id.Append(Firstname.Substring(0, 3));
id.Append("/E/");
id.Append(Lastname.Substring(0, 3));
id.Append("/S/");
id.Append(JFunctions.GetSystemDate());
id.Append("/");
id.Append(JFunctions.GetSystemTime());
id.Append("/");
id.Append(random.Next(3, 10));
return(id.ToString());
}
public string RegisterSchool(int country_id, int city_id, int postalcode, string username, string password, int accountpin, string primaryemail, string secondaryemail, string contactPrimary, string contactSecondary, string schoolName, string ownerName, string foundedIn, string logo, int school_type_id, string campusName)
{
string locationid = myDatabase.GetLastValueByColumnName("loc_id", "tbl_location");
myDatabase.CreateConnection();
myDatabase.InitializeSQLCommandObject(myDatabase.GetCurrentConnection, "spRegisterSchool", true);
SqlParameter locidParameter = new SqlParameter("@loc_id", SqlDbType.Int);
SqlParameter countryidParameter = new SqlParameter("@country_id", SqlDbType.Int);
SqlParameter cityidParameter = new SqlParameter("@city_id", SqlDbType.Int);
SqlParameter postalcodeParameter = new SqlParameter("@postal_code", SqlDbType.Int);
SqlParameter locidoutParameter = new SqlParameter("@loc_id_out", SqlDbType.Int);
SqlParameter authorizedidParameter = new SqlParameter("@authorized_id", SqlDbType.VarChar, 20);
SqlParameter usernameParameter = new SqlParameter("@username", SqlDbType.VarChar, 50);
SqlParameter passwordParameter = new SqlParameter("@password", SqlDbType.VarChar, 50);
SqlParameter accountpinParameter = new SqlParameter("@account_pin", SqlDbType.Int);
SqlParameter primaryemailParameter = new SqlParameter("@primary_email", SqlDbType.VarChar, 50);
SqlParameter secondaryemailParameter = new SqlParameter("@secondary_email", SqlDbType.VarChar, 50);
SqlParameter usertypeidParameter = new SqlParameter("@usertype_id", SqlDbType.Int);
SqlParameter logincountParameter = new SqlParameter("@login_count", SqlDbType.Int);
SqlParameter lastlogindateParameter = new SqlParameter("@last_login_date", SqlDbType.Date);
SqlParameter authorizedidoutParameter = new SqlParameter("@authorized_id_out", SqlDbType.VarChar, 20);
SqlParameter schoolidParameter = new SqlParameter("@school_id", SqlDbType.VarChar, 50);
SqlParameter schoolnameParameter = new SqlParameter("@school_name", SqlDbType.VarChar, 50);
SqlParameter ownernameParameter = new SqlParameter("@owner_name", SqlDbType.VarChar, 50);
SqlParameter contactprimaryParameter = new SqlParameter("@contact_primary", SqlDbType.VarChar, 20);
SqlParameter contactsecondaryParameter = new SqlParameter("@contact_secondary", SqlDbType.VarChar, 20);
SqlParameter foundedinParameter = new SqlParameter("@founded_in", SqlDbType.Date);
SqlParameter logoParameter = new SqlParameter("@logo", SqlDbType.VarChar, 200);
SqlParameter schooltypeidParameter = new SqlParameter("@school_type_id", SqlDbType.Int);
SqlParameter schoolidoutParameter = new SqlParameter("@school_id_out", SqlDbType.VarChar, 20);
SqlParameter campusidParameter = new SqlParameter("@campus_id", SqlDbType.VarChar, 20);
SqlParameter campusnameParameter = new SqlParameter("@campus_name", SqlDbType.VarChar, 50);
locidParameter.Value = Convert.ToInt32(locationid) + 1;
countryidParameter.Value = country_id;
cityidParameter.Value = city_id;
postalcodeParameter.Value = postalcode;
locidoutParameter.Direction = ParameterDirection.Output;
authorizedidParameter.Value = GenerateAuthorizedID(username, accountpin.ToString());
usernameParameter.Value = username;
passwordParameter.Value = password;
accountpinParameter.Value = accountpin;
primaryemailParameter.Value = primaryemail;
secondaryemailParameter.Value = secondaryemail;
usertypeidParameter.Value = 1;
logincountParameter.Value = 0;
lastlogindateParameter.Value = Convert.ToDateTime(JFunctions.GetSystemDate());
authorizedidoutParameter.Direction = ParameterDirection.Output;
schoolidParameter.Value = GenerateSchoolID(schoolName, ownerName);
schoolnameParameter.Value = schoolName;
ownernameParameter.Value = ownerName;
contactprimaryParameter.Value = contactPrimary;
contactsecondaryParameter.Value = contactSecondary;
foundedinParameter.Value = Convert.ToDateTime(JFunctions.GetSystemDate());
logoParameter.Value = logo;
schooltypeidParameter.Value = school_type_id;
schoolidoutParameter.Direction = ParameterDirection.Output;
campusidParameter.Value = GenerateCampusID(schoolName);
campusnameParameter.Value = campusName;
myDatabase.obj_sqlcommand.Parameters.Add(locidParameter);
myDatabase.obj_sqlcommand.Parameters.Add(countryidParameter);
myDatabase.obj_sqlcommand.Parameters.Add(cityidParameter);
myDatabase.obj_sqlcommand.Parameters.Add(postalcodeParameter);
myDatabase.obj_sqlcommand.Parameters.Add(locidoutParameter);
myDatabase.obj_sqlcommand.Parameters.Add(authorizedidParameter);
myDatabase.obj_sqlcommand.Parameters.Add(usernameParameter);
myDatabase.obj_sqlcommand.Parameters.Add(passwordParameter);
myDatabase.obj_sqlcommand.Parameters.Add(accountpinParameter);
myDatabase.obj_sqlcommand.Parameters.Add(primaryemailParameter);
myDatabase.obj_sqlcommand.Parameters.Add(secondaryemailParameter);
myDatabase.obj_sqlcommand.Parameters.Add(usertypeidParameter);
myDatabase.obj_sqlcommand.Parameters.Add(logincountParameter);
myDatabase.obj_sqlcommand.Parameters.Add(lastlogindateParameter);
myDatabase.obj_sqlcommand.Parameters.Add(authorizedidoutParameter);
myDatabase.obj_sqlcommand.Parameters.Add(schoolidParameter);
myDatabase.obj_sqlcommand.Parameters.Add(schoolnameParameter);
myDatabase.obj_sqlcommand.Parameters.Add(contactprimaryParameter);
myDatabase.obj_sqlcommand.Parameters.Add(contactsecondaryParameter);
myDatabase.obj_sqlcommand.Parameters.Add(ownernameParameter);
myDatabase.obj_sqlcommand.Parameters.Add(foundedinParameter);
myDatabase.obj_sqlcommand.Parameters.Add(logoParameter);
myDatabase.obj_sqlcommand.Parameters.Add(schooltypeidParameter);
myDatabase.obj_sqlcommand.Parameters.Add(schoolidoutParameter);
myDatabase.obj_sqlcommand.Parameters.Add(campusidParameter);
myDatabase.obj_sqlcommand.Parameters.Add(campusnameParameter);
try
{
myDatabase.OpenConnection();
if (myDatabase.obj_sqlcommand.ExecuteNonQuery() > 0)
{
return("true");
}
else
{
return("false");
}
}
catch (Exception exception)
{
return("false" + exception.ToString());
}
finally
{
myDatabase.obj_sqlcommand.Dispose();
myDatabase.obj_sqlconnection.Dispose();
myDatabase.obj_sqlcommand.Parameters.Clear();
myDatabase.CloseConnection();
}
}
