/// <summary> /// To Insert details of TimeTable in tbl_TimeTable_T table /// Created By : Darshan, 09/16/2014 /// Modified By : /// </summary> /// <param name="objTimeTableBO"></param> /// <returns></returns> public ApplicationResult TimeTable_Insert(TimeTableBO objTimeTableBO, int intClassMID, int intDivisionTID, int intLastModifiedUserID, string strLastModifiedDate) { try { pSqlParameter = new SqlParameter[7]; pSqlParameter[0] = new SqlParameter("@PeriodID", SqlDbType.Int); pSqlParameter[0].Direction = ParameterDirection.Input; pSqlParameter[0].Value = objTimeTableBO.PeriodID; pSqlParameter[1] = new SqlParameter("@SubjectMID", SqlDbType.Int); pSqlParameter[1].Direction = ParameterDirection.Input; pSqlParameter[1].Value = objTimeTableBO.SubjectMID; pSqlParameter[2] = new SqlParameter("@EmployeeMID", SqlDbType.Int); pSqlParameter[2].Direction = ParameterDirection.Input; pSqlParameter[2].Value = objTimeTableBO.EmployeeMID; pSqlParameter[3] = new SqlParameter("@ClassMID", SqlDbType.Int); pSqlParameter[3].Direction = ParameterDirection.Input; pSqlParameter[3].Value = intClassMID; pSqlParameter[4] = new SqlParameter("@DivisionTID", SqlDbType.Int); pSqlParameter[4].Direction = ParameterDirection.Input; pSqlParameter[4].Value = intDivisionTID; pSqlParameter[5] = new SqlParameter("@LastModifiedUserID", SqlDbType.Int); pSqlParameter[5].Direction = ParameterDirection.Input; pSqlParameter[5].Value = intLastModifiedUserID; pSqlParameter[6] = new SqlParameter("@LastModifiedDate", SqlDbType.VarChar); pSqlParameter[6].Direction = ParameterDirection.Input; pSqlParameter[6].Value = strLastModifiedDate; sSql = "usp_tbl_TimeTable_T_Insert"; int iResult = Database.ExecuteNonQuery(CommandType.StoredProcedure, sSql, pSqlParameter); if (iResult > 0) { ApplicationResult objResults = new ApplicationResult(); objResults.status = ApplicationResult.CommonStatusType.SUCCESS; return(objResults); } else { ApplicationResult objResults = new ApplicationResult(); objResults.status = ApplicationResult.CommonStatusType.FAILURE; return(objResults); } } catch (Exception ex) { throw ex; } finally { objTimeTableBO = null; } }
protected void btnSaveClass_OnClick(object sender, EventArgs e) { try { ApplicationResult objResult = new ApplicationResult(); TimeTableBO objTimeTableBo = new TimeTableBO(); TimeTableBL objTimeTableBl = new TimeTableBL(); for (int i = 1; i <= Convert.ToInt32(hfNoOfPeriod.Value); i++) { Label lbl = Page.Master.FindControl("ContentPlaceHolder1").FindControl("lblPeriod" + i.ToString()) as Label; DropDownList ddl1 = Page.Master.FindControl("ContentPlaceHolder1").FindControl("ddlSubject" + i.ToString()) as DropDownList; DropDownList ddl2 = Page.Master.FindControl("ContentPlaceHolder1").FindControl("ddlTeacher" + i.ToString()) as DropDownList; objTimeTableBo.PeriodID = Convert.ToInt32(lbl.Text); objTimeTableBo.SubjectMID = Convert.ToInt32(ddl1.SelectedValue); objTimeTableBo.EmployeeMID = Convert.ToInt32(ddl2.SelectedValue); objResult = objTimeTableBl.TimeTable_Insert(objTimeTableBo, Convert.ToInt32(ddlClass.SelectedValue), Convert.ToInt32(ddlDivision.SelectedValue), Convert.ToInt32(Session[ApplicationSession.USERID].ToString()), DateTime.UtcNow.AddHours(5.5).ToString()); } BindTimeTable(); PanelVisibility(1); ClientScript.RegisterStartupScript(typeof(Page), "MessagePopUp", "<script>alert('Record saved successfully.');</script>"); } catch (Exception ex) { logger.Error("Error", ex); ClientScript.RegisterStartupScript(typeof(Page), "MessagePopUp", "<script>alert('Oops! There is some technical issue. Please Contact to your administrator.');</script>"); } }
/// <summary> /// To Update details of TimeTable in tbl_TimeTable_T table /// Created By : Darshan, 09/16/2014 /// Modified By : /// </summary> /// <param name="objTimeTableBO"></param> /// <returns></returns> public ApplicationResult TimeTable_Update(TimeTableBO objTimeTableBO) { try { pSqlParameter = new SqlParameter[5]; pSqlParameter[0] = new SqlParameter("@TimeTableTID", SqlDbType.Int); pSqlParameter[0].Direction = ParameterDirection.Input; pSqlParameter[0].Value = objTimeTableBO.TimeTableTID; pSqlParameter[1] = new SqlParameter("@TimeTableMID", SqlDbType.Int); pSqlParameter[1].Direction = ParameterDirection.Input; pSqlParameter[1].Value = objTimeTableBO.TimeTableMID; pSqlParameter[2] = new SqlParameter("@PeriodID", SqlDbType.Int); pSqlParameter[2].Direction = ParameterDirection.Input; pSqlParameter[2].Value = objTimeTableBO.PeriodID; pSqlParameter[3] = new SqlParameter("@SubjectMID", SqlDbType.Int); pSqlParameter[3].Direction = ParameterDirection.Input; pSqlParameter[3].Value = objTimeTableBO.SubjectMID; pSqlParameter[4] = new SqlParameter("@EmployeeMID", SqlDbType.Int); pSqlParameter[4].Direction = ParameterDirection.Input; pSqlParameter[4].Value = objTimeTableBO.EmployeeMID; sSql = "usp_tbl_TimeTable_T_Update"; int iResult = Database.ExecuteNonQuery(CommandType.StoredProcedure, sSql, pSqlParameter); if (iResult > 0) { ApplicationResult objResults = new ApplicationResult(); objResults.status = ApplicationResult.CommonStatusType.SUCCESS; return(objResults); } else { ApplicationResult objResults = new ApplicationResult(); objResults.status = ApplicationResult.CommonStatusType.FAILURE; return(objResults); } } catch (Exception ex) { throw ex; } finally { objTimeTableBO = null; } }