/// <summary> /// To Insert details of Student in tbl_Student_M table /// Created By : NafisaMulla, 2/7/2014 /// Modified By : /// </summary> /// <param name="objStudentBO"></param> /// <returns></returns> public ApplicationResult Lock_Insert(LockBo objLockBo) { try { pSqlParameter = new SqlParameter[5]; pSqlParameter[0] = new SqlParameter("@TrustMID", SqlDbType.Int); pSqlParameter[0].Direction = ParameterDirection.Input; pSqlParameter[0].Value = objLockBo.TrustMID; pSqlParameter[1] = new SqlParameter("@SchoolMID", SqlDbType.Int); pSqlParameter[1].Direction = ParameterDirection.Input; pSqlParameter[1].Value = objLockBo.SchoolMID; pSqlParameter[2] = new SqlParameter("@FromDate", SqlDbType.VarChar); pSqlParameter[2].Direction = ParameterDirection.Input; pSqlParameter[2].Value = objLockBo.FromDate; pSqlParameter[3] = new SqlParameter("@ToDate", SqlDbType.VarChar); pSqlParameter[3].Direction = ParameterDirection.Input; pSqlParameter[3].Value = objLockBo.ToDate; pSqlParameter[4] = new SqlParameter("@LockYear", SqlDbType.Int); pSqlParameter[4].Direction = ParameterDirection.Input; pSqlParameter[4].Value = objLockBo.LockYear; sSql = "tbl_Lock_M_Insert"; DataTable dtResult = new DataTable(); dtResult = Database.ExecuteDataTable(CommandType.StoredProcedure, sSql, pSqlParameter); ApplicationResult objResults = new ApplicationResult(dtResult); objResults.status = ApplicationResult.CommonStatusType.SUCCESS; return(objResults); } catch (Exception ex) { throw ex; } finally { objLockBo = null; } }
protected void btnLogIn_Click(object sender, EventArgs e) { try { string strFromDate = txtFrom.Text; string strToDate = txtTo.Text; string LastTwoDigit, strYear; int intNo; LastTwoDigit = strToDate.Substring(strToDate.Length - 2); intNo = Convert.ToInt32(LastTwoDigit) - 1; strYear = intNo.ToString() + LastTwoDigit; LockBL objLockBl = new LockBL(); LockBo objLockBo = new LockBo(); ApplicationResult objResult = new ApplicationResult(); if (chkLock.Checked == true) { objLockBo.TrustMID = Convert.ToInt32(Session[ApplicationSession.TRUSTID]); objLockBo.SchoolMID = Convert.ToInt32(Session[ApplicationSession.SCHOOLID]); objLockBo.FromDate = strFromDate; objLockBo.ToDate = strToDate; objLockBo.LockYear = Convert.ToInt32(strYear); objResult = objLockBl.Lock_Insert(objLockBo); if (objResult.status == ApplicationResult.CommonStatusType.SUCCESS) { } } else { objResult = objLockBl.Lock_SelectbyYear(Convert.ToInt32(strYear)); if (objResult != null) { if (objResult.resultDT.Rows.Count > 0) { ClientScript.RegisterStartupScript(typeof(Page), "MessagePopUp", "<script>alert('The Data of financial year " + strYear + " has been locked.');</script>"); } else { EmployeeMBL objEmployeeMBL = new EmployeeMBL(); EmployeeMBO objEmployeeMBO = new EmployeeMBO(); ApplicationResult objResultValidate = new ApplicationResult(); objResultValidate = objEmployeeMBL.Employee_CheckForLoginAccount(txtUserName.Text, txtPassword.Text, Convert.ToInt32(Session[ApplicationSession.TRUSTID]), Convert.ToInt32(Session[ApplicationSession.SCHOOLID])); if (objResultValidate != null) { DataTable dtResult = new DataTable(); dtResult = objResultValidate.resultDT; if (dtResult.Rows.Count > 0) { if (Convert.ToInt32(Session[ApplicationSession.USERID]) == Convert.ToInt32(dtResult.Rows[0]["EmployeeMID"])) { Session[ApplicationSession.HASACCESSACCOUNTUSERID] = Convert.ToInt32(dtResult.Rows[0]["EmployeeMID"]); Session[ApplicationSession.ACCOUNTFROMDATE] = txtFrom.Text; Session[ApplicationSession.ACCOUNTTODATE] = txtTo.Text; Session[ApplicationSession.FINANCIALYEAR] = strYear; Response.Redirect( Convert.ToInt32(Session[ApplicationSession.SCHOOLID]) == 0 ? "../Accounting/Home.aspx?mode=TU" : "../Accounting/Home.aspx", false); } else { ClientScript.RegisterStartupScript(typeof(Page), "MessagePopUp", "<script>alert('Invalid username & password.');</script>"); } } else { ClientScript.RegisterStartupScript(typeof(Page), "MessagePopUp", "<script>alert('You do not have permission to access this module.');</script>"); } } else { } } } } } 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>"); } }