//Public Class IValidation // <JsonIgnore> Property isValid As Boolean // MustOverride Function Validation(Optional nomeProp As String = "") As ValidationResult //End Class public static bool CtrlValue(Object value, string nomeVar = "value", bool ctrlNothing = true, bool ctrlVoid = true, bool throwEx = true) { if (ctrlNothing == true && value == null) { Log.main.Add(new Mess(LogType.ERR, Log.main.errUserText, "ricevuto " + nomeVar + " a nothing")); if (throwEx == true) { throw new Exception(Excep.ScriviLogInEx(new Mess(LogType._Nothing, ""))); } return(false); } if (value != null && ctrlVoid == true) { if (value.GetType() == typeof(string)) { if ((string)value == "") { Log.main.Add(new Mess(LogType.ERR, Log.main.errUserText, "ricevuto " + nomeVar + " vuoto")); if (throwEx == true) { throw new Exception(Excep.ScriviLogInEx(new Mess(LogType._Nothing, ""))); } return(false); } } else { } } return(true); }
public ResultEntity SavePaymentRecords(string records, string studentCode, string studentName, string acYear, string courceName, string paymentType, string paymentDate, string recieptNo) { ResultEntity result = new ResultEntity(); UserEntity objUserEntity = UserEntity.GetInstance(); try { SqlParameter[] sqlParameter = new SqlParameter[12]; sqlParameter[0] = new SqlParameter("@STU_CODE", studentCode); sqlParameter[1] = new SqlParameter("@STUDENT_NAME", studentName); sqlParameter[2] = new SqlParameter("@ACADEMIC_YEAR", acYear); sqlParameter[3] = new SqlParameter("@COURSE", courceName); sqlParameter[4] = new SqlParameter("@PAYMENT_TYPE", paymentType); sqlParameter[5] = new SqlParameter("@PAYMENT_DATE", paymentDate); sqlParameter[6] = new SqlParameter("@RECIEPT_NO", recieptNo); sqlParameter[7] = new SqlParameter("@RECORDS", records); sqlParameter[8] = new SqlParameter("@CUSTOMER_ID", objUserEntity.customerId); sqlParameter[9] = new SqlParameter("@USER_ID", objUserEntity.userId); sqlParameter[10] = new SqlParameter("@FLAG", SqlDbType.Char); sqlParameter[10].Direction = ParameterDirection.Output; sqlParameter[10].Size = 1; sqlParameter[11] = new SqlParameter("@MSG", SqlDbType.NVarChar); sqlParameter[11].Direction = ParameterDirection.Output; sqlParameter[11].Size = 500; SqlHelper.ExecuteScalar(sqlConn, CommandType.StoredProcedure, "SP_STUDENT_FEE_PAYMENT", sqlParameter); result.flag = sqlParameter[10].Value.ToString(); result.msg = sqlParameter[11].Value.ToString(); return(result); } catch (Exception ex) { Excep.WriteException(ex); return(result); } }
public object Convert(object value, Type targetType, object parameter, CultureInfo culture) { if (parameter == null) { throw new InvalidOperationException(Excep.ScriviLogInEx(new Mess(LogType.ERR, Log.main.errUserText, "Ricevuto parameter a null"))); } if (parameter.GetType() != typeof(string)) { throw new InvalidOperationException(Excep.ScriviLogInEx(new Mess(LogType.ERR, Log.main.errUserText, "Ricevuto parameter di tipo:<" + parameter.GetType().ToString() + ">, deve essere una stringa"))); } try { if (value == null) { return((string)parameter == "null" ? true : false); } if (value.GetType() == typeof(Type).GetType()) //The type of value parameter is Type, in this case compare the property Name { return((value as Type).Name == (string)parameter ? true : false); } return((value.GetType().Name == (string)parameter) ? true : false); } catch (Exception ex) { throw new Exception(Excep.ScriviLogInEx(new Mess(LogType.ERR, Log.main.errUserText, "Eccezione ex.mess:<" + ex.Message + ">"))); } }
public ResultEntity SaveFeeRecords(string records) { ResultEntity result = new ResultEntity(); UserEntity objUserEntity = UserEntity.GetInstance(); try { // UserEntity objUserEntity = UserEntity.GetInstance(); SqlParameter[] sqlParameter = new SqlParameter[5]; sqlParameter[0] = new SqlParameter("@CUSTOMER_ID", objUserEntity.customerId); sqlParameter[1] = new SqlParameter("@USER_ID", objUserEntity.userId); sqlParameter[2] = new SqlParameter("@JSON_DATA", records); sqlParameter[3] = new SqlParameter("@FLAG", SqlDbType.Char); sqlParameter[3].Direction = ParameterDirection.Output; sqlParameter[3].Size = 1; sqlParameter[4] = new SqlParameter("@MSG", SqlDbType.NVarChar); sqlParameter[4].Direction = ParameterDirection.Output; sqlParameter[4].Size = 500; SqlHelper.ExecuteScalar(sqlConn, CommandType.StoredProcedure, "SP_MANAGE_FEE_DETAILS", sqlParameter); result.flag = sqlParameter[3].Value.ToString(); result.msg = sqlParameter[4].Value.ToString(); return(result); } catch (Exception ex) { Excep.WriteException(ex); return(result); } }
public ResultEntity GetFeeDetails(AccountEntity accountEntity) { ResultEntity result = new ResultEntity(); UserEntity objUserEntity = UserEntity.GetInstance(); try { // UserEntity objUserEntity = UserEntity.GetInstance(); SqlParameter[] sqlParameter = new SqlParameter[4]; sqlParameter[0] = new SqlParameter("@ACADEMIC_YEAR", accountEntity.academicYear); sqlParameter[1] = new SqlParameter("@COURSE", accountEntity.courseId); sqlParameter[2] = new SqlParameter("@CUSTOMER_ID", objUserEntity.customerId); sqlParameter[3] = new SqlParameter("@REPORT_ID", accountEntity.reportMapId); DataSet ds = new DataSet(); ds = SqlHelper.ExecuteDataset(sqlConn, CommandType.StoredProcedure, "SP_GET_FEE_DETAILS", sqlParameter); if (ds.Tables.Count > 0) { if (ds.Tables[0].Rows.Count > 0) { result.addParams = CommonFunc.DtToJSON(ds.Tables[0]); } } return(result); } catch (Exception ex) { Excep.WriteException(ex); return(result); } }
private void GetReportColumns(string reportType, int formID, string reportName, string rptColumns, string rptColAlias) { try { SqlParameter[] sqlParameter = new SqlParameter[8]; sqlParameter[0] = new SqlParameter("@PI_REPORT_TYPE", reportType); sqlParameter[1] = new SqlParameter("@PI_FORM_ID", formID); sqlParameter[2] = new SqlParameter("@PI_REPORT_ID", formID); sqlParameter[3] = new SqlParameter("@PI_REPORT_NAME", reportName); sqlParameter[4] = new SqlParameter("@PI_COLUMNS", rptColumns); sqlParameter[5] = new SqlParameter("@PI_COL_ALIAS", rptColAlias); sqlParameter[6] = new SqlParameter("@PO_RSP_FLAG", SqlDbType.NVarChar); sqlParameter[6].Direction = ParameterDirection.Output; sqlParameter[6].Size = 1; sqlParameter[7] = new SqlParameter("@PO_RSP_MSG", SqlDbType.NVarChar); sqlParameter[7].Direction = ParameterDirection.Output; sqlParameter[7].Size = 500; SqlHelper.ExecuteNonQuery(sqlConn, CommandType.StoredProcedure, "SP_INSERT_REPORT_CONFIG", sqlParameter); } catch (Exception ex) { Excep.WriteException(ex); } }
public ResultEntity GetFeeCollectionReport(string acYear, string course, string semester, string feeType, string reportType, string reportId) { ResultEntity result = new ResultEntity(); UserEntity objUserEntity = UserEntity.GetInstance(); try { // UserEntity objUserEntity = UserEntity.GetInstance(); SqlParameter[] sqlParameter = new SqlParameter[7]; sqlParameter[0] = new SqlParameter("@ACADEMIC_YEAR", acYear); sqlParameter[1] = new SqlParameter("@COURSE", course); sqlParameter[2] = new SqlParameter("@SEMESTER", semester); sqlParameter[3] = new SqlParameter("@FEE_TYPE", feeType); sqlParameter[4] = new SqlParameter("@CUSTOMER_ID", objUserEntity.customerId); sqlParameter[5] = new SqlParameter("@REPORT_TYPE", reportType); sqlParameter[6] = new SqlParameter("@REPORT_ID", Convert.ToInt32(reportId)); DataSet ds = new DataSet(); ds = SqlHelper.ExecuteDataset(sqlConn, CommandType.StoredProcedure, "SP_GET_FEE_COLLECTION_REPORT", sqlParameter); if (ds.Tables.Count > 0) { if (ds.Tables[0].Rows.Count > 0) { result.addParams = CommonFunc.DtToJSON(ds.Tables[0]); } } return(result); } catch (Exception ex) { Excep.WriteException(ex); return(result); } }
public object Convert(object value, Type targetType, object parameter, CultureInfo culture) { try { var vmBackupTypes = from tmp in Assembly.GetExecutingAssembly().GetTypes() where tmp.IsClass && tmp.BaseType == typeof(BackupBaseVM) select tmp; //List<string> backupsTypeName = (from tmpTypes in vmBackupTypes select tmpTypes.).ToList(); SortedList <int, string> backupsTypeName = new SortedList <int, string>(); foreach (Type type in vmBackupTypes) { PropertyInfo propInfoName = type.GetProperty("BackupTypeName"); PropertyInfo propInfoOrder = type.GetProperty("BackupTypeOrder"); backupsTypeName.Add((int)propInfoOrder.GetValue(null), (string)propInfoName.GetValue(null)); } return(backupsTypeName.Values.ToList()); } catch (Exception ex) { throw new Exception(Excep.ScriviLogInEx(new Mess(LogType.ERR, Log.main.errUserText, "Exception ex.mess:<" + ex.Message + ">"))); } }
public object Convert(object value, Type targetType, object parameter, CultureInfo culture) { try { //if (value.GetType().BaseType != typeof(BackupBaseM)) //{ Log.main.Add(new Mess(Tipi.ERR, Log.main.errUserText, "E' stato ricevuto un tipo che non eredita da BackupBaseM, val.GetType.BaseType:<" + value.GetType().BaseType.ToString() + ">")); } if (parameter == null) { throw new InvalidOperationException(Excep.ScriviLogInEx(new Mess(LogType.ERR, Log.main.errUserText, "Ricevuto parameter a null"))); } if (parameter.GetType().FullName != "System.RuntimeType") { throw new InvalidOperationException(Excep.ScriviLogInEx(new Mess(LogType.ERR, Log.main.errUserText, "Ricevuto parameter di tipo:<" + parameter.GetType().ToString() + ">, deve essere di tipo Type"))); } return(Activator.CreateInstance((Type)parameter, value)); } catch (Exception ex) { throw new Exception(Excep.ScriviLogInEx(new Mess(LogType.ERR, Log.main.errUserText, "Eccezione ex.mess:<" + ex.Message + ">"))); } }
public ResultEntity GetPaymentHistory(GetPaymentEntity paymentEntity) { ResultEntity result = new ResultEntity(); UserEntity objUserEntity = UserEntity.GetInstance(); try { SqlParameter[] sqlParameter = new SqlParameter[4]; sqlParameter[0] = new SqlParameter("@STU_CODE", paymentEntity.stuCode); sqlParameter[1] = new SqlParameter("@ACADEMIC_YEAR", paymentEntity.academicYear); sqlParameter[2] = new SqlParameter("@COURSE", paymentEntity.courseId); sqlParameter[3] = new SqlParameter("@REPORT_ID", Convert.ToInt32(paymentEntity.reportId)); DataSet ds = new DataSet(); ds = SqlHelper.ExecuteDataset(sqlConn, CommandType.StoredProcedure, "SP_GET_STUDENT_PAYMENT_HISTORY", sqlParameter); if (ds.Tables.Count > 0) { if (ds.Tables[0].Rows.Count > 0) { result.addParams = CommonFunc.DtToJSON(ds.Tables[0]); } } return(result); } catch (Exception ex) { Excep.WriteException(ex); return(result); } }
public Orario(string strOrario) { Mess logMess = new Mess(LogType._Nothing, Log.main.errUserText); if (ChkSintassiStringa(strOrario, aggiornaProprietà: true, logMess: logMess) == false) { logMess.tipo = LogType.ERR; throw new Exception(Excep.ScriviLogInEx(logMess)); } }
public object Convert(object[] values, Type targetType, object parameter, CultureInfo culture) { if (values.Count() < 3) { throw new Exception(Excep.ScriviLogInEx(new Mess(LogType.ERR, "", "values array ha meno di 3 elementi, values.Count:<" + values.Count() + ">"))); } if (values[0].GetType() != typeof(DataOre.WeekDay[])) { throw new Exception(Excep.ScriviLogInEx(new Mess(LogType.ERR, "", "l'elemento 0 dell'array values non è un array di DataOre.WeekDay, values[0].GetType:<" + values[0].GetType().ToString() + ">"))); } if (values[1].GetType() != typeof(SchedulerVM)) { throw new Exception(Excep.ScriviLogInEx(new Mess(LogType.ERR, "", "l'elemento 1 dell'array values non è un SchedulerVM, values[1].GetType:<" + values[1].GetType().ToString() + ">"))); } if (values[2].GetType() != typeof(DataGrid) && !values[2].GetType().IsSubclassOf(typeof(DataGrid))) { throw new Exception(Excep.ScriviLogInEx(new Mess(LogType.ERR, "", "l'elemento 2 dell'array values non è un DataGrid, values[2].GetType:<" + values[2].GetType().ToString() + ">"))); } List <DataOre.WeekDay> availableWeekDays = new List <DataOre.WeekDay>(); availableWeekDays.AddRange((DataOre.WeekDay[])values[0]); SchedulerVM schedulerVm = (SchedulerVM)values[1]; DataGrid dataGrid = (DataGrid)values[2]; foreach (WeekDayObj dayInScheduler in schedulerVm.SchedulerM.WeekDays) { //ogni giorno già presente nello scheduler lo tolgo dalla lista solo se non è il giorno già valorizzato nella combobox if (availableWeekDays.Contains(dayInScheduler.SelectedDay) && (dataGrid.SelectedItem == null || dayInScheduler != (WeekDayObj)dataGrid.SelectedItem)) { availableWeekDays.Remove(dayInScheduler.SelectedDay); } } if ((from tmp in schedulerVm.SchedulerM.WeekDays where tmp.SelectedDay == ((WeekDayObj)dataGrid.SelectedItem).SelectedDay && tmp != (WeekDayObj)dataGrid.SelectedItem select tmp).Count() > 0) { //Nel caso in cui il valore di default dell'enum è già stato preso, cioè presente già nello scheduler e oggetto diverso da quello della cella attuale... if (availableWeekDays.Count > 0) //...allora imposto il primo disponibile { ((WeekDayObj)dataGrid.SelectedItem).SelectedDay = availableWeekDays[0]; } else //...altrimenti cancello l'attuale elemento poichè non si sono più giorni disponibili { WeekDays days = (WeekDays)dataGrid.ItemsSource; days.Remove((WeekDayObj)dataGrid.SelectedItem); } } return(availableWeekDays.ToArray()); }
private void ImpostaStringaDaProprietà() { try { strOrario = Ora + ":" + Minuti + ":" + Secondi + "." + Millesimi; //uso la var strOrarioVM_ e non la prop. poichè non deve andare a risettare le property } catch (Exception ex) { throw new Exception(Excep.ScriviLogInEx(new Mess(LogType.ERR, Log.main.errUserText, ex.Message))); } }
public object Convert(object value, Type targetType, object parameter, CultureInfo culture) { try { return(value != parameter); } catch (Exception ex) { throw new Exception(Excep.ScriviLogInEx(new Mess(LogType.ERR, Log.main.errUserText, "Eccezione ex.mess:<" + ex.Message + ">"))); } }
public ResultEntity AddFeeDetails(AccountEntity accountEntity) { ResultEntity result = new ResultEntity(); UserEntity objUserEntity = UserEntity.GetInstance(); try { // UserEntity objUserEntity = UserEntity.GetInstance(); SqlParameter[] sqlParameter = new SqlParameter[15]; sqlParameter[0] = new SqlParameter("@ID", accountEntity.typeid); sqlParameter[1] = new SqlParameter("@FEE_NAME", accountEntity.feeName); sqlParameter[2] = new SqlParameter("@PAYMENT_TYPE", accountEntity.paymentType); sqlParameter[3] = new SqlParameter("@MONTH", accountEntity.feeMonth); sqlParameter[4] = new SqlParameter("@TERMS", Convert.ToInt32(accountEntity.feePeriod)); sqlParameter[5] = new SqlParameter("@DESCRIPTION", accountEntity.feeDesc); sqlParameter[6] = new SqlParameter("@CUSTOMER_ID", objUserEntity.customerId); sqlParameter[7] = new SqlParameter("@USER_ID", objUserEntity.userId); sqlParameter[8] = new SqlParameter("@IS_ACTIVE", accountEntity.isActive); sqlParameter[9] = new SqlParameter("@OPER_TYPE", accountEntity.flag); sqlParameter[10] = new SqlParameter("@FEE_SUBMISSION", accountEntity.feeSubmission); sqlParameter[11] = new SqlParameter("@FEE_RELAXATION", accountEntity.feeRelaxDay); sqlParameter[12] = new SqlParameter("@REPORT_ID", accountEntity.reportId); sqlParameter[13] = new SqlParameter("@FLAG", SqlDbType.Char); sqlParameter[13].Direction = ParameterDirection.Output; sqlParameter[13].Size = 1; sqlParameter[14] = new SqlParameter("@MSG", SqlDbType.NVarChar); sqlParameter[14].Direction = ParameterDirection.Output; sqlParameter[14].Size = 500; DataSet ds = new DataSet(); ds = SqlHelper.ExecuteDataset(sqlConn, CommandType.StoredProcedure, "SP_MANAGE_FEE_TYPE", sqlParameter); result.flag = sqlParameter[13].Value.ToString(); result.msg = sqlParameter[14].Value.ToString(); if (result.flag.ToUpper() == "S") { if (ds.Tables.Count > 0) { if (ds.Tables[0].Rows.Count > 0) { result.addParams = CommonFunc.DtToJSON(ds.Tables[0]); } } } return(result); } catch (Exception ex) { Excep.WriteException(ex); return(result); } }
public HourlyPeriods(params string[] coppieOnOff) { if (coppieOnOff.Length % 2 > 0) { throw new Exception(Excep.ScriviLogInEx(new Mess(LogType.ERR, Log.main.errUserText, "L'array coppieOnOff contiene un numero di orari non pari, coppieOnOff.Length:<" + coppieOnOff.Length + ">"))); } for (int i = 0; i < coppieOnOff.Length - 1; i += 2) { this.Items.Add(new PeriodoOrario(new Orario(coppieOnOff[i]), new Orario(coppieOnOff[i + 1]))); } }
} //Costruttore per datagrid public OnOffSeries(params UInt16[] onOffTuple) { if (onOffTuple.Length % 2 > 0) { throw new Exception(Excep.ScriviLogInEx(new Mess(LogType.ERR, Log.main.errUserText, "L'array onOffTuple contiene un numero di on off non pari, onOffTuple.Length:<" + onOffTuple.Length + ">"))); } for (int i = 0; i < onOffTuple.Length; i += 2) { this.Items.Add(new OnOff(onOffTuple[i], onOffTuple[i + 1])); } }
public MonthsAndDays(params byte[] coppieGiornoMese) { if (coppieGiornoMese.Length % 2 > 0) { throw new Exception(Excep.ScriviLogInEx(new Mess(LogType.ERR, Log.main.errUserText, "L'array coppieGiornoMese contiene un numero di giorni mesi non pari, coppieGiornoMese.Length:<" + coppieGiornoMese.Length + ">"))); } for (int i = 0; i < coppieGiornoMese.Length; i += 2) { this.Items.Add(new MonthAndDay(coppieGiornoMese[i], coppieGiornoMese[i + 1])); } }
public ResultEntity AddDuration(DurationEntity durationEntity) { ResultEntity result = new ResultEntity(); try { SqlParameter[] sqlParameter = new SqlParameter[13]; sqlParameter[0] = new SqlParameter("@DUR_ID", durationEntity.id); sqlParameter[1] = new SqlParameter("@CUSTOMER_ID", objUserEntity.customerId); sqlParameter[2] = new SqlParameter("@USER_ID", objUserEntity.userId); sqlParameter[3] = new SqlParameter("@YEAR_ID", durationEntity.academicYear); sqlParameter[4] = new SqlParameter("@COURSE_ID", durationEntity.courseId); sqlParameter[5] = new SqlParameter("@NO_OF_SEMESTER", durationEntity.semester); sqlParameter[6] = new SqlParameter("@START_DATE", durationEntity.wefDate); sqlParameter[7] = new SqlParameter("@END_DATE", durationEntity.wetDate); sqlParameter[8] = new SqlParameter("@IS_ACTIVE", durationEntity.active); sqlParameter[9] = new SqlParameter("@OPER_TYPE", durationEntity.flag); sqlParameter[10] = new SqlParameter("@REPORT_ID", Convert.ToInt32(durationEntity.reportId)); sqlParameter[11] = new SqlParameter("@FLAG", System.Data.SqlDbType.NVarChar); sqlParameter[11].Direction = ParameterDirection.Output; sqlParameter[11].Size = 1; sqlParameter[12] = new SqlParameter("@MSG", SqlDbType.NVarChar); sqlParameter[12].Direction = ParameterDirection.Output; sqlParameter[12].Size = 500; DataSet ds = new DataSet(); ds = SqlHelper.ExecuteDataset(sqlConn, CommandType.StoredProcedure, "SP_COURSE_DURATION", sqlParameter); result.flag = sqlParameter[11].Value.ToString(); result.msg = sqlParameter[12].Value.ToString(); if (result.flag.ToUpper() == "S") { if (ds != null) { if (ds.Tables[0].Rows.Count > 0) { result.addParams = CommonFunc.DtToJSON(ds.Tables[0]); } } } return(result); } catch (Exception ex) { Excep.WriteException(ex); return(result); } }
public ResultEntity AddSubject(SubjectEntity subjectEntity) { objUserEntity = (UserEntity)HttpContext.Current.Session["UserDetails"]; ResultEntity result = new ResultEntity(); try { SqlParameter[] sqlParameter = new SqlParameter[13]; sqlParameter[0] = new SqlParameter("@SUBJECT_ID", subjectEntity.subjectId); sqlParameter[1] = new SqlParameter("@SUBJECT_CODE", subjectEntity.subjectCode); sqlParameter[2] = new SqlParameter("@SUBJECT_NAME", subjectEntity.subjectName); sqlParameter[3] = new SqlParameter("@SUBJECT_SHORT_NAME", subjectEntity.shortName); sqlParameter[4] = new SqlParameter("@SUBJECT_MEDIUM", subjectEntity.medium); sqlParameter[5] = new SqlParameter("@SUBJECT_TYPE", subjectEntity.subjectType); sqlParameter[6] = new SqlParameter("@CUSTOMER_ID", objUserEntity.customerId); sqlParameter[7] = new SqlParameter("@USER_ID", objUserEntity.userId); sqlParameter[8] = new SqlParameter("@IS_ACTIVE", subjectEntity.active); sqlParameter[9] = new SqlParameter("@REPORT_ID", Convert.ToInt32(subjectEntity.reportId)); sqlParameter[10] = new SqlParameter("@OPER_TYPE", subjectEntity.flag); sqlParameter[11] = new SqlParameter("@FLAG", SqlDbType.Char); sqlParameter[11].Direction = ParameterDirection.Output; sqlParameter[11].Size = 1; sqlParameter[12] = new SqlParameter("@MSG", SqlDbType.NVarChar); sqlParameter[12].Direction = ParameterDirection.Output; sqlParameter[12].Size = 500; DataSet ds = new DataSet(); ds = SqlHelper.ExecuteDataset(sqlConn, CommandType.StoredProcedure, "SP_SUBJECT", sqlParameter); result.flag = sqlParameter[11].Value.ToString(); result.msg = sqlParameter[12].Value.ToString(); if (result.flag.ToUpper() == "S") { if (ds != null) { if (ds.Tables[0].Rows.Count > 0) { result.addParams = CommonFunc.DtToJSON(ds.Tables[0]); } } } return(result); } catch (Exception ex) { Excep.WriteException(ex); return(result); } }
public ResultEntity AddHoliday(HolidayListEntity holidayEntity) { objUserEntity = (UserEntity)HttpContext.Current.Session["UserDetails"]; ResultEntity result = new ResultEntity(); try { SqlParameter[] sqlParameter = new SqlParameter[12]; sqlParameter[0] = new SqlParameter("@ACADEMIC_ID", holidayEntity.acyr); sqlParameter[1] = new SqlParameter("@HOLIDAY_ID", holidayEntity.hldy); sqlParameter[2] = new SqlParameter("@START_DATE", holidayEntity.wfDate); sqlParameter[3] = new SqlParameter("@END_DATE", holidayEntity.wtDate); sqlParameter[4] = new SqlParameter("@RH_ID", holidayEntity.res); sqlParameter[5] = new SqlParameter("@CUSTOMER_ID", objUserEntity.customerId); sqlParameter[6] = new SqlParameter("@USER_ID", objUserEntity.userId); sqlParameter[7] = new SqlParameter("@IS_ACTIVE", holidayEntity.active); sqlParameter[8] = new SqlParameter("@REPORT_ID", Convert.ToInt32(holidayEntity.reportId)); sqlParameter[9] = new SqlParameter("@OPER_TYPE", holidayEntity.flag); sqlParameter[10] = new SqlParameter("@FLAG", SqlDbType.Char); sqlParameter[10].Direction = ParameterDirection.Output; sqlParameter[10].Size = 1; sqlParameter[11] = new SqlParameter("@MSG", SqlDbType.NVarChar); sqlParameter[11].Direction = ParameterDirection.Output; sqlParameter[11].Size = 500; DataSet ds = new DataSet(); ds = SqlHelper.ExecuteDataset(sqlConn, CommandType.StoredProcedure, "SP_HOLIDAY_LIST", sqlParameter); result.flag = sqlParameter[10].Value.ToString(); result.msg = sqlParameter[11].Value.ToString(); if (result.flag.ToUpper() == "S") { if (ds != null) { if (ds.Tables[0].Rows.Count > 0) { result.addParams = CommonFunc.DtToJSON(ds.Tables[0]); } } } return(result); } catch (Exception ex) { Excep.WriteException(ex); return(result); } }
public ResultEntity GetPaymentDeatils(GetPaymentEntity paymentEntity) { ResultEntity result = new ResultEntity(); UserEntity objUserEntity = UserEntity.GetInstance(); try { // UserEntity objUserEntity = UserEntity.GetInstance(); SqlParameter[] sqlParameter = new SqlParameter[9]; sqlParameter[0] = new SqlParameter("@STU_CODE", paymentEntity.stuCode); sqlParameter[1] = new SqlParameter("@ACADEMIC_YEAR", paymentEntity.academicYear); sqlParameter[2] = new SqlParameter("@COURSE", paymentEntity.courseId); sqlParameter[3] = new SqlParameter("@CUSTOMER_ID", paymentEntity.customerId); sqlParameter[4] = new SqlParameter("@REPORT_ID", Convert.ToInt32(paymentEntity.reportId)); sqlParameter[5] = new SqlParameter("@RECIEPT_NO", SqlDbType.Char); sqlParameter[5].Direction = ParameterDirection.Output; sqlParameter[5].Size = 200; sqlParameter[6] = new SqlParameter("@PAYMENT_TYPE", SqlDbType.NVarChar); sqlParameter[6].Direction = ParameterDirection.Output; sqlParameter[6].Size = 2; sqlParameter[7] = new SqlParameter("@REMARKS", SqlDbType.NVarChar); sqlParameter[7].Direction = ParameterDirection.Output; sqlParameter[7].Size = 500; sqlParameter[8] = new SqlParameter("@PAYMENT_DATE", SqlDbType.NVarChar); sqlParameter[8].Direction = ParameterDirection.Output; sqlParameter[8].Size = 500; DataSet ds = new DataSet(); ds = SqlHelper.ExecuteDataset(sqlConn, CommandType.StoredProcedure, "SP_GET_STUDENT_FEE_PAY_LIST", sqlParameter); if (ds.Tables.Count > 0) { if (ds.Tables[0].Rows.Count > 0) { result.addParams = CommonFunc.DtToJSON(ds.Tables[0]); } } return(result); } catch (Exception ex) { Excep.WriteException(ex); return(result); } }
public ResultEntity AddActivity(ActivityEntity activityEntity, string customerId, string userid) { ResultEntity result = new ResultEntity(); try { SqlParameter[] sqlParameter = new SqlParameter[12]; sqlParameter[0] = new SqlParameter("@ACTIVITY_ID", activityEntity.actId); sqlParameter[1] = new SqlParameter("@CUSTOMER_ID", objUserEntity.customerId); sqlParameter[2] = new SqlParameter("@USER_ID", objUserEntity.userId); sqlParameter[3] = new SqlParameter("@ACTIVITY_NAME", activityEntity.actName); sqlParameter[4] = new SqlParameter("@ACTIVITY_TYPE", activityEntity.actType); sqlParameter[5] = new SqlParameter("@START_DATE", activityEntity.wfDate); sqlParameter[6] = new SqlParameter("@END_DATE", activityEntity.wetDate); sqlParameter[7] = new SqlParameter("@IS_ACTIVE", activityEntity.active); sqlParameter[8] = new SqlParameter("@OPER_TYPE", activityEntity.flag); sqlParameter[9] = new SqlParameter("@REPORT_ID", activityEntity.reportId); sqlParameter[10] = new SqlParameter("@FLAG", System.Data.SqlDbType.NVarChar); sqlParameter[10].Direction = ParameterDirection.Output; sqlParameter[10].Size = 1; sqlParameter[11] = new SqlParameter("@MSG", SqlDbType.NVarChar); sqlParameter[11].Direction = ParameterDirection.Output; sqlParameter[11].Size = 500; DataSet ds = new DataSet(); ds = SqlHelper.ExecuteDataset(sqlConn, CommandType.StoredProcedure, "SP_ACTIVITY", sqlParameter); result.flag = sqlParameter[10].Value.ToString(); result.msg = sqlParameter[11].Value.ToString(); if (result.flag.ToUpper() == "S") { if (ds != null) { if (ds.Tables[0].Rows.Count > 0) { result.addParams = CommonFunc.DtToJSON(ds.Tables[0]); } } } return(result); } catch (Exception ex) { Excep.WriteException(ex); return(result); } }
public ResultEntity SectionDetails(SectionEntity sectionEntity) { ResultEntity result = new ResultEntity(); UserEntity objUserEntity = UserEntity.GetInstance(); try { SqlParameter[] sqlParameter = new SqlParameter[11]; sqlParameter[0] = new SqlParameter("@SECTION_ID", sectionEntity.sectionId); sqlParameter[1] = new SqlParameter("@COURSE_ID", Convert.ToInt32(sectionEntity.courseId)); sqlParameter[2] = new SqlParameter("@SEMESTER_ID", sectionEntity.semesterId); sqlParameter[3] = new SqlParameter("@SECTION_NAME", sectionEntity.sectionName); sqlParameter[4] = new SqlParameter("@CUSTOMER_ID", objUserEntity.customerId); sqlParameter[5] = new SqlParameter("@USER_ID", objUserEntity.userId); sqlParameter[6] = new SqlParameter("@IS_ACTIVE", sectionEntity.isActive); sqlParameter[7] = new SqlParameter("@REPORT_ID", Convert.ToInt32(sectionEntity.reportId)); sqlParameter[8] = new SqlParameter("@OPER_TYPE", sectionEntity.operType); sqlParameter[9] = new SqlParameter("@FLAG", SqlDbType.Char); sqlParameter[9].Direction = ParameterDirection.Output; sqlParameter[9].Size = 1; sqlParameter[10] = new SqlParameter("@MSG", SqlDbType.NVarChar); sqlParameter[10].Direction = ParameterDirection.Output; sqlParameter[10].Size = 200; DataSet ds = new DataSet(); ds = SqlHelper.ExecuteDataset(sqlConn, CommandType.StoredProcedure, "SP_SECTION", sqlParameter); result.flag = sqlParameter[9].Value.ToString(); result.msg = sqlParameter[10].Value.ToString(); if (result.flag.ToUpper() == "S") { if (ds != null) { if (ds.Tables[0].Rows.Count > 0) { result.addParams = CommonFunc.DtToJSON(ds.Tables[0]); } } } return(result); } catch (Exception ex) { Excep.WriteException(ex); return(result); } }
public ResultEntity AddMappingDetails(MappingEntity mapping) { ResultEntity result = new ResultEntity(); try { SqlParameter[] sqlParameter = new SqlParameter[11]; sqlParameter[0] = new SqlParameter("@ID", mapping.mapId); sqlParameter[1] = new SqlParameter("@CUSTOMER_ID", objUserEntity.customerId); sqlParameter[2] = new SqlParameter("@USER_ID", objUserEntity.userId); sqlParameter[3] = new SqlParameter("@COURSE_ID", Convert.ToInt32(mapping.course)); sqlParameter[4] = new SqlParameter("@SEMESTER", Convert.ToInt32(mapping.semester)); sqlParameter[5] = new SqlParameter("@SUBJECT_ID", Convert.ToInt32(mapping.subject)); sqlParameter[6] = new SqlParameter("@IS_ACTIVE", mapping.active); sqlParameter[7] = new SqlParameter("@OPER_TYPE", mapping.flag); sqlParameter[8] = new SqlParameter("@REPORT_ID", mapping.reportId); sqlParameter[9] = new SqlParameter("@FLAG", System.Data.SqlDbType.NVarChar); sqlParameter[9].Direction = ParameterDirection.Output; sqlParameter[9].Size = 1; sqlParameter[10] = new SqlParameter("@MSG", SqlDbType.NVarChar); sqlParameter[10].Direction = ParameterDirection.Output; sqlParameter[10].Size = 500; DataSet ds = new DataSet(); ds = SqlHelper.ExecuteDataset(sqlConn, CommandType.StoredProcedure, "SP_COURSE_MAPPING", sqlParameter); result.flag = sqlParameter[9].Value.ToString(); result.msg = sqlParameter[10].Value.ToString(); if (result.flag.ToUpper() == "S") { if (ds != null) { if (ds.Tables[0].Rows.Count > 0) { result.addParams = CommonFunc.DtToJSON(ds.Tables[0]); } } } return(result); } catch (Exception ex) { Excep.WriteException(ex); return(result); } }
public ResultEntity AddCourse(CourseEntity courseEntity) { ResultEntity result = new ResultEntity(); try { objUserEntity = (UserEntity)HttpContext.Current.Session["UserDetails"]; SqlParameter[] sqlParameter = new SqlParameter[11]; sqlParameter[0] = new SqlParameter("@COURSE_ID", courseEntity.courserId); sqlParameter[1] = new SqlParameter("@CUSTOMER_ID", objUserEntity.customerId); sqlParameter[2] = new SqlParameter("@USER_ID", objUserEntity.userId); sqlParameter[3] = new SqlParameter("@COURSE_TYPE", courseEntity.courseType); sqlParameter[4] = new SqlParameter("@COURSE_NAME", courseEntity.courseName); sqlParameter[5] = new SqlParameter("@NO_OF_SEMESTER", courseEntity.noOfSemester); sqlParameter[6] = new SqlParameter("@IS_ACTIVE", courseEntity.active); sqlParameter[7] = new SqlParameter("@OPER_TYPE", courseEntity.flag); sqlParameter[8] = new SqlParameter("@REPORT_ID", Convert.ToInt32(courseEntity.reportId)); sqlParameter[9] = new SqlParameter("@FLAG", SqlDbType.Char); sqlParameter[9].Direction = ParameterDirection.Output; sqlParameter[9].Size = 1; sqlParameter[10] = new SqlParameter("@MSG", SqlDbType.NVarChar); sqlParameter[10].Direction = ParameterDirection.Output; sqlParameter[10].Size = 500; DataSet ds = new DataSet(); ds = SqlHelper.ExecuteDataset(sqlConn, CommandType.StoredProcedure, "SP_COURSE", sqlParameter); result.flag = sqlParameter[9].Value.ToString(); result.msg = sqlParameter[10].Value.ToString(); if (result.flag.ToUpper() == "S") { if (ds != null) { if (ds.Tables[0].Rows.Count > 0) { result.addParams = CommonFunc.DtToJSON(ds.Tables[0]); } } } return(result); } catch (Exception ex) { Excep.WriteException(ex); return(result); } }
protected void InitHandlers() { this.DEPENDENCIES = new Dictionary <string, object> { }; Server.Log.Debugger.CallEvent(Server.net.Airtower.INFO_EVENT, "Loading server dependencies..."); Assembly CurrentAssembly = Assembly.GetExecutingAssembly(); string Namespace = "Times.Client.Dependencies"; // Change if if you mean to change the name space of the class // Prefer using String.Equal comparison. Type[] Dependencies = CurrentAssembly.GetTypes().Where(type => String.Equals(type.Namespace, Namespace, StringComparison.Ordinal) && type.IsClass && !type.IsAbstract).ToArray(); for (var _loc1_ = 0; _loc1_ < Dependencies.Length; _loc1_++) { try { var Class = Activator.CreateInstance(Dependencies[_loc1_]); string linkage_name; if (Dependencies[_loc1_].GetProperty("CLASS_LINKAGE_NAME") != null) { linkage_name = ((dynamic)Class).CLASS_LINKAGE_NAME; } else { linkage_name = Dependencies[_loc1_].Name; } this.DEPENDENCIES[linkage_name] = Class; } catch (Exception Excep) { Server.Log.Debugger.CallEvent(Server.net.Airtower.ERROR_EVENT, "Unable to load dependency : \n" + Excep.InnerException); Server.Log.Debugger.CallEvent(Server.net.Airtower.WARN_EVENT, "Server exited!"); Server.Log.Debugger.CallEvent(Server.net.Airtower.WARN_EVENT, Excep.ToString()); Console.Write("Press any key to exit..."); Console.Read(); Environment.Exit(0); } } Server.Log.Debugger.CallEvent(Server.net.Airtower.INFO_EVENT, String.Format("Successfully loaded {0} dependencies!", Dependencies.Length)); }
public string GetCourseDDL(string ddlType) { try { SqlDataReader dr; SqlParameter[] sqlParameter = new SqlParameter[2]; sqlParameter[0] = new SqlParameter("@P_FLAG", '2'); sqlParameter[1] = new SqlParameter("@DDL_TYPE", ddlType); dr = SqlHelper.ExecuteReader(sqlConn, CommandType.StoredProcedure, "SP_GET_COURSE_SEM_DETAILS", sqlParameter); string details = CommonFunc.RdrToJSON(dr); return(details); } catch (Exception ex) { Excep.WriteException(ex); return(""); } }
public object Convert(object value, Type targetType, object parameter, CultureInfo culture) { if (targetType != typeof(Visibility)) { throw new Exception(Excep.ScriviLogInEx(new Mess(LogType.ERR, Log.main.errUserText, "The target must be a Visibility"))); } if (value == null) { throw new Exception(Excep.ScriviLogInEx(new Mess(LogType.ERR, Log.main.errUserText, "Rcevuto param value a nothing"))); } if (value.GetType() == typeof(Boolean)) { if ((Boolean)value == true) { return(Visibility.Visible); } if ((Boolean)value == false) { return(Visibility.Hidden); } } if (value.IsNumeric() == false) { throw new Exception(Excep.ScriviLogInEx(new Mess(LogType.ERR, Log.main.errUserText, "Rcevuto param value non booleano ne numerico"))); } switch (value) { case 0: return(Visibility.Hidden); case 1: return(Visibility.Visible); case 2: return(Visibility.Collapsed); default: throw new Exception(Excep.ScriviLogInEx(new Mess(LogType.ERR, Log.main.errUserText, "Ricevuto valore numerico disatteso per param value:<" + value.ToString() + ">"))); } }
public object Convert(object value, Type targetType, object parameter, CultureInfo culture) { if (parameter == null) { throw new InvalidOperationException(Excep.ScriviLogInEx(new Mess(LogType.ERR, Log.main.errUserText, "Ricevuto parameter a null"))); } if (parameter.GetType().FullName != "System.RuntimeType") { throw new InvalidOperationException(Excep.ScriviLogInEx(new Mess(LogType.ERR, Log.main.errUserText, "Ricevuto parameter di tipo:<" + parameter.GetType().ToString() + ">, deve essere di tipo Type"))); } try { if (value == null) { if (parameter == null) { return(true); } else { return(false); } } if (parameter == null) { if (value == null) { return(true); } else { return(false); } } return(((Type)value).FullName == ((Type)parameter).FullName ? true : false); } catch (Exception ex) { throw new Exception(Excep.ScriviLogInEx(new Mess(LogType.ERR, Log.main.errUserText, "Eccezione ex.mess:<" + ex.Message + ">"))); } }