/// <summary>
/// Purpose : To Change Password For Selected User Into tblregistration Table.
/// </summary>
/// <param name="@Password"></param>
/// <param name="@UserName"></param>
/// <param name="@UserID"></param>
public void ChangePassword(E_BuzzProperties PS)
{
cmd = new SqlCommand("sp_ChangePassword", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@Password", PS.Password);
cmd.Parameters.AddWithValue("@UserName", PS.UserName);
cmd.Parameters.AddWithValue("@UserID", PS.UserId);
con.Open();
cmd.ExecuteNonQuery();
con.Close();
}
public void InsertExamination(E_BuzzProperties PS)
{
cmd = new SqlCommand("sp_InsertExamination", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@ExamName", PS.ExamName);
cmd.Parameters.AddWithValue("@ExamDateTime", PS.ExamDate);
cmd.Parameters.AddWithValue("@ExamDetail", PS.ExamDetail);
cmd.Parameters.AddWithValue("@FK_CategoryID", PS.CategoryId);
con.Open();
cmd.ExecuteNonQuery();
con.Close();
}
public void InsertCategoryExamination(E_BuzzProperties PS)
{
cmd = new SqlCommand("sp_InsertCategoryExamination", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@Question", PS.Question);
cmd.Parameters.AddWithValue("@OptionA", PS.OptionA);
cmd.Parameters.AddWithValue("@OptionB", PS.OptionB);
cmd.Parameters.AddWithValue("@OptionC", PS.OptionC);
cmd.Parameters.AddWithValue("@OptionD", PS.OptionD);
cmd.Parameters.AddWithValue("@Answer", PS.Answer);
cmd.Parameters.AddWithValue("@FK_CategoryID", PS.CategoryId);
con.Open();
cmd.ExecuteNonQuery();
con.Close();
}
public void InsertContactUs(E_BuzzProperties PS)
{
cmd = new SqlCommand("sp_InsertContactUs", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@Name", PS.Name);
cmd.Parameters.AddWithValue("@Email", PS.EmailId);
cmd.Parameters.AddWithValue("@MobileNo", PS.Mobileno);
cmd.Parameters.AddWithValue("@Message", PS.Message);
cmd.Parameters.AddWithValue("@MessageDateTime", DateTime.Now);
con.Open();
cmd.ExecuteNonQuery();
con.Close();
}
public DataTable SearchEngineeringExam(E_BuzzProperties PS)
{
cmd = new SqlCommand("sp_SearchEngineeringExam", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@FK_CategoryID", PS.CategoryId);
da = new SqlDataAdapter(cmd);
dt = new DataTable();
da.Fill(dt);
return dt;
}
/// <summary>
/// Purpose : To Retrive All State Data From tblstate Table.
/// </summary>
/// <param name="@FK_CountryID"></param>
/// <returns></returns>
public DataTable ShowStateReg(E_BuzzProperties PS)
{
cmd = new SqlCommand("sp_ShowStateReg", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@FK_CountryID", PS.CountryId);
da = new SqlDataAdapter(cmd);
dt = new DataTable();
da.Fill(dt);
return dt;
}
public void UpdateUserProfile(E_BuzzProperties PS)
{
cmd = new SqlCommand("sp_UpdateUserProfile", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@FirstName", PS.FirstName);
cmd.Parameters.AddWithValue("@LastName", PS.LastName);
cmd.Parameters.AddWithValue("@UserName", PS.UserName);
cmd.Parameters.AddWithValue("@Email", PS.Email);
cmd.Parameters.AddWithValue("@MobileNo", PS.MobileNo);
cmd.Parameters.AddWithValue("@Gender", PS.Gender);
cmd.Parameters.AddWithValue("@DOB", PS.DateOfBirth);
cmd.Parameters.AddWithValue("@Photo", PS.Photos);
cmd.Parameters.AddWithValue("@Resume", PS.Resume);
cmd.Parameters.AddWithValue("@SecurityQuestion", PS.SecurityQuestion);
cmd.Parameters.AddWithValue("@SecurityAnswer", PS.SecurityAnswer);
cmd.Parameters.AddWithValue("@FK_CountryID", PS.CountryId);
cmd.Parameters.AddWithValue("@FK_StateID", PS.StateId);
cmd.Parameters.AddWithValue("@FK_CityID", PS.CityId);
cmd.Parameters.AddWithValue("@UserID", PS.UserId);
con.Open();
cmd.ExecuteNonQuery();
con.Close();
}
/// <summary>
/// Purpose : To Insert Sub Category Data Into tblsubcategory Table.
/// </summary>
/// <param name="@SubCategoryName"></param>
/// <param name="@FK_CategoryID"></param>
public void InsertSubCategory(E_BuzzProperties PS)
{
cmd = new SqlCommand("sp_InsertSubCategory", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@SubCategoryName", PS.SubCategoryName);
cmd.Parameters.AddWithValue("@FK_CategoryID", PS.CategoryId);
con.Open();
cmd.ExecuteNonQuery();
con.Close();
}
/// <summary>
/// Purpose : To Update Country Name Into tblcountry Table.
/// </summary>
/// <param name="@CountryName"></param>
/// <param name="@CountryID"></param>
public void UpdateCountry(E_BuzzProperties PS)
{
cmd = new SqlCommand("sp_UpdateCountry", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@CountryName", PS.CountryName);
cmd.Parameters.AddWithValue("@CountryID", PS.CountryId);
con.Open();
cmd.ExecuteNonQuery();
con.Close();
}
/// <summary>
/// Purpose : To Update EBook Data Into tblebook Table.
/// </summary>
/// <param name="@BookName"></param>
/// <param name="@BookFile"></param>
/// <param name="@FK_CategoryID"></param>
/// <param name="@FK_SubCategoryID"></param>
/// <param name="@BookID"></param>
public void UpdateEBook(E_BuzzProperties PS)
{
cmd = new SqlCommand("sp_UpdateEBook", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@BookName", PS.BookName);
cmd.Parameters.AddWithValue("@BookFile", PS.BookFile);
cmd.Parameters.AddWithValue("@FK_CategoryID", PS.CategoryId);
cmd.Parameters.AddWithValue("@FK_SubCategoryID", PS.SubCategoryId);
cmd.Parameters.AddWithValue("@BookID", PS.BookId);
con.Open();
cmd.ExecuteNonQuery();
con.Close();
}
/// <summary>
/// Purpose : To Update Collage Data Into tblcollage Table.
/// </summary>
/// <param name="@CollageName"></param>
/// <param name="@CollageDetail"></param>
/// <param name="@FK_CategoryID"></param>
/// <param name="@FK_SubCategoryID"></param>
/// <param name="@CollageID"></param>
public void UpdateCollage(E_BuzzProperties PS)
{
cmd = new SqlCommand("sp_UpdateCollage", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@CollageName", PS.CollageName);
cmd.Parameters.AddWithValue("@CollageLink", PS.CollageLink);
cmd.Parameters.AddWithValue("@CollageDetail", PS.CollageDetail);
cmd.Parameters.AddWithValue("@FK_CategoryID", PS.CategoryId);
cmd.Parameters.AddWithValue("@FK_SubCategoryID", PS.SubCategoryId);
cmd.Parameters.AddWithValue("@CollageID", PS.CollageId);
con.Open();
cmd.ExecuteNonQuery();
con.Close();
}
/// <summary>
/// Purpose : To Update Career Data Into tblcareer Table.
/// </summary>
/// <param name="@CareerName"></param>
/// <param name="@CareerDetails"></param>
/// <param name="@FK_CategoryID"></param>
/// <param name="@FK_CategoryID"></param>
/// <param name="@CareerID"></param>
public void UpdateCareer(E_BuzzProperties PS)
{
cmd = new SqlCommand("sp_UpdateCareer", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@CareerName", PS.CareerName);
cmd.Parameters.AddWithValue("@CareerDetails", PS.CareerDetail);
cmd.Parameters.AddWithValue("@FK_CategoryID", PS.CategoryId);
cmd.Parameters.AddWithValue("@FK_SubcategoryID", PS.SubCategoryId);
cmd.Parameters.AddWithValue("@CareerID", PS.CareerId);
con.Open();
cmd.ExecuteNonQuery();
con.Close();
}
public void SubmitStudentStuff(E_BuzzProperties PS)
{
cmd = new SqlCommand("sp_SubmitStudentStuff", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@FK_CategoryID", PS.CategoryId);
cmd.Parameters.AddWithValue("@StudentName", PS.StudentName);
cmd.Parameters.AddWithValue("@Marks", PS.Marks);
cmd.Parameters.AddWithValue("@Date", DateTime.Now);
con.Open();
cmd.ExecuteNonQuery();
con.Close();
}
public void InsertExamResult(E_BuzzProperties PS)
{
cmd = new SqlCommand("sp_InsertExamResult", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@ExamResult", PS.ExamResult);
cmd.Parameters.AddWithValue("@FK_ExamID", PS.ExamId);
con.Open();
cmd.ExecuteNonQuery();
con.Close();
}
/// <summary>
/// Purpose : To Retrive User Data From tblregistration Table.
/// </summary>
/// <param name="@UserName"></param>
/// <param name="@Password"></param>
/// <returns></returns>
public DataTable UserLogInData(E_BuzzProperties PS)
{
cmd = new SqlCommand("sp_UserLogInData", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@Email", PS.Email);
cmd.Parameters.AddWithValue("@Password", PS.Password);
da = new SqlDataAdapter(cmd);
dt = new DataTable();
da.Fill(dt);
return dt;
}
public void InsertRegistration(E_BuzzProperties PS)
{
cmd = new SqlCommand("sp_InsertRegistration", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@FirstName", PS.FirstName);
cmd.Parameters.AddWithValue("@LastName", PS.LastName);
cmd.Parameters.AddWithValue("@UserName", PS.UserName);
cmd.Parameters.AddWithValue("@Password", PS.Password);
cmd.Parameters.AddWithValue("@Email", PS.Email);
cmd.Parameters.AddWithValue("@MobileNo", PS.MobileNo);
cmd.Parameters.AddWithValue("@Gender", PS.Gender);
cmd.Parameters.AddWithValue("@DOB", PS.DateOfBirth);
cmd.Parameters.AddWithValue("@SecurityQuestion", PS.SecurityQuestion);
cmd.Parameters.AddWithValue("@SecurityAnswer", PS.SecurityAnswer);
cmd.Parameters.AddWithValue("@RegDateTime", System.DateTime.Now);
cmd.Parameters.AddWithValue("@IsActive", true);
cmd.Parameters.AddWithValue("@UserPhoto", PS.Photos);
cmd.Parameters.AddWithValue("@UserResume", PS.Resume);
cmd.Parameters.AddWithValue("@FK_CountryID", PS.CountryId);
cmd.Parameters.AddWithValue("@FK_StateID", PS.StateId);
cmd.Parameters.AddWithValue("@FK_CityID", PS.CityId);
con.Open();
cmd.ExecuteNonQuery();
con.Close();
}
public void DeleteCategoryExamination(E_BuzzProperties PS)
{
cmd = new SqlCommand("sp_DeleteCategoryExamination", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@QuestionID", PS.QuestionId);
con.Open();
cmd.ExecuteNonQuery();
con.Close();
}
public DataTable SearchCollages(E_BuzzProperties PS)
{
//cmd = new SqlCommand("sp_SearchCollages", con);
//cmd.CommandType = CommandType.StoredProcedure;
cmd = new SqlCommand("Select * from tblcollage c where c.fkcategoryid=@FK_CategoryID AND c.collagedetail like '%" + PS.StateName + "%'", con);
cmd.Parameters.AddWithValue("@FK_CategoryID", PS.CategoryId);
//cmd.Parameters.AddWithValue("@StateName", PS.StateName);
da = new SqlDataAdapter(cmd);
dt = new DataTable();
da.Fill(dt);
return dt;
}
/// <summary>
/// Purrpose : To Delete Selected Data From tblstate Table.
/// </summary>
/// <param name="PS"></param>
public void DeleteState(E_BuzzProperties PS)
{
cmd = new SqlCommand("sp_DeleteState", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@StateID", PS.StateId);
con.Open();
cmd.ExecuteNonQuery();
con.Close();
}
public DataTable SearchExamResult(E_BuzzProperties PS)
{
cmd = new SqlCommand("sp_SearchExamResult", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@FK_ExamID", PS.ExamId);
da = new SqlDataAdapter(cmd);
dt = new DataTable();
da.Fill(dt);
return dt;
}
public DataTable SelectSecurityQuestion(E_BuzzProperties PS)
{
cmd = new SqlCommand("sp_SelectSecurityQuestion", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@Email", PS.Email);
da = new SqlDataAdapter(cmd);
dt = new DataTable();
da.Fill(dt);
return dt;
}
