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());
}
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());
}
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();
}
}
