//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 + ">")));
}
}
