public DataTable GetBorrowedBookISBNPerBorrower(eVariable.FIND_TYPE oFilter, string sBookID, string sBorrowerID)
{
try
{
osb.ConnectionString = sConnectionString;
ddq = new DatabaseQuery.DBQuery();
ddq.ConnectionString = osb.ConnectionString;
string sQuery = string.Empty;
switch (oFilter)
{
case eVariable.FIND_TYPE.BOOK_ID:
sQuery = "SELECT BOOK_ID, BOOK_NO, ISBN_NUMBER, REMARKS, [STATUS] FROM TBL_BORROWEDBOOKS WHERE BOOK_ID = '" + sBookID + "' AND [STATUS] = 'BORROWED'";
break;
case eVariable.FIND_TYPE.BORROWER_ID:
sQuery = "SELECT BOOK_ID,BOOK_NO, ISBN_NUMBER, REMARKS, [STATUS] FROM TBL_BORROWEDBOOKS WHERE BOOK_ID = '" + sBookID + "' AND BORROWER_ID = '" + sBorrowerID + "' AND [STATUS] = 'BORROWED' ";
break;
default:
sQuery = "SELECT BOOK_ID, BOOK_NO, ISBN_NUMBER, REMARKS, [STATUS] FROM TBL_BORROWEDBOOKS WHERE [STATUS] = 'BORROWED' ";
break;
}
ddq.CommandText = sQuery;
ds = ddq.GetDataset(CommandType.Text);
return(ds.Tables.Count > 0 ? ds.Tables[0] : null);
}
catch (Exception ex)
{
throw ex;
}
}
public void UpdateBorrower(Model.Borrower oData)
{
try
{
osb.ConnectionString = sConnectionString;
ddq = new DatabaseQuery.DBQuery();
ddq.ConnectionString = osb.ConnectionString;
ddq.CommandText = "SP_UPDATE_BORROWER";
ddq.AddParamer("@BORROWER_ID", SqlDbType.VarChar, oData.PERSON_ID);
ddq.AddParamer("@FIRST_NAME", SqlDbType.VarChar, oData.FIRST_NAME);
ddq.AddParamer("@MIDDLE_NAME", SqlDbType.VarChar, oData.MIDDLE_NAME);
ddq.AddParamer("@LAST_NAME", SqlDbType.VarChar, oData.LAST_NAME);
ddq.AddParamer("@DOB", SqlDbType.VarChar, oData.DOB);
ddq.AddParamer("@AGE", SqlDbType.VarChar, oData.AGE);
ddq.AddParamer("@CONTACT_NO", SqlDbType.VarChar, oData.CONTACT_NO);
ddq.AddParamer("@ADDRESS", SqlDbType.VarChar, oData.ADDRESS);
ddq.AddParamer("@MODIFIED_DATE", SqlDbType.VarChar, oData.MODIFIED_DATE);
ddq.AddParamer("@MODIFIED_BY", SqlDbType.VarChar, oData.MODIFIED_BY);
ddq.AddParamer("@STATUS", SqlDbType.VarChar, oData.STATUS);
ddq.AddParamer("@PROFILE_PIC", SqlDbType.VarChar, oData.PROFILE_PIC);
ddq.ExecuteNonQuery(CommandType.StoredProcedure);
}
catch (Exception ex)
{
throw ex;
}
}
public DataTable GetBookISBN(eVariable.FIND_TYPE o_FindType, string sFindText)
{
try
{
string sQuery = string.Empty;
osb.ConnectionString = sConnectionString;
ddq = new DatabaseQuery.DBQuery();
ddq.ConnectionString = osb.ConnectionString;
switch (o_FindType)
{
case eVariable.FIND_TYPE.BOOK_ID:
sQuery = "SELECT ID, BOOK_NO, ISBN_NUMBER,REMARKS,[STATUS] FROM TBL_BOOKS WHERE ID = '" + sFindText + "'";
break;
case eVariable.FIND_TYPE.BOOK_NO:
sQuery = "SELECT ID, BOOK_NO, ISBN_NUMBER,REMARKS,[STATUS] FROM TBL_BOOKS WHERE BOOK_NO = '" + sFindText + "'";
break;
default:
sQuery = "SELECT ID,BOOK_NO, ISBN_NUMBER,REMARKS,[STATUS] FROM TBL_BOOKS";
break;
}
ddq.CommandText = sQuery;
ds = ddq.GetDataset(CommandType.Text);
return(ds.Tables.Count > 0 ? ds.Tables[0] : null);
}
catch (Exception ex)
{
throw ex;
}
}
public DataTable getCandidatePosition(string sType, string sValue)
{
try
{
osb.ConnectionString = sConnectionString;
ddq = new DatabaseQuery.DBQuery();
ddq.ConnectionString = osb.ConnectionString;
string sQuery = String.Empty;
switch (sType)
{
case "ID":
sQuery = "Select * from tbl_Position where ID LIKE '%" + sValue + "%' and status = 'ACTIVE'";
break;
case "POSITION":
sQuery = "Select * from tbl_Position where Position LIKE '%" + sValue + "5' and status = 'ACTIVE'";
break;
default:
sQuery = "Select * from tbl_Position where Position Like '%" + sValue + "%' and status = 'ACTIVE'";
break;
}
ddq.CommandText = sQuery;
ds = ddq.GetDataset(CommandType.Text);
return(ds.Tables.Count > 0 ? ds.Tables[0] : null);
}
catch (Exception ex)
{
throw ex;
}
}
public void ReturnBook(Model.Transaction oMTransaction)
{
try
{
osb.ConnectionString = sConnectionString;
ddq = new DatabaseQuery.DBQuery();
ddq.ConnectionString = osb.ConnectionString;
ddq.CommandText = "SP_RETURN_BOOK";
ddq.AddParamer("@BOOK_ID", SqlDbType.VarChar, oMTransaction.BOOK_ID);
ddq.AddParamer("@BORROWER_ID", SqlDbType.VarChar, oMTransaction.PERSON_ID);
ddq.AddParamer("@BOOK_NO", SqlDbType.VarChar, oMTransaction.BOOK_NO);
ddq.AddParamer("@MODIFIED_DATE", SqlDbType.VarChar, oMTransaction.MODIFIED_DATE);
ddq.AddParamer("@MODIFIED_BY", SqlDbType.VarChar, oMTransaction.MODIFIED_BY);
ddq.AddParamer("@TOTAL_AMOUNT", SqlDbType.Decimal, oMTransaction.TOTAL_AMOUNT);
ddq.AddParamer("@REMARKS", SqlDbType.VarChar, oMTransaction.REMARKS);
ddq.AddParamer("@STATUS", SqlDbType.VarChar, oMTransaction.STATUS);
ddq.ExecuteNonQuery(CommandType.StoredProcedure);
}
catch (Exception ex)
{
throw ex;
}
}
public DataTable GetCategory(string sType, string sValue)
{
try
{
osb.ConnectionString = sConnectionString;
ddq = new DatabaseQuery.DBQuery();
ddq.ConnectionString = osb.ConnectionString;
string sQuery = String.Empty;
switch (sType)
{
case "INACTIVE":
sQuery = "SELECT * FROM TBL_CATEGORY WHERE [STATUS] = 'INACTIVE'";
break;
case "CATEGORY":
sQuery = "SELECT * FROM TBL_CATEGORY WHERE [STATUS] = 'ACTIVE' AND CATEGORY LIKE '%" + sValue + "%'";
break;
default:
sQuery = "SELECT * FROM TBL_CATEGORY";
break;
}
ddq.CommandText = sQuery;
ds = ddq.GetDataset(CommandType.Text);
return(ds.Tables.Count > 0 ? ds.Tables[0] : null);
}
catch (Exception ex)
{
return(null);
}
}
public DataTable GetRole(String sType, string sFindText)
{
try
{
scb.ConnectionString = sConnectionString;
ddq = new DatabaseQuery.DBQuery();
ddq.ConnectionString = scb.ConnectionString;
string sQuery = "";
switch (sType)
{
case "ROLE":
sQuery = "SELECT * FROM TBL_ROLE WHERE ROLE LIKE '%" + sFindText + "%'";
break;
default:
sQuery = "SELECT * FROM TBL_ROLE WHERE ROLE LIKE '%" + sFindText + "%'";
break;
}
ddq.CommandText = sQuery;
ds = ddq.GetDataset(CommandType.Text);
return(ds.Tables.Count > 0 ? ds.Tables[0] : null);
}
catch (Exception ex)
{
throw ex;
}
}
public void UpdateBookDetails(Model.Transaction oMTransaction)
{
try
{
osb.ConnectionString = sConnectionString;
ddq = new DatabaseQuery.DBQuery();
ddq.ConnectionString = osb.ConnectionString;
ddq.CommandText = "SP_UPDATE_BOOK_DETAILS";
ddq.AddParamer("@ID", SqlDbType.VarChar, oMTransaction.BOOK_ID);
ddq.AddParamer("@BOOK_NO", SqlDbType.VarChar, oMTransaction.BOOK_NO);
ddq.AddParamer("@TITLE", SqlDbType.VarChar, oMTransaction.TITLE);
ddq.AddParamer("@SUBJECT", SqlDbType.VarChar, oMTransaction.SUBJECT);
ddq.AddParamer("@CATEGORY", SqlDbType.VarChar, oMTransaction.CATEGORY);
ddq.AddParamer("@AUTHOR", SqlDbType.VarChar, oMTransaction.AUTHOR);
ddq.AddParamer("@PUBLISH_DATE", SqlDbType.VarChar, oMTransaction.PUBLISH_DATE);
ddq.AddParamer("@LOCATION", SqlDbType.VarChar, oMTransaction.LOCATION);
ddq.AddParamer("@BOOK_PRICE", SqlDbType.VarChar, oMTransaction.BOOK_PRICE);
ddq.AddParamer("@RENT_PRICE", SqlDbType.VarChar, oMTransaction.RENT_PRICE);
ddq.AddParamer("@ISBN_NUMBER", SqlDbType.VarChar, oMTransaction.ISBN_NUMBER);
ddq.AddParamer("@MODIFIED_DATE", SqlDbType.VarChar, oMTransaction.MODIFIED_DATE);
ddq.AddParamer("@MODIFIED_BY", SqlDbType.VarChar, oMTransaction.MODIFIED_BY);
ddq.AddParamer("@REMARKS", SqlDbType.VarChar, oMTransaction.REMARKS);
ddq.AddParamer("@STATUS", SqlDbType.VarChar, oMTransaction.STATUS);
ddq.ExecuteNonQuery(CommandType.StoredProcedure);
}
catch (Exception ex)
{
throw ex;
}
}
public void RequestBook(Model.Transaction oMTransaction)
{
try
{
osb.ConnectionString = sConnectionString;
ddq = new DatabaseQuery.DBQuery();
ddq.ConnectionString = osb.ConnectionString;
ddq.CommandText = "SP_REQUEST_BOOK";
ddq.AddParamer("@ID", SqlDbType.VarChar, oMTransaction.BOOK_ID);
ddq.AddParamer("@BORROWER_ID", SqlDbType.VarChar, oMTransaction.PERSON_ID);
ddq.AddParamer("@BOOK_NO", SqlDbType.VarChar, oMTransaction.BOOK_NO);
ddq.AddParamer("@TITLE", SqlDbType.VarChar, oMTransaction.TITLE);
ddq.AddParamer("@SUBJECT", SqlDbType.VarChar, oMTransaction.SUBJECT);
ddq.AddParamer("@CATEGORY", SqlDbType.VarChar, oMTransaction.CATEGORY);
ddq.AddParamer("@AUTHOR", SqlDbType.VarChar, oMTransaction.AUTHOR);
ddq.AddParamer("@PUBLISH_DATE", SqlDbType.VarChar, oMTransaction.PUBLISH_DATE);
ddq.AddParamer("@ISBN_NUMBER", SqlDbType.VarChar, oMTransaction.ISBN_NUMBER);
ddq.AddParamer("@LOCATION", SqlDbType.VarChar, oMTransaction.LOCATION);
ddq.AddParamer("@BOOK_PRICE", SqlDbType.VarChar, oMTransaction.BOOK_PRICE);
ddq.AddParamer("@RENT_PRICE", SqlDbType.VarChar, oMTransaction.RENT_PRICE);
ddq.AddParamer("@DAYS_BORROWED", SqlDbType.VarChar, oMTransaction.TOTAL_DAYS);
ddq.AddParamer("@ADDED_DATE", SqlDbType.VarChar, oMTransaction.ADDED_DATE);
ddq.AddParamer("@ADDED_BY", SqlDbType.VarChar, oMTransaction.ADDED_BY);
ddq.AddParamer("@STATUS", SqlDbType.VarChar, oMTransaction.STATUS);
ddq.ExecuteNonQuery(CommandType.StoredProcedure);
}
catch (Exception ex)
{
throw ex;
}
}
public Boolean IsBookRecordDataExists(eVariable.FIND_TYPE oFilter, string sFindText)
{
try
{
string sQuery = string.Empty;
osb.ConnectionString = sConnectionString;
ddq = new DatabaseQuery.DBQuery();
ddq.ConnectionString = osb.ConnectionString;
switch (oFilter)
{
case eVariable.FIND_TYPE.ISBN_NUMBER:
sQuery = "SELECT * FROM TBL_BOOKS WHERE ISBN_NUMBER = '" + sFindText + "'";
break;
case eVariable.FIND_TYPE.BOOK_NO:
sQuery = "SELECT * FROM TBL_BOOKS WHERE BOOK_NO = '" + sFindText + "'";
break;
default:
sQuery = "SELECT * FROM TBL_BOOKS WHERE ISBN_NUMBER = '" + sFindText + "'";
break;
}
ddq.CommandText = sQuery;
ds = ddq.GetDataset(CommandType.Text);
return(ds.Tables[0].Rows.Count > 0 ? true : false);
}
catch (Exception ex)
{
throw ex;
}
}
public int GetBookID()
{
osb.ConnectionString = sConnectionString;
ddq = new DatabaseQuery.DBQuery();
ddq.ConnectionString = osb.ConnectionString;
ddq.CommandText = "SELECT TOP 1 ID FROM TBL_BOOKS ORDER BY ID DESC";
ds = ddq.GetDataset(CommandType.Text);
return(ds.Tables[0].Rows.Count > 0 ? Convert.ToInt32(ds.Tables[0].Rows[0][0]) : 0);
}
private int GetStudentNo()
{
osb.ConnectionString = sConnectionString;
ddq = new DatabaseQuery.DBQuery();
ddq.ConnectionString = osb.ConnectionString;
ddq.CommandText = "SELECT TOP 1 STUDENT_ID FROM TBL_STUDENTS ORDER BY STUDENT_ID DESC";
ds = ddq.GetDataset(CommandType.Text);
return(ds.Tables[0].Rows.Count > 0 ? Convert.ToInt32(Regex.Replace(ds.Tables[0].Rows[0][0].ToString(), "[^0-9]", "")) : 0);
}
public int GetBorrowerNo()
{
osb.ConnectionString = sConnectionString;
ddq = new DatabaseQuery.DBQuery();
ddq.ConnectionString = osb.ConnectionString;
ddq.CommandText = "SELECT TOP 1 BORROWER_ID FROM TBL_BORROWER ORDER BY BORROWER_ID DESC";
ds = ddq.GetDataset(CommandType.Text);
return(ds.Tables[0].Rows.Count > 0 ? Convert.ToInt32(Regex.Replace(ds.Tables[0].Rows[0][0].ToString(), "[^0-9]", "")) : 0);
}
public int GetTransactionNo()
{
osb.ConnectionString = sConnectionString;
ddq = new DatabaseQuery.DBQuery();
ddq.ConnectionString = osb.ConnectionString;
ddq.CommandText = "SELECT TOP 1 TRANSACTION_NO FROM TBL_BORROWEDBOOKS ORDER BY TRANSACTION_NO DESC";
ds = ddq.GetDataset(CommandType.Text);
return(ds.Tables[0].Rows.Count > 0 ? Convert.ToInt32(Regex.Replace(ds.Tables[0].Rows[0][0].ToString(), "[^0-9]", "")) : 0);
}
public Boolean IsBookCheckout(Model.Transaction oData)
{
osb.ConnectionString = sConnectionString;
ddq = new DatabaseQuery.DBQuery();
ddq.ConnectionString = osb.ConnectionString;
ddq.CommandText = " SELECT ID FROM TBL_BOOKS WHERE BOOK_NO = '" + oData.BOOK_NO + "' AND [STATUS] = 'ACTIVE' " +
" AND (BOOK_NO IN (SELECT BOOK_NO FROM TBL_BORROWEDBOOKS WHERE [STATUS] = 'BORROWED') " +
" OR BOOK_NO IN (SELECT BOOK_NO FROM TBL_BORROWERREQUEST WHERE [STATUS] = 'REQUEST')) ";
ds = ddq.GetDataset(CommandType.Text);
return(ds.Tables[0].Rows.Count > 0 ? true : false);
}
public DataTable getCandidates(String sType, string sValue)
{
try
{
osb.ConnectionString = sConnectionString;
ddq = new DatabaseQuery.DBQuery();
ddq.ConnectionString = osb.ConnectionString;
string sQuery;
switch (sType)
{
case "ID":
sQuery = "SELECT B.CANDIDATE_ID,A.FIRST_NAME,A.MIDDLE_NAME,A.LAST_NAME,A.DOB,A.AGE,A.COURSE,A.SECTION,A.CONTACT_NO,A.ADDRESS,C.ID AS POSITION_ID,C.POSITION,D.ID AS PARTY_ID,D.PARTY,B.PROFILE_PIC,B.ELECTION_CODE FROM TBL_STUDENTS A INNER JOIN TBL_CANDIDATES B ON A.STUDENT_ID = B.CANDIDATE_ID INNER JOIN TBL_POSITION C ON C.ID = B.POSITION_ID INNER JOIN TBL_PARTY D ON D.ID = B.PARTY_ID WHERE B.STATUS = 'ACTIVE' AND A.STUDENT_ID = '" + sValue + "'";
break;
case "STUDENT ID":
sQuery = "SELECT B.CANDIDATE_ID,A.FIRST_NAME,A.MIDDLE_NAME,A.LAST_NAME,A.DOB,A.AGE,A.COURSE,A.SECTION,A.CONTACT_NO,A.ADDRESS,C.ID AS POSITION_ID,C.POSITION,D.ID AS PARTY_ID,D.PARTY,B.PROFILE_PIC,B.ELECTION_CODE FROM TBL_STUDENTS A INNER JOIN TBL_CANDIDATES B ON A.STUDENT_ID = B.CANDIDATE_ID INNER JOIN TBL_POSITION C ON C.ID = B.POSITION_ID INNER JOIN TBL_PARTY D ON D.ID = B.PARTY_ID WHERE B.STATUS = 'ACTIVE' AND A.STUDENT_ID LIKE '%" + sValue + "%'";
break;
case "CANDIDATE ID":
sQuery = "SELECT B.CANDIDATE_ID,A.FIRST_NAME,A.MIDDLE_NAME,A.LAST_NAME,A.DOB,A.AGE,A.COURSE,A.SECTION,A.CONTACT_NO,A.ADDRESS,C.ID AS POSITION_ID,C.POSITION,D.ID AS PARTY_ID,D.PARTY,B.PROFILE_PIC,B.ELECTION_CODE FROM TBL_STUDENTS A INNER JOIN TBL_CANDIDATES B ON A.STUDENT_ID = B.CANDIDATE_ID INNER JOIN TBL_POSITION C ON C.ID = B.POSITION_ID INNER JOIN TBL_PARTY D ON D.ID = B.PARTY_ID WHERE B.STATUS = 'ACTIVE' AND A.STUDENT_ID LIKE '%" + sValue + "%'";
break;
case "FIRST NAME":
sQuery = "SELECT B.CANDIDATE_ID,A.FIRST_NAME,A.MIDDLE_NAME,A.LAST_NAME,A.DOB,A.AGE,A.COURSE,A.SECTION,A.CONTACT_NO,A.ADDRESS,C.ID AS POSITION_ID,C.POSITION,D.ID AS PARTY_ID,D.PARTY,B.PROFILE_PIC,B.ELECTION_CODE FROM TBL_STUDENTS A INNER JOIN TBL_CANDIDATES B ON A.STUDENT_ID = B.CANDIDATE_ID INNER JOIN TBL_POSITION C ON C.ID = B.POSITION_ID INNER JOIN TBL_PARTY D ON D.ID = B.PARTY_ID WHERE B.STATUS = 'ACTIVE' AND A.FIRST_NAME LIKE '%" + sValue + "%'";
break;
case "LAST NAME":
sQuery = "SELECT B.CANDIDATE_ID,A.FIRST_NAME,A.MIDDLE_NAME,A.LAST_NAME,A.DOB,A.AGE,A.COURSE,A.SECTION,A.CONTACT_NO,A.ADDRESS,C.ID AS POSITION_ID,C.POSITION,D.ID AS PARTY_ID,D.PARTY,B.PROFILE_PIC,B.ELECTION_CODE FROM TBL_STUDENTS A INNER JOIN TBL_CANDIDATES B ON A.STUDENT_ID = B.CANDIDATE_ID INNER JOIN TBL_POSITION C ON C.ID = B.POSITION_ID INNER JOIN TBL_PARTY D ON D.ID = B.PARTY_ID WHERE B.STATUS = 'ACTIVE' AND A.LAST_NAME LIKE '%" + sValue + "%'";
break;
case "INACTIVE":
sQuery = "SELECT B.CANDIDATE_ID,A.FIRST_NAME,A.MIDDLE_NAME,A.LAST_NAME,A.DOB,A.AGE,A.COURSE,A.SECTION,A.CONTACT_NO,A.ADDRESS,C.ID AS POSITION_ID,C.POSITION,D.ID AS PARTY_ID,D.PARTY,B.PROFILE_PIC,B.ELECTION_CODE FROM TBL_STUDENTS A INNER JOIN TBL_CANDIDATES B ON A.STUDENT_ID = B.CANDIDATE_ID INNER JOIN TBL_POSITION C ON C.ID = B.POSITION_ID INNER JOIN TBL_PARTY D ON D.ID = B.PARTY_ID WHERE B.STATUS = 'INACTIVE' AND A.STUDENT_ID LIKE '%" + sValue + "%'";
break;
default:
sQuery = "SELECT B.CANDIDATE_ID,A.FIRST_NAME,A.MIDDLE_NAME,A.LAST_NAME,A.DOB,A.AGE,A.COURSE,A.SECTION,A.CONTACT_NO,A.ADDRESS,C.ID AS POSITION_ID,C.POSITION,D.ID AS PARTY_ID,D.PARTY,B.PROFILE_PIC,B.ELECTION_CODE FROM TBL_STUDENTS A INNER JOIN TBL_CANDIDATES B ON A.STUDENT_ID = B.CANDIDATE_ID INNER JOIN TBL_POSITION C ON C.ID = B.POSITION_ID INNER JOIN TBL_PARTY D ON D.ID = B.PARTY_ID WHERE B.STATUS = 'ACTIVE' AND A.FIRST_NAME LIKE '%" + sValue + "%'";
break;
}
ddq.CommandText = sQuery;
ds = ddq.GetDataset(CommandType.Text);
return(ds.Tables.Count > 0 ? ds.Tables[0] : null);
}
catch (Exception ex)
{
throw ex;
}
}
public DataTable getCandidate(String sType, string sValue)
{
try
{
osb.ConnectionString = sConnectionString;
ddq = new DatabaseQuery.DBQuery();
ddq.ConnectionString = osb.ConnectionString;
string sQuery;
switch (sType)
{
case "STUDENT ID":
sQuery = "SELECT * FROM TBL_STUDENTS WHERE STUDENT_ID Like '%" + sValue + "%' and status = 'ACTIVE' and Student_ID not in (Select Candidate_ID from tbl_Candidates where status = 'ACTIVE')";
break;
case "FIRST NAME":
sQuery = "SELECT * FROM TBL_STUDENTS WHERE FIRST_NAME Like '%" + sValue + "%' and status = 'ACTIVE' and Student_ID not in (Select Candidate_ID from tbl_Candidates where status = 'ACTIVE')";
break;
case "MIDDLE NAME":
sQuery = "SELECT * FROM TBL_STUDENTS WHERE MIDDLE_NAME Like '%" + sValue + "%' and status = 'ACTIVE' and Student_ID not in (Select Candidate_ID from tbl_Candidates where status = 'ACTIVE')";
break;
case "LAST NAME":
sQuery = "SELECT * FROM TBL_STUDENTS WHERE LAST_NAME Like '%" + sValue + "%' and status = 'ACTIVE' and Student_ID not in (Select Candidate_ID from tbl_Candidates where status = 'ACTIVE')";
break;
case "INACTIVE":
sQuery = "Select * from tbl_Students where status = 'INACTIVE'";
break;
default:
sQuery = "Select * from tbl_Students where status = 'ACTIVE' and Student_ID not in (Select Candidate_ID from tbl_Candidates where status = 'ACTIVE')";
break;
}
ddq.CommandText = sQuery;
ds = ddq.GetDataset(CommandType.Text);
return(ds.Tables.Count > 0 ? ds.Tables[0] : null);
}
catch (Exception ex)
{
throw ex;
}
}
public void ArchiveUser(string sUsername)
{
try
{
osb.ConnectionString = sConnectionString;
ddq = new DatabaseQuery.DBQuery();
ddq.ConnectionString = osb.ConnectionString;
ddq.CommandText = "Update tbl_User set Status = 'INACTIVE' where Username = '******'";
ddq.ExecuteNonQuery(CommandType.Text);
}
catch (Exception ex)
{
throw ex;
}
}
public void UpdateStudent(Model.Student oData)
{
try
{
osb.ConnectionString = sConnectionString;
ddq = new DatabaseQuery.DBQuery();
ddq.ConnectionString = osb.ConnectionString;
ddq.CommandText = "Update tbl_Students set First_Name = '" + oData.FIRST_NAME + "',Middle_Name = '" + oData.MIDDLE_NAME + "',Last_Name = '" + oData.LAST_NAME + "',DOB = '" + oData.DOB + "',AGE = '" + oData.AGE + "',COURSE = '" + oData.COURSE + "',SECTION = '" + oData.SECTION + "',ADDRESS = '" + oData.ADDRESS + "',Contact_No = '" + oData.CONTACT_NO + "',Modified_Date = '" + DateTime.Now.ToShortDateString() + "' where STUDENT_ID = '" + oData.UNIQUE_ID + "'";
ddq.ExecuteNonQuery(CommandType.Text);
}
catch (Exception ex)
{
throw ex;
}
}
