public bool removedata(DsPSMS.ST_STUDENT_DATARow dr, out string msg)
{
bool isOk = true;
if (dr == null)
{
msg = "data is empty";
return(false);
}
try
{
Open();
int result = stu.deletestudentdata(dr);
msg = "deleted";
}
catch
{
msg = "error occurs when deleting student data";
return(false);
}
finally
{
Close();
}
return(isOk);
}
public int deletestudentdata(DsPSMS.ST_STUDENT_DATARow dr)
{
if (dr == null)
{
return(-1);
}
Open();
string query = "UPDATE ST_STUDENT_DATA SET DEL_FLG =" + 1 + "WHERE STUDENT_ID =" + dr["STUDENT_ID"];
SqlCommand cmd = new SqlCommand(query, conn);
result = cmd.ExecuteNonQuery();
Close();
return(result);
}
public DsPSMS.ATTENDANCE_RESULTDataTable selectAttendanceData(DsPSMS.ST_STUDENT_DATARow sr, DsPSMS.ST_ATTENDANCE_DATARow dr)
{
if (dr == null)
{
return(null);
}
string query = "SELECT ST_STUDENT_DATA.STUDENT_ID, ST_STUDENT_DATA.STUDENT_NAME, ST_STUDENT_DATA.ROLL_NO, ST_ATTENDANCE_DATA.MORNING, ST_ATTENDANCE_DATA.EVENING, ST_ATTENDANCE_DATA.ATTENDANCE_DATE FROM ST_STUDENT_DATA INNER JOIN ST_ATTENDANCE_DATA ON ST_STUDENT_DATA.STUDENT_ID = ST_ATTENDANCE_DATA.STUDENT_ID WHERE (ST_STUDENT_DATA.GRADE_ID = '" + sr.GRADE_ID + "' AND ST_STUDENT_DATA.ROOM_ID= '" + sr.ROOM_ID + "' AND ST_ATTENDANCE_DATA.ATTENDANCE_DATE = '" + dr.ATTENDANCE_DATE + "');";
SqlCommand cmd = new SqlCommand(query, conn);
SqlDataAdapter da = new SqlDataAdapter(cmd);
DsPSMS.ATTENDANCE_RESULTDataTable st = new DsPSMS.ATTENDANCE_RESULTDataTable();
da.Fill(st);
return(st);
}
public DsPSMS.ST_STUDENT_DATARow getCashType(DsPSMS.ST_STUDENT_DATARow stuDr, out string msg)
{
try
{
Open();
stuDr = stu.selectCashType(stuDr);
msg = "Have data";
}
catch
{
msg = "error occurs when selecting cash type";
return(null);
}
finally
{
Close();
}
return(stuDr);
}
public DsPSMS.ST_STUDENT_DATARow getStuName(DsPSMS.ST_STUDENT_DATARow dr, out string msg)
{
DataSet.DsPSMS.ST_STUDENT_DATARow stuDr = new DataSet.DsPSMS.ST_STUDENT_DATADataTable().NewST_STUDENT_DATARow();
try
{
Open();
stuDr = stu.selectStuName(dr);
msg = "Have data";
}
catch
{
msg = "error occurs when selecting name";
return(null);
}
finally
{
Close();
}
return(stuDr);
}
