public static STD_ClassTime GetSTD_ClassTimeByClassTimeID(int ClassTimeID)
{
STD_ClassTime sTD_ClassTime = new STD_ClassTime();
SqlSTD_ClassTimeProvider sqlSTD_ClassTimeProvider = new SqlSTD_ClassTimeProvider();
sTD_ClassTime = sqlSTD_ClassTimeProvider.GetSTD_ClassTimeByClassTimeID(ClassTimeID);
return sTD_ClassTime;
}
public bool UpdateSTD_ClassTime(STD_ClassTime sTD_ClassTime)
{
using (SqlConnection connection = new SqlConnection(this.ConnectionString))
{
SqlCommand cmd = new SqlCommand("UpdateSTD_ClassTime", connection);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@ClassTimeID", SqlDbType.Int).Value = sTD_ClassTime.ClassTimeID;
cmd.Parameters.Add("@ClassTimeName", SqlDbType.NVarChar).Value = sTD_ClassTime.ClassTimeName;
cmd.Parameters.Add("@Duration", SqlDbType.Decimal).Value = sTD_ClassTime.Duration;
cmd.Parameters.Add("@UpdatedBy", SqlDbType.NVarChar).Value = sTD_ClassTime.UpdatedBy;
cmd.Parameters.Add("@UpdateDate", SqlDbType.DateTime).Value = sTD_ClassTime.UpdateDate;
cmd.Parameters.Add("@Order", SqlDbType.Int).Value = sTD_ClassTime.Order;
cmd.Parameters.Add("@ClassTimeGroupID", SqlDbType.Int).Value = sTD_ClassTime.ClassTimeGroupID;
cmd.Parameters.Add("@StartTime", SqlDbType.NVarChar).Value = sTD_ClassTime.StartTime;
cmd.Parameters.Add("@EndTime", SqlDbType.NVarChar).Value = sTD_ClassTime.EndTime;
cmd.Parameters.Add("@ExtraField1", SqlDbType.NVarChar).Value = sTD_ClassTime.ExtraField1;
cmd.Parameters.Add("@ExtraField2", SqlDbType.NVarChar).Value = sTD_ClassTime.ExtraField2;
cmd.Parameters.Add("@ExtraField3", SqlDbType.NVarChar).Value = sTD_ClassTime.ExtraField3;
cmd.Parameters.Add("@ExtraField4", SqlDbType.NVarChar).Value = sTD_ClassTime.ExtraField4;
cmd.Parameters.Add("@ExtraField5", SqlDbType.NVarChar).Value = sTD_ClassTime.ExtraField5;
cmd.Parameters.Add("@RowStatusID", SqlDbType.Int).Value = sTD_ClassTime.RowStatusID;
connection.Open();
int result = cmd.ExecuteNonQuery();
return result == 1;
}
}
public STD_ClassTime GetSTD_ClassTimeFromReader(IDataReader reader)
{
try
{
STD_ClassTime sTD_ClassTime = new STD_ClassTime
(
DataAccessObject.IsNULL<int>(reader["ClassTimeID"]),
DataAccessObject.IsNULL<string>(reader["ClassTimeName"]),
DataAccessObject.IsNULL<decimal>(reader["Duration"]),
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["Order"]),
DataAccessObject.IsNULL<int>(reader["ClassTimeGroupID"]),
DataAccessObject.IsNULL<string>(reader["StartTime"]),
DataAccessObject.IsNULL<string>(reader["EndTime"]),
DataAccessObject.IsNULL<string>(reader["ExtraField1"]),
DataAccessObject.IsNULL<string>(reader["ExtraField2"]),
DataAccessObject.IsNULL<string>(reader["ExtraField3"]),
DataAccessObject.IsNULL<string>(reader["ExtraField4"]),
DataAccessObject.IsNULL<string>(reader["ExtraField5"]),
DataAccessObject.IsNULL<int>(reader["RowStatusID"])
);
return sTD_ClassTime;
}
catch (Exception ex)
{
return null;
}
}
//public static List<STD_ClassTime> ListClassTime = new List<STD_ClassTime>();
protected void OnRowDataBound_gvClassDay(object sender, GridViewRowEventArgs e)
{
if (e.Row.RowType == DataControlRowType.DataRow)
{
List<STD_ClassTime> ListClassTime = new List<STD_ClassTime>();
HiddenField hfDayID = (HiddenField)e.Row.FindControl("hfDayID");
if (ListClassTime.Count == 0)
{
DataSet ds = STD_ClassTimeManager.GetAllSTD_ClassTimes();
foreach (DataRow dr in ds.Tables[0].Rows)
{
STD_ClassTime classTime = new STD_ClassTime();
classTime.ClassTimeID = int.Parse(dr["ClassTimeID"].ToString());
classTime.ClassTimeName = dr["ClassTimeName"].ToString();
classTime.ClassTimeGroupName = dr["ClassTimeGroupName"].ToString();
classTime.ClassTimeGroupID = int.Parse(dr["ClassTimeGroupID"].ToString());
classTime.ExtraField1 = dr["ExtraField1"].ToString();
classTime.ExtraField2 = dr["ExtraField2"].ToString();
classTime.ExtraField3 = dr["ExtraField3"].ToString();
classTime.IsEnabled = true;
classTime.CaseForDisabled = "";
for (int i = int.Parse(dr["ExtraField1"].ToString())-1; i <= int.Parse(dr["ExtraField2"].ToString())+1; i++)
{
//if (!dayIDTimeIDPair.Contains(";" + dr["ClassDayID"].ToString() + "-" + dr["ClassTimeID"].ToString() + ";"))
//{
// dayIDTimeIDPair += dr["ClassDayID"].ToString() + "-" + dr["ClassTimeID"].ToString() + ";";
//}
if (hfDayIDTimeIDPair.Value.Contains(";" + hfDayID.Value + "-" +i.ToString() + ";"))
{
classTime.IsEnabled = false;
classTime.CaseForDisabled = "(Time Confickted)";
foreach (ListItem li in ddlRoutineTimeIDnCause.Items)
{
if (li.Value == hfDayID.Value + "-" + dr["ClassTimeID"].ToString() + ";")
{
if (classTime.CaseForDisabled.Contains("(Time Confickted)"))
{
classTime.CaseForDisabled ="";
}
if (!classTime.CaseForDisabled.Contains("?ID=" + li.Text.Split(';')[0].Substring(1) + "'>"))
{
if (classTime.CaseForDisabled != "")
classTime.CaseForDisabled += " & ";
ddlRoutineTImeIDnValue.SelectedValue = li.Text.Split(';')[0].Substring(1);
string routineTimeName = ddlRoutineTImeIDnValue.SelectedItem.Text;
//string routineTimeName = STD_RoutineTimeManager.GetSTD_RoutineTimeByRoutineTimeID(int.Parse(li.Text.Split(';')[1].Substring(1))).RoutineTimeName;
//classTime.CaseForDisabled += STD_RoutineTimeManager.GetSTD_RoutineTimeByRoutineTimeID(int.Parse(li.Text.Split(';')[1].Substring(1))).RoutineTimeName;//"<a target='_blank' href='Admin/DeleteClassByID.aspx?ID=" + li.Text.Split(';')[1].Substring(1) + "'>Click here To Delete " + STD_RoutineTimeManager.GetSTD_RoutineTimeByRoutineTimeID(int.Parse(li.Text.Split(';')[1].Substring(1))).RoutineTimeName + "</a>";
classTime.CaseForDisabled += "<img alt='" + routineTimeName + "' src='../App_Themes/CoffeyGreen/images/Confusion.png' title='" + routineTimeName + "'/>";//"<a target='_blank' href='Admin/DeleteClassByID.aspx?ID=" + li.Text.Split(';')[1].Substring(1) + "'>Click here To Delete " + STD_RoutineTimeManager.GetSTD_RoutineTimeByRoutineTimeID(int.Parse(li.Text.Split(';')[1].Substring(1))).RoutineTimeName + "</a>";
}
}
}
if (!classTime.CaseForDisabled.Contains("(Time Confickted)"))
{
classTime.CaseForDisabled = "(" + classTime.CaseForDisabled + ")";
}
}
}
ListClassTime.Add(classTime);
}
}
else
{
foreach (STD_ClassTime classTime in ListClassTime)
{
classTime.IsEnabled = true;
classTime.CaseForDisabled = "";
for (int i = int.Parse(classTime.ExtraField1) - 1; i <= int.Parse(classTime.ExtraField2) + 1; i++)
{
//if (!dayIDTimeIDPair.Contains(";" + dr["ClassDayID"].ToString() + "-" + dr["ClassTimeID"].ToString() + ";"))
//{
// dayIDTimeIDPair += dr["ClassDayID"].ToString() + "-" + dr["ClassTimeID"].ToString() + ";";
//}
if (hfDayIDTimeIDPair.Value.Contains(";" + hfDayID.Value + "-" + i.ToString() + ";"))
{
classTime.IsEnabled = false;
classTime.CaseForDisabled = "Confickted with another Class";
foreach (ListItem li in ddlRoutineTimeIDnCause.Items)
{
if (li.Value == hfDayID.Value + "-" + classTime.ClassTimeID.ToString() + ";")
{
classTime.CaseForDisabled = li.Text;
}
}
}
}
//if (hfDayIDTimeIDPair.Value.Contains(";" + hfDayID.Value + "-" + classTime.ClassTimeID + ";"))
//{
// classTime.IsEnabled = false;
//}
//else
//{
// classTime.IsEnabled = true;
//}
}
}
DataList dlTime = (DataList)e.Row.FindControl("dlTime");
//chkClassTime.DataValueField = "ClassTimeID";
//chkClassTime.DataTextField = "ClassTimeName";
dlTime.DataSource = ListClassTime;
dlTime.DataBind();
}
}
protected void btnAdd_Click(object sender, EventArgs e)
{
STD_ClassTime sTD_ClassTime = new STD_ClassTime ();
bool is12PMIssueEnd = false;
if (ddlEndHour.SelectedValue == "12" && ddlEndAMPM.SelectedValue == "PM")
{
is12PMIssueEnd = true;
txtEndTime.Text = "0:" + ddlEndMin.SelectedValue + " " + ddlEndAMPM.SelectedValue;
}
else
{
txtEndTime.Text = ddlEndHour.SelectedValue + ":" + ddlEndMin.SelectedValue + " " + ddlEndAMPM.SelectedValue;
}
bool is12PMIssueStart = false;
if (ddlStartHour.SelectedValue == "12" && ddlStartAMPM.SelectedValue == "PM")
{
is12PMIssueStart = true;
txtStartTime.Text = "0:" + ddlStartMin.SelectedValue + " " + ddlStartAMPM.SelectedValue;
}
else
{
txtStartTime.Text = ddlStartHour.SelectedValue + ":" + ddlStartMin.SelectedValue + " " + ddlStartAMPM.SelectedValue;
}
//txtEndTime.Text = ddlEndHour.SelectedValue + ":" + ddlEndMin.SelectedValue + " " + ddlEndAMPM.SelectedValue;
txtClassTimeName.Text = (is12PMIssueStart ? "12:" + txtStartTime.Text.ToString().Split(':')[1] : txtStartTime.Text.ToString()) + " - " + (is12PMIssueEnd ? "12:" + txtEndTime.Text.ToString().Split(':')[1] : txtEndTime.Text.ToString());
TimeList timeList = new TimeList();
List<Time> times = new List<Time>();
times = timeList.getTimeList();
foreach (Time t in times)
{
if (txtStartTime.Text == t.TimeName) txtExtraField1.Text = t.TimeID.ToString();
if (txtEndTime.Text == t.TimeName) txtExtraField2.Text = t.TimeID.ToString();
}
txtDuration.Text = ((int.Parse(txtExtraField2.Text) - int.Parse(txtExtraField1.Text)) * 5).ToString();
//Check in the group
//DataSet classTimesAll = STD_ClassTimeManager.GetSTD_ClassTimeByClassTimeGroupID();
DataSet classTimes = STD_ClassTimeManager.GetSTD_ClassTimeByClassTimeGroupID(int.Parse(ddlClassTimeGroupID.SelectedValue));
bool isConfict = false;
foreach (DataRow dr in classTimes.Tables[0].Rows)
{
if ((int.Parse(dr["ExtraField1"].ToString()) <= int.Parse(txtExtraField1.Text) && int.Parse(dr["ExtraField2"].ToString()) >= int.Parse(txtExtraField1.Text))
|| (int.Parse(dr["ExtraField1"].ToString()) <= int.Parse(txtExtraField2.Text) && int.Parse(dr["ExtraField2"].ToString()) >= int.Parse(txtExtraField2.Text)))
{
isConfict = true;
divNewRoutineTimeGourp.Visible = true;
lblMessage.Text = "</br>There is a conflict with the Class Time Group-<span style='color:red;'>" + ddlClassTimeGroupID.SelectedItem.Text + "</span>. Please change it<br/>OR<br/>Click on the following button to set # System Generated";
try
{
if (ddlClassTimeGroupID.SelectedValue != ddlClassTimeGroupID.Items[ddlClassTimeGroupID.Items.Count - 1].Value)
{
ddlClassTimeGroupID.SelectedValue = (int.Parse(ddlClassTimeGroupID.SelectedValue) + 1).ToString();
btnAdd_Click(this, new EventArgs());
}
else
{
btnAddWithNewTimeGroup_Click(this, new EventArgs());
}
}
catch (Exception ex)
{
btnAddWithNewTimeGroup_Click(this, new EventArgs());
}
return;
}
}
foreach (DataRow dr in classTimes.Tables[1].Rows)
{
if ((int.Parse(dr["ExtraField1"].ToString()) <= int.Parse(txtExtraField1.Text) && int.Parse(dr["ExtraField2"].ToString()) >= int.Parse(txtExtraField1.Text))
|| (int.Parse(dr["ExtraField1"].ToString()) <= int.Parse(txtExtraField2.Text) && int.Parse(dr["ExtraField2"].ToString()) >= int.Parse(txtExtraField2.Text)))
{
txtExtraField3.Text += dr["ClassTimeID"].ToString() + ";";
}
}
divNewRoutineTimeGourp.Visible = false;
lblMessage.Text = "";
// sTD_ClassTime.ClassTimeID= int.Parse(ddlClassTimeID.SelectedValue);
sTD_ClassTime.ClassTimeName= txtClassTimeName.Text;
sTD_ClassTime.Duration= decimal.Parse(txtDuration.Text);
sTD_ClassTime.AddedBy= Profile.card_id;
sTD_ClassTime.AddedDate= DateTime.Now;
sTD_ClassTime.UpdatedBy= Profile.card_id;
sTD_ClassTime.UpdateDate= DateTime.Now;
sTD_ClassTime.Order= int.Parse(txtOrder.Text);
sTD_ClassTime.ClassTimeGroupID= int.Parse(ddlClassTimeGroupID.SelectedValue);
sTD_ClassTime.StartTime = (is12PMIssueStart ? "12:" + txtStartTime.Text.ToString().Split(':')[1] : txtStartTime.Text.ToString());
sTD_ClassTime.EndTime = (is12PMIssueEnd ? "12:" + txtEndTime.Text.ToString().Split(':')[1] : txtEndTime.Text.ToString());
sTD_ClassTime.ExtraField1= txtExtraField1.Text;
sTD_ClassTime.ExtraField2= txtExtraField2.Text;
sTD_ClassTime.ExtraField3= txtExtraField3.Text;
sTD_ClassTime.ExtraField4= txtExtraField4.Text;
sTD_ClassTime.ExtraField5= txtExtraField5.Text;
sTD_ClassTime.RowStatusID= int.Parse(ddlRowStatusID.SelectedValue);
int resutl =STD_ClassTimeManager.InsertSTD_ClassTime(sTD_ClassTime);
Response.Redirect("AdminDisplaySTD_ClassTime.aspx");
}
private void showSTD_ClassTimeData()
{
STD_ClassTime sTD_ClassTime = new STD_ClassTime ();
sTD_ClassTime = STD_ClassTimeManager.GetSTD_ClassTimeByClassTimeID(Int32.Parse(Request.QueryString["ID"]));
txtClassTimeName.Text =sTD_ClassTime.ClassTimeName.ToString();
txtDuration.Text =sTD_ClassTime.Duration.ToString();
txtOrder.Text =sTD_ClassTime.Order.ToString();
ddlClassTimeGroupID.SelectedValue =sTD_ClassTime.ClassTimeGroupID.ToString();
txtStartTime.Text =sTD_ClassTime.StartTime.ToString();
ddlStartHour.SelectedValue = txtStartTime.Text.Split(':')[0];
ddlStartMin.SelectedValue = txtStartTime.Text.Split(':')[1].Split(' ')[0];
ddlStartAMPM.SelectedValue = txtStartTime.Text.Split(':')[1].Split(' ')[1];
txtEndTime.Text = sTD_ClassTime.EndTime.ToString();
ddlEndHour.SelectedValue = txtEndTime.Text.Split(':')[0];
ddlEndMin.SelectedValue = txtEndTime.Text.Split(':')[1].Split(' ')[0];
ddlEndAMPM.SelectedValue = txtEndTime.Text.Split(':')[1].Split(' ')[1];
txtExtraField1.Text =sTD_ClassTime.ExtraField1.ToString();
txtExtraField2.Text =sTD_ClassTime.ExtraField2.ToString();
txtExtraField3.Text =sTD_ClassTime.ExtraField3.ToString();
txtExtraField4.Text =sTD_ClassTime.ExtraField4.ToString();
txtExtraField5.Text =sTD_ClassTime.ExtraField5.ToString();
ddlRowStatusID.SelectedValue =sTD_ClassTime.RowStatusID.ToString();
}
public static bool UpdateSTD_ClassTime(STD_ClassTime sTD_ClassTime)
{
SqlSTD_ClassTimeProvider sqlSTD_ClassTimeProvider = new SqlSTD_ClassTimeProvider();
return sqlSTD_ClassTimeProvider.UpdateSTD_ClassTime(sTD_ClassTime);
}
public static int InsertSTD_ClassTime(STD_ClassTime sTD_ClassTime)
{
SqlSTD_ClassTimeProvider sqlSTD_ClassTimeProvider = new SqlSTD_ClassTimeProvider();
return sqlSTD_ClassTimeProvider.InsertSTD_ClassTime(sTD_ClassTime);
}
