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