public int Delete(tblQuesBankDetails obj)
{
if (cnnstr.State == ConnectionState.Closed)
{
cnnstr.Open();
}
sql = "delete from tblQuesBankDetails where QdID = " + obj.QdID + "";
scmd = new SqlCommand(sql, cnnstr);
scmd.ExecuteNonQuery();
cnnstr.Close();
return(1);
}
public DataTable GetSingleRecord(tblQuesBankDetails obj)
{
if (cnnstr.State == ConnectionState.Closed)
{
cnnstr.Open();
}
//sql = "Select * from tblQuesBankDetails where QdID = " + obj.QdID + "";
sql = "select a.* ,b.* from tblQuesBankDetails a left join tblQuesBankMst b on a.QID = b.QID where a.QdID = " + obj.QdID + "";
SqlDataAdapter adp = new SqlDataAdapter(sql, cnnstr);
DataTable dt = new DataTable();
adp.Fill(dt);
cnnstr.Close();
return(dt);
}
public int Insert(tblQuesBankDetails obj)
{
if (cnnstr.State == ConnectionState.Closed)
{
cnnstr.Open();
}
sql = "Insert Into tblQuesBankDetails (QID,Question,Ans1,Ans2,Ans3,Ans4,CorrectAns) values (@QID,@Question,@Ans1,@Ans2,@Ans3,@Ans4,@CorrectAns)";
scmd = new SqlCommand(sql, cnnstr);
scmd.Parameters.AddWithValue("@QID", obj.QID);
scmd.Parameters.AddWithValue("@Question", obj.Question);
scmd.Parameters.AddWithValue("@Ans1", obj.Ans1);
scmd.Parameters.AddWithValue("@Ans2", obj.Ans2);
scmd.Parameters.AddWithValue("@Ans3", obj.Ans3);
scmd.Parameters.AddWithValue("@Ans4", obj.Ans4);
scmd.Parameters.AddWithValue("@CorrectAns", obj.CorrectAns);
scmd.ExecuteNonQuery();
cnnstr.Close();
return(1);
}
public int Update(tblQuesBankDetails obj)
{
if (cnnstr.State == ConnectionState.Closed)
{
cnnstr.Open();
}
//sql = "Update tblQuesBankMst set Subject = '" + obj.Subject + "', QuesBankName = '" + obj.QuesBankName + "' where QID = " + obj.QID + " ";
sql = "update tblQuesBankDetails set QID = @QID , Question = @Question,Ans1 = @Ans1,Ans2 = @Ans2,Ans3= @Ans3,Ans4= @Ans4,CorrectAns= @CorrectAns where QdID = @QdID ";
scmd = new SqlCommand(sql, cnnstr);
scmd.Parameters.AddWithValue("@QID", obj.QID);
scmd.Parameters.AddWithValue("@Question", obj.Question);
scmd.Parameters.AddWithValue("@Ans1", obj.Ans1);
scmd.Parameters.AddWithValue("@Ans2", obj.Ans2);
scmd.Parameters.AddWithValue("@Ans3", obj.Ans3);
scmd.Parameters.AddWithValue("@Ans4", obj.Ans4);
scmd.Parameters.AddWithValue("@CorrectAns", obj.CorrectAns);
scmd.Parameters.AddWithValue("@QdID", obj.QdID);
scmd.ExecuteNonQuery();
cnnstr.Close();
return(1);
}
