public void NextNumber_ReturnsNumberChar()
{
for (int i = 0; i < 1000; i++)
{
char num = RandomChar.NextNumber();
Assert.IsTrue(char.IsDigit(num));
}
}
public void NextAlphabet_ReturnsRandomAlphabetChar()
{
for (int i = 0; i < 1000; i++)
{
char randomChar = RandomChar.NextAlphabet();
Assert.IsTrue(char.IsLetter(randomChar));
}
}
public void Next_ValidChar()
{
for (int i = 0; i < 1000; i++)
{
char randomChar = RandomChar.NextAlphabet();
int asciiNum = randomChar;
Assert.IsTrue(asciiNum < 128 && asciiNum >= 0);
}
}
public void NextNumber_ReturnsSpecialChar()
{
for (int i = 0; i < 1000; i++)
{
char special = RandomChar.NextSpecialCharacter();
Assert.IsFalse(char.IsDigit(special));
Assert.IsFalse(char.IsNumber(special));
}
}
protected void btn_Add_Profile_Click(object sender, EventArgs e)
{
try {
SqlCommand CHECKSCH = new SqlCommand();
CHECKSCH.Connection = conn;
CHECKSCH.CommandType = CommandType.Text;
CHECKSCH.CommandText = "SELECT COUNT(*) FROM SCHOOLPROFILE WHERE ([SCHOOLCODE] = @SCHOOLCODE)";
CHECKSCH.Parameters.AddWithValue("@SCHOOLCODE", txt_sc_code.Text);
int EXISTS = (int)CHECKSCH.ExecuteScalar();
if (EXISTS > 0)
{
ShowMessage("This School with id ='" + txt_sc_code.Text + "' is already Registered.");
}
else
{
if (file.HasFile == true)
{
String contenttype = file.PostedFile.ContentType;
if (contenttype == "image/jpeg" || contenttype == "image/jpg" || contenttype == "image/png")
{
int filesize;
filesize = file.PostedFile.ContentLength;
if (filesize <= 102400)
{
string chr = RandomChar.GetRandomPassword(5).ToString();
string folderPath = Request.PhysicalApplicationPath + "./Global_Images/";
string filename = chr + Path.GetFileName(file.PostedFile.FileName);
file.PostedFile.SaveAs(Server.MapPath("~/Global_Images/") + filename);
SqlCommand cmd = new SqlCommand("ADDPROFILE", conn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@SCHOOLCODE", SqlDbType.NVarChar, 50).Value = txt_sc_code.Text.ToString();
cmd.Parameters.Add("@SCHOOLDESC", SqlDbType.VarChar, 50).Value = txt_br_code.Text.ToString();
cmd.Parameters.Add("@SCHOOLNAME", SqlDbType.VarChar, 255).Value = txt_schoolname.Text.ToString();
cmd.Parameters.Add("@PRIMARYCT", SqlDbType.VarChar, 255).Value = txt_ct_no.Text.ToString();
cmd.Parameters.Add("@ALTERNACT", SqlDbType.VarChar, 255).Value = txt_alt_no.Text.ToString();
cmd.Parameters.Add("@GSTIN", SqlDbType.VarChar, 100).Value = txt_gstin.Text.ToString();
cmd.Parameters.Add("@BRANCHNAME", SqlDbType.VarChar, 100).Value = txt_br_name.Text.ToString();
cmd.Parameters.Add("@BRANCHTYPE", SqlDbType.VarChar, 100).Value = txt_br_type.Text.ToString();
cmd.Parameters.Add("@ESTDATE", SqlDbType.VarChar, 100).Value = txt_est_dt.Text.ToString();
cmd.Parameters.Add("@REGDATE", SqlDbType.VarChar, 100).Value = txt_reg_dt.Text.ToString();
cmd.Parameters.Add("@ADDRESS1", SqlDbType.VarChar, 255).Value = txt_add1.Text.ToString();
cmd.Parameters.Add("@ADDRESS2", SqlDbType.VarChar, 255).Value = txt_Add2.Text.ToString();
cmd.Parameters.Add("@COUNTRY", SqlDbType.VarChar, 255).Value = country_list.SelectedItem.Text;
cmd.Parameters.Add("@STATE", SqlDbType.VarChar, 255).Value = state_list.SelectedItem.Text;
cmd.Parameters.Add("@CITY", SqlDbType.VarChar, 255).Value = city_list.SelectedItem.Text;
cmd.Parameters.Add("@PINCODE", SqlDbType.VarChar, 50).Value = txt_zip.Text.ToString();
cmd.ExecuteNonQuery();
ShowMessage("Added Successfully");
Response.Redirect("frmSchoolProfile.aspx");
}
else
{
ShowMessage("File Size exceeds 100 KB - Please Upload File Size Maximum 100 KB");
}
}
else
{
ShowMessage("Only JPEG/JPG/PNG Image File Acceptable - Please Upload Image File Again");
}
}
else
{
ShowMessage("You have not selected any file - Browse and Select File First");
}
}
}
catch (Exception ex) { ex.ToString(); }
}
protected void Add_Student_Click(object sender, EventArgs e)
{
try
{
SqlCommand check_Perperty = new SqlCommand();
conn.Open();
check_Perperty.Connection = conn;
check_Perperty.CommandType = CommandType.Text;
check_Perperty.CommandText = "SELECT COUNT(*) FROM ST_PROFILE WHERE ([STUDENTID] = @studentid and school_code='" + Session["schoolcode"].ToString() + "' and branch='" + Session["Branch"].ToString() + "')";
check_Perperty.Parameters.AddWithValue("@studentid", txt_std_id.Text);
int PropertyExist = (int)check_Perperty.ExecuteScalar();
if (PropertyExist > 0)
{
ShowMessage("This student with id ='" + txt_std_id + "' is already enrolled.");
}
else
{
if (file.HasFile == true)
{
String contenttype = file.PostedFile.ContentType;
if (contenttype == "image/jpeg" || contenttype == "image/jpg" || contenttype == "image/png")
{
int filesize;
filesize = file.PostedFile.ContentLength;
if (filesize <= 102400)
{
string chr = RandomChar.GetRandomPassword(5).ToString();
string folderPath = Request.PhysicalApplicationPath + "./StudentImage/";
if (!Directory.Exists(folderPath))
{
Directory.CreateDirectory(folderPath);
}
string filename = chr + Path.GetFileName(file.PostedFile.FileName);
file.PostedFile.SaveAs(Server.MapPath("~/StudentImage/") + filename);
SqlCommand cmd = new SqlCommand("ADD_STPROFILE", conn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@IMAGELINK", SqlDbType.VarChar, 50).Value = filename.ToString();
cmd.Parameters.Add("@STUDENTID", SqlDbType.NVarChar, 10).Value = txt_std_id.Text.ToString();
cmd.Parameters.Add("@FIRSTNAME", SqlDbType.VarChar, 50).Value = txt_fname.Text.ToString();
cmd.Parameters.Add("@LASTNAME", SqlDbType.VarChar, 50).Value = txt_lname.Text.ToString();
cmd.Parameters.Add("@AADHAAR", SqlDbType.VarChar, 50).Value = txt_adhar.Text.ToString();
cmd.Parameters.Add("@DATEOFBIRTH", SqlDbType.VarChar, 50).Value = txt_dob.Text.ToString();
cmd.Parameters.Add("@GENDER", SqlDbType.VarChar, 50).Value = gender.SelectedItem.ToString();
cmd.Parameters.Add("@RELIGION", SqlDbType.VarChar, 50).Value = religion_list.SelectedItem.Text.ToString();
cmd.Parameters.Add("@CATEGORY", SqlDbType.VarChar, 50).Value = category.SelectedItem.ToString();
cmd.Parameters.Add("@ADD1", SqlDbType.VarChar, 50).Value = txt_add1.Text.ToString();
cmd.Parameters.Add("@ADD2", SqlDbType.VarChar, 50).Value = txt_Add2.Text.ToString();
cmd.Parameters.Add("@COUNTRY", SqlDbType.VarChar, 50).Value = country_list.SelectedItem.Text.ToString();
cmd.Parameters.Add("@STATE", SqlDbType.VarChar, 50).Value = state_list.SelectedItem.Text.ToString();
cmd.Parameters.Add("@CITY", SqlDbType.VarChar, 50).Value = city_list.SelectedItem.Text.ToString();
cmd.Parameters.Add("@PINCODE", SqlDbType.VarChar, 50).Value = txt_zip.Text.ToString();
cmd.Parameters.Add("@FATHERNAME", SqlDbType.VarChar, 50).Value = txt_father_name.Text.ToString();
cmd.Parameters.Add("@FATHEROCCUP", SqlDbType.VarChar, 50).Value = txt_father_occ.Text.ToString();
cmd.Parameters.Add("@FATHEREMAIL", SqlDbType.VarChar, 50).Value = txt_ftemail.Text.ToString();
cmd.Parameters.Add("@FATHERINFO", SqlDbType.VarChar, 50).Value = txt_father_number.Text.ToString();
cmd.Parameters.Add("@MOTHERNAME", SqlDbType.VarChar, 50).Value = txt_mother_name.Text.ToString();
cmd.Parameters.Add("@MOTHEROCCUP", SqlDbType.VarChar, 50).Value = txt_mother_occ.Text.ToString();
cmd.Parameters.Add("@MOTHEREMAIL", SqlDbType.VarChar, 50).Value = txt_mtemail.Text.ToString();
cmd.Parameters.Add("@MOTHERINFO", SqlDbType.VarChar, 50).Value = txt_mother_number.Text.ToString();
cmd.Parameters.Add("school_code", SqlDbType.VarChar, 100).Value = Session["schoolcode"].ToString();
cmd.Parameters.Add("branch", SqlDbType.VarChar, 100).Value = Session["Branch"].ToString();
cmd.ExecuteNonQuery();
saveAcademicDetails();
ShowMessage("Added Successfully");
Response.Redirect("frmNewAdms.aspx");
}
else
{
ShowMessage("File Size exceeds 100 KB - Please Upload File Size Maximum 100 KB");
}
}
else
{
ShowMessage("Only JPEG/JPG/PNG Image File Acceptable - Please Upload Image File Again");
}
}
else
{
ShowMessage("You have not selected any file - Browse and Select File First");
}
}
conn.Close();
}
catch (Exception ex) { ex.ToString(); }
}
