public static STD_ClassSubjectEmployeeStudent GetSTD_ClassSubjectEmployeeStudentByClassSubjectEmployeeStudentID(int ClassSubjectEmployeeStudentID)
{
STD_ClassSubjectEmployeeStudent sTD_ClassSubjectEmployeeStudent = new STD_ClassSubjectEmployeeStudent();
SqlSTD_ClassSubjectEmployeeStudentProvider sqlSTD_ClassSubjectEmployeeStudentProvider = new SqlSTD_ClassSubjectEmployeeStudentProvider();
sTD_ClassSubjectEmployeeStudent = sqlSTD_ClassSubjectEmployeeStudentProvider.GetSTD_ClassSubjectEmployeeStudentByClassSubjectEmployeeStudentID(ClassSubjectEmployeeStudentID);
return sTD_ClassSubjectEmployeeStudent;
}
protected void btnAddAttendant_Click(object sender, EventArgs e)
{
try
{
DateTime date = new DateTime();
date = Convert.ToDateTime(txtAttendantDate.Text);
string sdate = date.ToString("yyyy-MM-dd");
date = Convert.ToDateTime(sdate + " " + ddlStartHour.SelectedValue + ":" + ddlStartMin.SelectedValue + " "+ddlStartAMPM.SelectedValue);
//DataSet dsStudentAttendence = STD_StudentManager.GetSTD_ClassStudentsAttentdant(ddlEmployeeID.SelectedValue, date);
DataSet dsStudentAttendence = dsStudentAttendence = STD_StudentManager.GetSTD_ClassSubjectEmployeeStudentByClassSubjectEmployeeIDForRepeating(
((Label)gvSTD_ClassSubjectEmployeeStudent.Rows[0].FindControl("lblClassSubjectEmloyeeID")).Text
, date);
if (dsStudentAttendence.Tables[0].Rows.Count == 0)
{
foreach (GridViewRow row in gvSTD_ClassSubjectEmployeeStudent.Rows)
{
CheckBox chbAttendants = (CheckBox)row.FindControl("chbAttendants");
Label lblClassSubjectEmloyeeID = (Label)row.FindControl("lblClassSubjectEmloyeeID");
Label lblStudentID = (Label)row.FindControl("lblStudentID");
TextBox txtRemark = (TextBox)row.FindControl("txtRemark");
//if (txtRemark.Text != "")
//{
// COMN_Remark cOMN_Remark = new COMN_Remark();
// // cOMN_Remark.RemarkID= int.Parse(ddlRemarkID.SelectedValue);
// cOMN_Remark.RemarkName = "Attendence Remark";
// cOMN_Remark.Remark = txtRemark.Text;
// cOMN_Remark.RemarkDate = DateTime.Parse(txtAttendantDate.Text);
// cOMN_Remark.WhoReported = STD_StudentManager.GetSTD_StudentByStudentID(Profile.card_id).StudentCode;
// cOMN_Remark.WhoDid = STD_StudentManager.GetSTD_StudentByStudentID(lblStudentID.Text).StudentCode;
// cOMN_Remark.ExtraField1 = txtAttendantDate.Text + " (" + DateTime.Parse(txtAttendantDate.Text).ToString("ddd") + ") - " + ddlStartHour.SelectedValue + ":" + ddlStartMin.SelectedValue + " " + ddlStartAMPM.SelectedValue + " - " + ddlEndHour.SelectedValue + ":" + ddlEndMin.SelectedValue + " " + ddlEndAMPM.SelectedValue;
// cOMN_Remark.ExtraField2 = "";
// cOMN_Remark.ExtraField3 = "";
// cOMN_Remark.ExtraField4 = "";
// cOMN_Remark.ExtraField5 = "";
// cOMN_Remark.AddedBy = Profile.card_id;
// cOMN_Remark.AddedDate = DateTime.Now;
// cOMN_Remark.UpdatedBy = Profile.card_id;
// cOMN_Remark.UpdatedDate = DateTime.Now;
// cOMN_Remark.RowStatusID = 1;// int.Parse(ddlRowStatusID.SelectedValue);
// int resutl = COMN_RemarkManager.InsertCOMN_Remark(cOMN_Remark);
//}
//if (chbAttendants.Checked)
//{
STD_ClassSubjectEmployeeStudent css = new STD_ClassSubjectEmployeeStudent();
css.ClassSubjectEmployeeID = Convert.ToInt32(lblClassSubjectEmloyeeID.Text);
css.StudentID = lblStudentID.Text;
css.RowStatusID = 1;
css.AddedBy = Profile.card_id;
css.UpdateDate = DateTime.Now;
css.UpdatedBy = Profile.card_id;
css.AddedDate = date;
//if (chkManualDataEntry.Checked)
//{
css.ExtraField1 = txtAttendantDate.Text + " (" + DateTime.Parse(txtAttendantDate.Text).ToString("ddd") + ") - " + ddlStartHour.SelectedValue + ":" + ddlStartMin.SelectedValue + " " + ddlStartAMPM.SelectedValue + " - " + ddlEndHour.SelectedValue + ":" + ddlEndMin.SelectedValue + " " + ddlEndAMPM.SelectedValue;
//}
//else
//{
// css.ExtraField1 = hfAttendenceDataTime.Value;
//}
css.ExtraField2 = ddlEmployeeID.SelectedValue;
css.ExtraField3 = txtCoveredSyllabus.Text; //temporary we are sending data for covered Syllabus
css.TodayRemark = txtRemark.Text;
css.IsExam = chkExamTaken.Checked;
css.IsAbsence = !chbAttendants.Checked;
int result = STD_ClassSubjectEmployeeStudentManager.InsertSTD_ClassSubjectEmployeeStudent(css);
if (result > 0)
{
//ScriptManager.RegisterStartupScript(this, typeof(Page), "Message", "alert('Add Attendants Successully.');", true);
//pnAttendantDate.Visible = true;
//DataSet ca = STD_ClassSubjectEmployeeStudentManager.GetSTD_AttendantDateByEmployeeID(ddlEmployeeID.SelectedValue);
//lblNoAttendant.Text = ca.Tables[0].Rows.Count.ToString();
//gvSTD_AttendantTime.DataSource = ca;
//gvSTD_AttendantTime.DataBind();
//btnAddAttendant.Visible = false;
}
//}
}
ScriptManager.RegisterStartupScript(this, typeof(Page), "Message", "alert('Add Attendants Successully.');", true);
}
else
{
ScriptManager.RegisterStartupScript(this, typeof(Page), "Message", "alert('Attendants is already exist for this date time.');", true);
}
ddlEmployeeID_SelectedIndexChanged(this, new EventArgs());
}
catch (Exception ex)
{
}
}
public bool UpdateSTD_ClassSubjectEmployeeStudent(STD_ClassSubjectEmployeeStudent sTD_ClassSubjectEmployeeStudent)
{
using (SqlConnection connection = new SqlConnection(this.ConnectionString))
{
SqlCommand cmd = new SqlCommand("UpdateSTD_ClassSubjectEmployeeStudent", connection);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@ClassSubjectEmployeeStudentID", SqlDbType.Int).Value = sTD_ClassSubjectEmployeeStudent.ClassSubjectEmployeeStudentID;
cmd.Parameters.Add("@ClassSubjectEmployeeID", SqlDbType.Int).Value = sTD_ClassSubjectEmployeeStudent.ClassSubjectEmployeeID;
cmd.Parameters.Add("@StudentID", SqlDbType.NVarChar).Value = sTD_ClassSubjectEmployeeStudent.StudentID;
cmd.Parameters.Add("@UpdatedBy", SqlDbType.NVarChar).Value = sTD_ClassSubjectEmployeeStudent.UpdatedBy;
cmd.Parameters.Add("@UpdateDate", SqlDbType.DateTime).Value = sTD_ClassSubjectEmployeeStudent.UpdateDate;
cmd.Parameters.Add("@RowStatusID", SqlDbType.Int).Value = sTD_ClassSubjectEmployeeStudent.RowStatusID;
cmd.Parameters.Add("@ExtraField1", SqlDbType.NVarChar).Value = sTD_ClassSubjectEmployeeStudent.ExtraField1;
cmd.Parameters.Add("@ExtraField2", SqlDbType.NVarChar).Value = sTD_ClassSubjectEmployeeStudent.ExtraField2;
connection.Open();
int result = cmd.ExecuteNonQuery();
return result == 1;
}
}
public int InsertSTD_ClassSubjectEmployeeStudent(STD_ClassSubjectEmployeeStudent sTD_ClassSubjectEmployeeStudent)
{
using (SqlConnection connection = new SqlConnection(this.ConnectionString))
{
SqlCommand cmd = new SqlCommand("InsertSTD_ClassSubjectEmployeeStudent", connection);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@ClassSubjectEmployeeStudentID", SqlDbType.Int).Direction = ParameterDirection.Output;
cmd.Parameters.Add("@ClassSubjectEmployeeID", SqlDbType.Int).Value = sTD_ClassSubjectEmployeeStudent.ClassSubjectEmployeeID;
cmd.Parameters.Add("@StudentID", SqlDbType.NVarChar).Value = sTD_ClassSubjectEmployeeStudent.StudentID;
cmd.Parameters.Add("@AddedBy", SqlDbType.NVarChar).Value = sTD_ClassSubjectEmployeeStudent.AddedBy;
cmd.Parameters.Add("@AddedDate", SqlDbType.DateTime).Value = sTD_ClassSubjectEmployeeStudent.AddedDate;
cmd.Parameters.Add("@UpdatedBy", SqlDbType.NVarChar).Value = sTD_ClassSubjectEmployeeStudent.UpdatedBy;
cmd.Parameters.Add("@UpdateDate", SqlDbType.DateTime).Value = sTD_ClassSubjectEmployeeStudent.UpdateDate;
cmd.Parameters.Add("@RowStatusID", SqlDbType.Int).Value = sTD_ClassSubjectEmployeeStudent.RowStatusID;
cmd.Parameters.Add("@ExtraField1", SqlDbType.NVarChar).Value = sTD_ClassSubjectEmployeeStudent.ExtraField1;
cmd.Parameters.Add("@ExtraField2", SqlDbType.NVarChar).Value = sTD_ClassSubjectEmployeeStudent.ExtraField2;
cmd.Parameters.Add("@ExtraField3", SqlDbType.NVarChar).Value = sTD_ClassSubjectEmployeeStudent.ExtraField3;
cmd.Parameters.Add("@TodayRemark", SqlDbType.NText).Value = sTD_ClassSubjectEmployeeStudent.TodayRemark;
cmd.Parameters.Add("@IsExam", SqlDbType.Bit).Value = sTD_ClassSubjectEmployeeStudent.IsExam;
cmd.Parameters.Add("@IsAbsence", SqlDbType.Bit).Value = sTD_ClassSubjectEmployeeStudent.IsAbsence;
connection.Open();
int result = cmd.ExecuteNonQuery();
return (int)cmd.Parameters["@ClassSubjectEmployeeStudentID"].Value;
}
}
public STD_ClassSubjectEmployeeStudent GetSTD_ClassSubjectEmployeeStudentFromReader(IDataReader reader)
{
try
{
STD_ClassSubjectEmployeeStudent sTD_ClassSubjectEmployeeStudent = new STD_ClassSubjectEmployeeStudent
(
DataAccessObject.IsNULL<int>(reader["ClassSubjectEmployeeStudentID"]),
DataAccessObject.IsNULL<int>(reader["ClassSubjectEmployeeID"]),
DataAccessObject.IsNULL<string>(reader["StudentID"].ToString()),
DataAccessObject.IsNULL<string>(reader["AddedBy"].ToString()),
DataAccessObject.IsNULL<DateTime>(reader["AddedDate"]),
DataAccessObject.IsNULL<string>(reader["UpdatedBy"].ToString()),
DataAccessObject.IsNULL<DateTime>(reader["UpdateDate"]),
DataAccessObject.IsNULL<int>(reader["RowStatusID"]),
DataAccessObject.IsNULL<string>(reader["ExtraField1"].ToString()),
DataAccessObject.IsNULL<string>(reader["ExtraField2"].ToString())
);
return sTD_ClassSubjectEmployeeStudent;
}
catch(Exception ex)
{
return null;
}
}
public static bool UpdateSTD_ClassSubjectEmployeeStudent(STD_ClassSubjectEmployeeStudent sTD_ClassSubjectEmployeeStudent)
{
SqlSTD_ClassSubjectEmployeeStudentProvider sqlSTD_ClassSubjectEmployeeStudentProvider = new SqlSTD_ClassSubjectEmployeeStudentProvider();
return sqlSTD_ClassSubjectEmployeeStudentProvider.UpdateSTD_ClassSubjectEmployeeStudent(sTD_ClassSubjectEmployeeStudent);
}
public static int InsertSTD_ClassSubjectEmployeeStudent(STD_ClassSubjectEmployeeStudent sTD_ClassSubjectEmployeeStudent)
{
SqlSTD_ClassSubjectEmployeeStudentProvider sqlSTD_ClassSubjectEmployeeStudentProvider = new SqlSTD_ClassSubjectEmployeeStudentProvider();
return sqlSTD_ClassSubjectEmployeeStudentProvider.InsertSTD_ClassSubjectEmployeeStudent(sTD_ClassSubjectEmployeeStudent);
}
