static public void GetstudentlDetails(string stdlid)
{
mydatabse.CreateConnection();
mydatabse.InitializeSQLCommandObject(mydatabse.GetCurrentConnection, "GetStudentID", true);
try
{
mydatabse.OpenConnection();
SqlParameter p_autho = new SqlParameter("@authorized_id", SqlDbType.VarChar, 20);
p_autho.Value = stdlid;
mydatabse.obj_sqlcommand.Parameters.Add(p_autho);
mydatabse.obj_reader = mydatabse.obj_sqlcommand.ExecuteReader();
if (mydatabse.obj_reader.HasRows)
{
int totalRows = mydatabse.obj_reader.RecordsAffected;
while (mydatabse.obj_reader.Read())
{
studentid = mydatabse.obj_reader["Std_id"].ToString();
}
}
else
{
HttpContext.Current.Response.Write("No records");
}
}
catch (Exception ex)
{
HttpContext.Current.Response.Write(ex.ToString());
}
finally
{
mydatabse.CloseConnection();
mydatabse.obj_reader.Close();
}
}
public void GetAllTeachersByFirstName(string SearchKey, string _schoolid)
{
JavaScriptSerializer serializer = new JavaScriptSerializer();
List <TeacherSearch> listteacherSearches = new List <TeacherSearch>();
myDatabase.CreateConnection();
myDatabase.InitializeSQLCommandObject(myDatabase.GetCurrentConnection, "sp_SearchTeacherByFirstName", true);
myDatabase.obj_sqlcommand.Parameters.AddWithValue("@TeacherName", SearchKey);
myDatabase.obj_sqlcommand.Parameters.AddWithValue("@SchoolID", _schoolid);
try
{
DateTime actualDate;
DateTime date = new DateTime();
string dateformat = "dd/mm/yyyy";
myDatabase.OpenConnection();
myDatabase.obj_reader = myDatabase.obj_sqlcommand.ExecuteReader();
if (myDatabase.obj_reader.HasRows)
{
while (myDatabase.obj_reader.Read())
{
TeacherSearch teacherSearch = new TeacherSearch();
teacherSearch.FirstName = myDatabase.obj_reader["firstname"].ToString();
teacherSearch.LastName = myDatabase.obj_reader["lastname"].ToString();
teacherSearch.Photo = myDatabase.obj_reader["photo"].ToString();
actualDate = Convert.ToDateTime(myDatabase.obj_reader["date_of_join"]);
teacherSearch.DateOfJoin = actualDate.ToString("D");
teacherSearch.CNIC = myDatabase.obj_reader["cnic_no"].ToString();
teacherSearch.GeneralID = Convert.ToInt32(myDatabase.obj_reader["General_Id"]);
teacherSearch.TeacherID = Convert.ToInt32(myDatabase.obj_reader["teacher_id"]);
teacherSearch.AuthorizedID = myDatabase.obj_reader["authorized_id"].ToString();
teacherSearch.SchoolID = myDatabase.obj_reader["school_id"].ToString();
listteacherSearches.Add(teacherSearch);
}
}
else
{
HttpContext.Current.Response.Write("No teacher record found.");
}
}
catch (Exception exception)
{
HttpContext.Current.Response.Write(exception.ToString());
}
finally
{
myDatabase.CloseConnection();
myDatabase.obj_reader.Dispose();
}
HttpContext.Current.Response.Write(serializer.Serialize(listteacherSearches));
}
private static string getschoolid()
{
string school_id = string.Empty;
mydb.CreateConnection();
mydb.InitializeSQLCommandObject(mydb.GetCurrentConnection, "select school_id from tbl_school where authorized_id='" + CurrentUser.AuthorizedID + "'");
try
{
mydb.OpenConnection();
mydb.obj_reader = mydb.obj_sqlcommand.ExecuteReader();
if (mydb.obj_reader.HasRows)
{
while (mydb.obj_reader.Read())
{
school_id = mydb.obj_reader["school_id"].ToString();
}
}
else
{
HttpContext.Current.Response.Write("No Record Found");
}
}
catch (Exception ex)
{
HttpContext.Current.Response.Write(ex.ToString());
}
finally
{
mydb.CloseConnection();
mydb.obj_reader.Dispose();
mydb.obj_reader.Close();
}
return(school_id);
}
static public void GetAuthorizedDetails(string _authorizedid)
{
myDatabase.CreateConnection();
myDatabase.InitializeSQLCommandObject(myDatabase.GetCurrentConnection, "sp_GetAuthorizedDetailsByAuthorizedID", true);
try
{
myDatabase.OpenConnection();
SqlParameter p_authorizedID = new SqlParameter("@authorized_id", SqlDbType.VarChar, 20);
p_authorizedID.Value = _authorizedid;
myDatabase.obj_sqlcommand.Parameters.Add(p_authorizedID);
myDatabase.obj_reader = myDatabase.obj_sqlcommand.ExecuteReader();
if (myDatabase.obj_reader.HasRows)
{
int totalRows = myDatabase.obj_reader.RecordsAffected;
while (myDatabase.obj_reader.Read())
{
AuthorizedID = myDatabase.obj_reader["authorized_id"].ToString();
Username = myDatabase.obj_reader["username"].ToString();
Password = myDatabase.obj_reader["password"].ToString();
AccountPin = Convert.ToInt32(myDatabase.obj_reader["account_pin"]);
PrimaryEmailAddress = myDatabase.obj_reader["primary_email"].ToString();
SecondaryEmailAddress = myDatabase.obj_reader["secondary_email"].ToString();
UserTypeID = Convert.ToInt32(myDatabase.obj_reader["usertype_id"]);
LoginCount = Convert.ToInt32(myDatabase.obj_reader["login_count"]);
LastLoginDate = myDatabase.obj_reader["last_login_date"].ToString();
}
}
else
{
HttpContext.Current.Response.Write("No record found on this authorized id");
}
}
catch (Exception ex)
{
HttpContext.Current.Response.Write(ex.ToString());
}
finally
{
myDatabase.CloseConnection();
myDatabase.obj_reader.Close();
}
}
public static void BindDropDownList(DropDownList ddl, string displayField, string valueField, string query)
{
Database.Database myDatabase = new Database.Database("cesConnectionString");
myDatabase.CreateConnection();
myDatabase.InitializeSQLCommandObject(myDatabase.GetCurrentConnection, query);
try
{
myDatabase.OpenConnection();
ddl.DataSource = myDatabase.obj_sqlcommand.ExecuteReader();
ddl.DataTextField = displayField;
ddl.DataValueField = valueField;
ddl.DataBind();
}
finally
{
myDatabase.CloseConnection();
myDatabase.obj_sqlcommand.Dispose();
}
}
public string Registerparents(string firstname, string lastname, string nationality, string gender, string dob, string photo,
string religion, string phone, string address, string officeaddress, string officeno, string cnicno,
string postdesignation, string salaryanum, int country_id, int city_id, int postalcode, string username,
string password, int accountpin, string primaryemail, string secondaryemail)
{
string locationid = mdata.GetLastValueByColumnName("loc_id", "tbl_location");
string genaralid = mdata.GetLastValueByColumnName("General_Id", "tbl_general");
string dobid = mdata.GetLastValueByColumnName("dob_id", "tbl_dob");
mdata.CreateConnection();
mdata.InitializeSQLCommandObject(mdata.GetCurrentConnection, "SP_PARENTREGISTRATIONN", true);
SqlParameter parentidParameter = new SqlParameter("@Parent_id ", SqlDbType.VarChar, 50);
SqlParameter generalidParameter = new SqlParameter("@general_id ", SqlDbType.Int);
SqlParameter firstnameParameter = new SqlParameter("@firstname ", SqlDbType.VarChar, 50);
SqlParameter lastnameParameter = new SqlParameter("@lastname ", SqlDbType.VarChar, 50);
SqlParameter nationalityParameter = new SqlParameter("@nationality ", SqlDbType.VarChar, 50);
SqlParameter genderParameter = new SqlParameter("@gender ", SqlDbType.VarChar, 7);
SqlParameter photoParameter = new SqlParameter("@photo ", SqlDbType.VarChar, 50);
SqlParameter religionParameter = new SqlParameter("@religion ", SqlDbType.VarChar, 20);
SqlParameter phoneParameter = new SqlParameter("@phone ", SqlDbType.VarChar, 50);
SqlParameter addressParameter = new SqlParameter("@address ", SqlDbType.VarChar, 50);
SqlParameter officeaddressParameter = new SqlParameter("@office_address ", SqlDbType.VarChar, 50);
SqlParameter officenoParameter = new SqlParameter("@Office_no ", SqlDbType.VarChar, 50);
SqlParameter cnicnoParameter = new SqlParameter("@CNIC_No ", SqlDbType.VarChar, 20);
SqlParameter postdesignationParameter = new SqlParameter("@Post_Designation ", SqlDbType.VarChar, 50);
SqlParameter salaryanumParameter = new SqlParameter("@Salary_Anum ", SqlDbType.VarChar, 20);
SqlParameter generalidoutParameter = new SqlParameter("@general_id_out ", SqlDbType.Int);
SqlParameter parentidoutParameter = new SqlParameter("@parent_id_out ", SqlDbType.VarChar, 50);
SqlParameter dobidParameter = new SqlParameter("@dob_id ", SqlDbType.Int);
SqlParameter dayParameter = new SqlParameter("@day", SqlDbType.Int);
SqlParameter monthParameter = new SqlParameter("@month ", SqlDbType.Int);
SqlParameter yearParameter = new SqlParameter("@year", SqlDbType.Int);
SqlParameter dobidoutParameter = new SqlParameter("@dob_id_out ", SqlDbType.Int);
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 postalParameter = new SqlParameter("@postal_code", SqlDbType.Int);
SqlParameter locidoutidParameter = 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 usertypeParameter = new SqlParameter("@usertype_id", SqlDbType.Int);
SqlParameter logincountParameter = new SqlParameter("@login_count", SqlDbType.Int);
SqlParameter lastloginParameter = new SqlParameter("@last_login_date", SqlDbType.Date);
SqlParameter authorizedidoutParameter = new SqlParameter("@authorized_id_out", SqlDbType.VarChar, 20);
parentidParameter.Value = GenerateParentID(firstname, lastname);
generalidParameter.Value = Convert.ToInt32(genaralid) + 1;
firstnameParameter.Value = firstname;
lastnameParameter.Value = lastname;
nationalityParameter.Value = nationality;
genderParameter.Value = gender;
photoParameter.Value = photo;
religionParameter.Value = religion;
phoneParameter.Value = phone;
addressParameter.Value = address;
officeaddressParameter.Value = officeaddress;
officenoParameter.Value = officeno;
cnicnoParameter.Value = cnicno;
postdesignationParameter.Value = postdesignation;
salaryanumParameter.Value = salaryanum;
generalidoutParameter.Direction = ParameterDirection.Output;
parentidoutParameter.Direction = ParameterDirection.Output;
dobidParameter.Value = Convert.ToInt32(dobid) + 1;
dayParameter.Value = Convert.ToInt32(dob.Substring(2, 2));
monthParameter.Value = Convert.ToInt32(dob.Substring(0, 1));
yearParameter.Value = Convert.ToInt32(dob.Substring(0, 4));
dobidoutParameter.Direction = ParameterDirection.Output;
locidParameter.Value = Convert.ToInt32(locationid) + 1;
countryidParameter.Value = country_id;
cityidParameter.Value = city_id;
postalParameter.Value = postalcode;
locidoutidParameter.Direction = ParameterDirection.Output;
authorizedidParameter.Value = GenerateAuthorizedID(username, accountpin.ToString());
usernameParameter.Value = username;
passwordParameter.Value = password;
accountpinParameter.Value = accountpin;
primaryemailParameter.Value = primaryemail;
secondaryemailParameter.Value = secondaryemail;
usertypeParameter.Value = 3;
logincountParameter.Value = 0;
lastloginParameter.Value = Convert.ToDateTime(Jfunctionparents.GetSystemDate());
authorizedidoutParameter.Direction = ParameterDirection.Output;
mdata.obj_sqlcommand.Parameters.Add(parentidParameter);
mdata.obj_sqlcommand.Parameters.Add(generalidParameter);
mdata.obj_sqlcommand.Parameters.Add(firstnameParameter);
mdata.obj_sqlcommand.Parameters.Add(lastnameParameter);
mdata.obj_sqlcommand.Parameters.Add(nationalityParameter);
mdata.obj_sqlcommand.Parameters.Add(genderParameter);
mdata.obj_sqlcommand.Parameters.Add(photoParameter);
mdata.obj_sqlcommand.Parameters.Add(religionParameter);
mdata.obj_sqlcommand.Parameters.Add(phoneParameter);
mdata.obj_sqlcommand.Parameters.Add(addressParameter);
mdata.obj_sqlcommand.Parameters.Add(officeaddressParameter);
mdata.obj_sqlcommand.Parameters.Add(officenoParameter);
mdata.obj_sqlcommand.Parameters.Add(cnicnoParameter);
mdata.obj_sqlcommand.Parameters.Add(postdesignationParameter);
mdata.obj_sqlcommand.Parameters.Add(salaryanumParameter);
mdata.obj_sqlcommand.Parameters.Add(generalidoutParameter);
mdata.obj_sqlcommand.Parameters.Add(parentidoutParameter);
mdata.obj_sqlcommand.Parameters.Add(dobidParameter);
mdata.obj_sqlcommand.Parameters.Add(dayParameter);
mdata.obj_sqlcommand.Parameters.Add(monthParameter);
mdata.obj_sqlcommand.Parameters.Add(yearParameter);
mdata.obj_sqlcommand.Parameters.Add(dobidoutParameter);
mdata.obj_sqlcommand.Parameters.Add(locidParameter);
mdata.obj_sqlcommand.Parameters.Add(countryidParameter);
mdata.obj_sqlcommand.Parameters.Add(cityidParameter);
mdata.obj_sqlcommand.Parameters.Add(postalParameter);
mdata.obj_sqlcommand.Parameters.Add(locidoutidParameter);
mdata.obj_sqlcommand.Parameters.Add(authorizedidParameter);
mdata.obj_sqlcommand.Parameters.Add(usernameParameter);
mdata.obj_sqlcommand.Parameters.Add(passwordParameter);
mdata.obj_sqlcommand.Parameters.Add(accountpinParameter);
mdata.obj_sqlcommand.Parameters.Add(primaryemailParameter);
mdata.obj_sqlcommand.Parameters.Add(secondaryemailParameter);
mdata.obj_sqlcommand.Parameters.Add(usertypeParameter);
mdata.obj_sqlcommand.Parameters.Add(logincountParameter);
mdata.obj_sqlcommand.Parameters.Add(lastloginParameter);
mdata.obj_sqlcommand.Parameters.Add(authorizedidoutParameter);
try
{
mdata.OpenConnection();
if (mdata.obj_sqlcommand.ExecuteNonQuery() > 0)
{
return("true");
}
else
{
return("false");
}
}
catch (Exception ex)
{
return("false" + ex.ToString());
}
finally
{
mdata.obj_sqlcommand.Dispose();
mdata.obj_sqlconnection.Dispose();
mdata.obj_sqlcommand.Parameters.Clear();
mdata.CloseConnection();
}
}
public string PopulateTeacherProfileInformationByID(int _teacherID, string _schoolID)
{
string returnvalue = "true";
if (_teacherID != null)
{
string[] teacheridToBeFiltered = { _teacherID.ToString(), _schoolID };
if (Jvalidate.FilterBlackLIstKeywords(teacheridToBeFiltered))
{
string secureTeacherid = Jvalidate.RemoveHtmlTags(_teacherID.ToString());
mydb.CreateConnection();
mydb.InitializeSQLCommandObject(mydb.GetCurrentConnection, "select * from View_TeacherProfile where teacher_id=" + _teacherID + " and school_id='" + JSchool.SchoolID + "';");
try
{
mydb.OpenConnection();
mydb.obj_reader = mydb.obj_sqlcommand.ExecuteReader();
if (mydb.obj_reader.HasRows)
{
while (mydb.obj_reader.Read())
{
CountryID = Convert.ToInt32(mydb.obj_reader["country_id"]);
Country = mydb.obj_reader["country"].ToString();
FirstName = mydb.obj_reader["firstname"].ToString();
LastName = mydb.obj_reader["lastname"].ToString();
Nationality = mydb.obj_reader["Nationality"].ToString();
Gender = mydb.obj_reader["Gender"].ToString();
Photo = mydb.obj_reader["photo"].ToString();
Religion = mydb.obj_reader["religion"].ToString();
Phone = mydb.obj_reader["phone"].ToString();
Address = mydb.obj_reader["address"].ToString();
Day = Convert.ToInt32(mydb.obj_reader["day"]);
Month = Convert.ToInt32(mydb.obj_reader["month"]);
Year = Convert.ToInt32(mydb.obj_reader["year"]);
DOBID = Convert.ToInt32(mydb.obj_reader["dob_id"]);
LocationID = Convert.ToInt32(mydb.obj_reader["loc_id"]);
CityID = Convert.ToInt32(mydb.obj_reader["city_id"]);
City = mydb.obj_reader["city"].ToString();
PostalCode = Convert.ToInt32(mydb.obj_reader["postal_code"]);
Username = mydb.obj_reader["username"].ToString();
Password = mydb.obj_reader["password"].ToString();
AccountPin = Convert.ToInt32(mydb.obj_reader["account_pin"]);
PrimaryEmail = mydb.obj_reader["primary_email"].ToString();
SecondaryEmail = mydb.obj_reader["secondary_email"].ToString();
UserTypeID = Convert.ToInt32(mydb.obj_reader["usertype_id"]);
LoginCount = Convert.ToInt32(mydb.obj_reader["login_count"]);
LastLoginDate = mydb.obj_reader["last_login_date"].ToString();
UserType = mydb.obj_reader["usertype"].ToString();
TeacherID = Convert.ToInt32(mydb.obj_reader["teacher_id"]);
GeneralID = Convert.ToInt32(mydb.obj_reader["General_Id"]);
AuthorizeID = mydb.obj_reader["authorized_id"].ToString();
DateOfJoin = mydb.obj_reader["date_of_join"].ToString();
CNIC = mydb.obj_reader["cnic_no"].ToString();
SchoolID = mydb.obj_reader["school_id"].ToString();
}
}
else
{
returnvalue = "false";
}
}
catch (Exception ex)
{
HttpContext.Current.Response.Write(ex.ToString());
}
finally
{
mydb.CloseConnection();
mydb.obj_reader.Dispose();
mydb.obj_reader.Close();
}
}
}
return(returnvalue);
}
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();
}
}
public string UpdateStudentInformation(int _dob_id, string _dateofbirth, int _loc_id, int _city_id, int _postal_code, int _class_sec_info_id, int _class_id, int _section_id, string _student_id, string _guardianName, string _previous_school, string _last_class_attended, string _guardian_contact, string _firstname, string _lastname, string _nationality, string _religion, string _phone, string _gender, string _address, int _general_id)
{
string returnValue = string.Empty;
int day, month, year;
day = Convert.ToInt32(_dateofbirth.Substring(0, 2));
month = Convert.ToInt32(_dateofbirth.Substring(3, 2));
year = Convert.ToInt32(_dateofbirth.Substring(_dateofbirth.Length - 4, 4));
jstudentDatabase.CreateConnection();
jstudentDatabase.InitializeSQLCommandObject(jstudentDatabase.GetCurrentConnection, "spUpdateStudentInformationByAdmin", true);
SqlParameter p_dobID = new SqlParameter("@dob_id", SqlDbType.Int);
SqlParameter p_day = new SqlParameter("@day", SqlDbType.Int);
SqlParameter p_month = new SqlParameter("@month", SqlDbType.Int);
SqlParameter p_year = new SqlParameter("@year", SqlDbType.Int);
SqlParameter p_cityID = new SqlParameter("@city_id", SqlDbType.Int);
SqlParameter p_postalCode = new SqlParameter("@postal_code", SqlDbType.Int);
SqlParameter p_classSectionInfo = new SqlParameter("@class_sec_info_id", SqlDbType.Int);
SqlParameter p_classID = new SqlParameter("@class_id", SqlDbType.Int);
SqlParameter p_sectionID = new SqlParameter("@section_id", SqlDbType.Int);
SqlParameter p_studentid = new SqlParameter("@student_id", SqlDbType.VarChar, 50);
SqlParameter p_guardianName = new SqlParameter("@guardianName", SqlDbType.VarChar, 50);
SqlParameter p_previousSchool = new SqlParameter("@previousSchool", SqlDbType.VarChar, 50);
SqlParameter p_lastClassAttended = new SqlParameter("@last_class_attended", SqlDbType.VarChar, 10);
SqlParameter p_guardianContact = new SqlParameter("@guardianContact", SqlDbType.VarChar, 50);
SqlParameter p_firstname = new SqlParameter("@firstname", SqlDbType.VarChar, 50);
SqlParameter p_lastname = new SqlParameter("@lastname", SqlDbType.VarChar, 50);
SqlParameter p_nationality = new SqlParameter("@nationality", SqlDbType.VarChar, 15);
SqlParameter p_religion = new SqlParameter("@religion", SqlDbType.VarChar, 20);
SqlParameter p_phone = new SqlParameter("@phone", SqlDbType.VarChar, 50);
SqlParameter p_gender = new SqlParameter("@gender", SqlDbType.VarChar, 7);
SqlParameter p_address = new SqlParameter("@address", SqlDbType.VarChar, 50);
SqlParameter p_generalid = new SqlParameter("@general_id", SqlDbType.Int);
SqlParameter p_locID = new SqlParameter("@loc_id", SqlDbType.Int);
p_dobID.Value = _dob_id;
p_day.Value = day;
p_month.Value = month;
p_year.Value = year;
p_cityID.Value = _city_id;
p_postalCode.Value = _postal_code;
p_classSectionInfo.Value = _class_sec_info_id;
p_classID.Value = _class_id;
p_sectionID.Value = _section_id;
p_studentid.Value = _student_id;
p_guardianName.Value = _guardianName;
p_previousSchool.Value = _previous_school;
p_lastClassAttended.Value = _last_class_attended;
p_guardianContact.Value = _guardian_contact;
p_firstname.Value = _firstname;
p_lastname.Value = _lastname;
p_nationality.Value = _nationality;
p_religion.Value = _religion;
p_phone.Value = _phone;
p_gender.Value = _gender;
p_address.Value = _address;
p_generalid.Value = _general_id;
p_locID.Value = _loc_id;
jstudentDatabase.obj_sqlcommand.Parameters.Add(p_dobID);
jstudentDatabase.obj_sqlcommand.Parameters.Add(p_day);
jstudentDatabase.obj_sqlcommand.Parameters.Add(p_month);
jstudentDatabase.obj_sqlcommand.Parameters.Add(p_year);
jstudentDatabase.obj_sqlcommand.Parameters.Add(p_cityID);
jstudentDatabase.obj_sqlcommand.Parameters.Add(p_postalCode);
jstudentDatabase.obj_sqlcommand.Parameters.Add(p_classSectionInfo);
jstudentDatabase.obj_sqlcommand.Parameters.Add(p_sectionID);
jstudentDatabase.obj_sqlcommand.Parameters.Add(p_studentid);
jstudentDatabase.obj_sqlcommand.Parameters.Add(p_guardianName);
jstudentDatabase.obj_sqlcommand.Parameters.Add(p_previousSchool);
jstudentDatabase.obj_sqlcommand.Parameters.Add(p_lastClassAttended);
jstudentDatabase.obj_sqlcommand.Parameters.Add(p_guardianContact);
jstudentDatabase.obj_sqlcommand.Parameters.Add(p_firstname);
jstudentDatabase.obj_sqlcommand.Parameters.Add(p_lastname);
jstudentDatabase.obj_sqlcommand.Parameters.Add(p_nationality);
jstudentDatabase.obj_sqlcommand.Parameters.Add(p_religion);
jstudentDatabase.obj_sqlcommand.Parameters.Add(p_phone);
jstudentDatabase.obj_sqlcommand.Parameters.Add(p_gender);
jstudentDatabase.obj_sqlcommand.Parameters.Add(p_address);
jstudentDatabase.obj_sqlcommand.Parameters.Add(p_generalid);
jstudentDatabase.obj_sqlcommand.Parameters.Add(p_locID);
jstudentDatabase.obj_sqlcommand.Parameters.Add(p_classID);
try
{
jstudentDatabase.OpenConnection();
if (jstudentDatabase.obj_sqlcommand.ExecuteNonQuery() > 0)
{
returnValue = "true";
}
else
{
returnValue = "false";
}
}
catch (Exception exception)
{
HttpContext.Current.Response.Write(exception.ToString());
}
finally
{
jstudentDatabase.CloseConnection();
jstudentDatabase.obj_sqlcommand.Dispose();
}
return(returnValue);
}
