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 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);
}
}
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 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 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);
}
}
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 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 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 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 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 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);
}
}
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 void ProcessRequest(HttpContext context)
{
try
{
context.Response.ContentType = "text/plain";
context.Response.Write("Hello World");
HttpPostedFile postedFile = context.Request.Files[0];
if (postedFile != null)
{
string pic = System.IO.Path.GetFileName(postedFile.FileName + DateTime.Now.ToString());
string path = System.IO.Path.Combine(HttpContext.Current.Server.MapPath("~/Content/images/"), pic);
postedFile.SaveAs(path);
}
}
catch (Exception ex)
{
Excep.WriteException(ex);
}
}
public SqlDataReader GetDropDownData(string ddlType, char flag)
{
string details = string.Empty;
SqlDataReader dr = null;
try
{
string sqlConn = System.Configuration.ConfigurationManager.ConnectionStrings["CS"].ConnectionString;
SqlParameter[] sqlParameter = new SqlParameter[2];
sqlParameter[0] = new SqlParameter("@P_FLAG", flag);
sqlParameter[1] = new SqlParameter("@DDL_TYPE", ddlType);
dr = SqlHelper.ExecuteReader(sqlConn, CommandType.StoredProcedure, "SP_GET_DROPDOWN_DATA", sqlParameter);
return(dr);
}
catch (Exception ex)
{
Excep.WriteException(ex);
return(dr);
}
}
public ResultEntity GetEmployee(EmployeeEntity employeeEntity)
{
ResultEntity result = new ResultEntity();
try
{
UserEntity objUserEntity = UserEntity.GetInstance();
SqlParameter[] sqlParameter = new SqlParameter[11];
string empFullName = employeeEntity.empFirst + employeeEntity.empLast;
sqlParameter[0] = new SqlParameter("@EMP_CODE", employeeEntity.empCode);
sqlParameter[1] = new SqlParameter("@EMPLOYEE_NAME", empFullName);
sqlParameter[2] = new SqlParameter("@DEPARTMENT", employeeEntity.empDept);
sqlParameter[3] = new SqlParameter("@DESIGNATION", employeeEntity.empDesig);
sqlParameter[4] = new SqlParameter("@EMPLOYEE_TYPE", employeeEntity.empType);
sqlParameter[5] = new SqlParameter("@STATE", employeeEntity.empState);
sqlParameter[6] = new SqlParameter("@CITY", employeeEntity.empCity);
sqlParameter[7] = new SqlParameter("@LOGIN_ID", employeeEntity.empLogin);
sqlParameter[8] = new SqlParameter("@ROLE", employeeEntity.empRole);
sqlParameter[9] = new SqlParameter("@CUSTOMER_ID", Convert.ToInt32(objUserEntity.customerId));
sqlParameter[10] = new SqlParameter("@REPORT_ID", Convert.ToInt32(employeeEntity.reportId));
DataSet ds = new DataSet();
ds = SqlHelper.ExecuteDataset(sqlConn, CommandType.StoredProcedure, "SP_GET_EMPLOYEE_DETAILS", sqlParameter);
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 GetStudent(StudentEntity studentEntity)
{
ResultEntity result = new ResultEntity();
try
{
UserEntity objUserEntity = UserEntity.GetInstance();
SqlParameter[] sqlParameter = new SqlParameter[9];
string stuFullName = studentEntity.stuFirst + studentEntity.stuLast;
sqlParameter[0] = new SqlParameter("@STU_CODE", studentEntity.stuCode);
sqlParameter[1] = new SqlParameter("@STUDENT_NAME", stuFullName);
sqlParameter[2] = new SqlParameter("@COURSE", studentEntity.stuCourse);
sqlParameter[3] = new SqlParameter("@SEMESTER", studentEntity.stuSemester);
sqlParameter[4] = new SqlParameter("@ACADEMIC_YEAR", studentEntity.stuAcade);
sqlParameter[5] = new SqlParameter("@CATEGORY", studentEntity.stuCategory);
sqlParameter[6] = new SqlParameter("@LOGIN_ID", studentEntity.stuLogin);
sqlParameter[7] = new SqlParameter("@CUSTOMER_ID", Convert.ToInt32(objUserEntity.customerId));
sqlParameter[8] = new SqlParameter("@REPORT_ID", Convert.ToInt32(studentEntity.reportId));
DataSet ds = new DataSet();
ds = SqlHelper.ExecuteDataset(sqlConn, CommandType.StoredProcedure, "SP_GET_STUDENT_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);
}
}
public ResultEntity AddEmployee(EmployeeEntity employeeEntity)
{
ResultEntity result = new ResultEntity();
try
{
UserEntity objUserEntity = UserEntity.GetInstance();
SqlParameter[] sqlParameter = new SqlParameter[47];
sqlParameter[0] = new SqlParameter("@EMP_CODE", employeeEntity.empCode);
sqlParameter[1] = new SqlParameter("@FIRST_NAME", employeeEntity.empFirst);
sqlParameter[2] = new SqlParameter("@LAST_NAME", employeeEntity.empLast);
sqlParameter[3] = new SqlParameter("@QUALIFICATION", employeeEntity.empQuali);
sqlParameter[4] = new SqlParameter("@DEPARTMENT", employeeEntity.empDept);
sqlParameter[5] = new SqlParameter("@DESIGNATION", employeeEntity.empDesig);
sqlParameter[6] = new SqlParameter("@EMPLOYEE_TYPE", employeeEntity.empType);
sqlParameter[7] = new SqlParameter("@JOB_TYPE", employeeEntity.empJType);
sqlParameter[8] = new SqlParameter("@FATHER_NAME", employeeEntity.empFather);
sqlParameter[9] = new SqlParameter("@MOTHER_NAME", employeeEntity.empMother);
sqlParameter[10] = new SqlParameter("@SEX", employeeEntity.empSex);
sqlParameter[11] = new SqlParameter("@DATE_OF_BIRTH", employeeEntity.empDOB);
sqlParameter[12] = new SqlParameter("@DATE_OF_JOINING", employeeEntity.empDOJ);
sqlParameter[13] = new SqlParameter("@SPOOUSE_NAME", employeeEntity.empSpoou);
sqlParameter[14] = new SqlParameter("@BLOOD_GROUP", employeeEntity.empBGrp);
sqlParameter[15] = new SqlParameter("@MARITAL_STATUS", employeeEntity.empMStat);
sqlParameter[16] = new SqlParameter("@NATIONALITY", employeeEntity.empNation);
sqlParameter[17] = new SqlParameter("@ADDRESS_LINE_1", employeeEntity.empAdres);
sqlParameter[18] = new SqlParameter("@ADDRESS_LINE_2", employeeEntity.empAdres2);
sqlParameter[19] = new SqlParameter("@MOBILE_NO", employeeEntity.empMobile);
sqlParameter[20] = new SqlParameter("@PHONE_NO", employeeEntity.empPhone);
sqlParameter[21] = new SqlParameter("@STATE", employeeEntity.empState);
sqlParameter[22] = new SqlParameter("@CITY", employeeEntity.empCity);
sqlParameter[23] = new SqlParameter("@ZIPCODE", employeeEntity.empZip);
sqlParameter[24] = new SqlParameter("@L_EMPLOYER_NAME", employeeEntity.preEmp);
sqlParameter[25] = new SqlParameter("@L_DATE_OF_JOINING", employeeEntity.preDOJ);
sqlParameter[26] = new SqlParameter("@L_DATE_OF_LEAVING", employeeEntity.preDOL);
sqlParameter[27] = new SqlParameter("@L_PHONE", employeeEntity.prePhone);
sqlParameter[28] = new SqlParameter("@L_EXPERIENCE", employeeEntity.empExpre);
sqlParameter[29] = new SqlParameter("@L_REASON", employeeEntity.empResLeav);
sqlParameter[30] = new SqlParameter("@L_SALARY", employeeEntity.preSal);
sqlParameter[31] = new SqlParameter("@SUBJECTS", employeeEntity.empSub);
sqlParameter[32] = new SqlParameter("@BANK_NAME", employeeEntity.empBank);
sqlParameter[33] = new SqlParameter("@BANK_ACCOUNT", employeeEntity.empAccNo);
sqlParameter[34] = new SqlParameter("@IFSC_CODE", employeeEntity.empIFSC);
sqlParameter[35] = new SqlParameter("@ADDHAR_NO", employeeEntity.empAdhar);
sqlParameter[36] = new SqlParameter("@PF_NUMBER", employeeEntity.empPF);
sqlParameter[37] = new SqlParameter("@SALARY", employeeEntity.empSalary);
sqlParameter[38] = new SqlParameter("@LOGIN_ID", employeeEntity.empLogin);
sqlParameter[39] = new SqlParameter("@PASSWORD", employeeEntity.empPwd);
sqlParameter[40] = new SqlParameter("@ROLE_ID", employeeEntity.empRole);
sqlParameter[41] = new SqlParameter("@ACCOUNT_STATUS", employeeEntity.empAccStat);
sqlParameter[42] = new SqlParameter("@CUSTOMER_ID", Convert.ToInt32(objUserEntity.customerId));
sqlParameter[43] = new SqlParameter("@USER_ID", objUserEntity.userId);
//sqlParameter[16] = new SqlParameter("@P_IMG_PATH", employeeEntity.imgPath);
sqlParameter[44] = new SqlParameter("@OPER_TYPE", employeeEntity.flag);
sqlParameter[45] = new SqlParameter("@FLAG", SqlDbType.Char);
sqlParameter[45].Direction = ParameterDirection.Output;
sqlParameter[45].Size = 1;
sqlParameter[46] = new SqlParameter("@MSG", SqlDbType.NVarChar);
sqlParameter[46].Direction = ParameterDirection.Output;
sqlParameter[46].Size = 500;
DataSet ds = new DataSet();
int count = SqlHelper.ExecuteNonQuery(sqlConn, CommandType.StoredProcedure, "SP_MANAGE_EMPLOYEE", sqlParameter);
result.flag = sqlParameter[45].Value.ToString();
result.msg = sqlParameter[46].Value.ToString();
return(result);
}
catch (Exception ex)
{
Excep.WriteException(ex);
return(result);
}
}
public ResultEntity AddStudent(StudentEntity studentEntity)
{
ResultEntity result = new ResultEntity();
// var file= studentEntity.postedFile[0];
String timeStamp = DateTime.Now.ToString();
try
{
SqlParameter[] sqlParameter = new SqlParameter[54];
sqlParameter[0] = new SqlParameter("@STU_CODE", studentEntity.stuCode);
sqlParameter[1] = new SqlParameter("@FIRST_NAME", studentEntity.stuFirst);
sqlParameter[2] = new SqlParameter("@LAST_NAME", studentEntity.stuLast);
sqlParameter[3] = new SqlParameter("@COURSE", studentEntity.stuCourse);
sqlParameter[4] = new SqlParameter("@SEMESTER", studentEntity.stuSemester);
sqlParameter[5] = new SqlParameter("@CATEGORY", studentEntity.stuCategory);
sqlParameter[6] = new SqlParameter("@ACADEMIC_YEAR", studentEntity.stuAcade);
sqlParameter[7] = new SqlParameter("@FATHER_NAME", studentEntity.stuFather);
sqlParameter[8] = new SqlParameter("@MOTHER_NAME", studentEntity.stuMother);
sqlParameter[9] = new SqlParameter("@GENDER", studentEntity.stuSex);
sqlParameter[10] = new SqlParameter("@DATE_OF_BIRTH", studentEntity.stuDOB);
sqlParameter[11] = new SqlParameter("@BLOOD_GROUP", studentEntity.stuBGrp);
sqlParameter[12] = new SqlParameter("@NATIONALITY", studentEntity.stuNation);
sqlParameter[13] = new SqlParameter("@M_TONGUE", studentEntity.stuMTongue);
sqlParameter[14] = new SqlParameter("@BIRTH_PLACE", studentEntity.stuBirPlace);
sqlParameter[15] = new SqlParameter("@IS_HANDICAP", studentEntity.stuHandi);
sqlParameter[16] = new SqlParameter("@PARENT_INCOME", studentEntity.stuPIncome);
sqlParameter[17] = new SqlParameter("@ADDRESS_LINE_1", studentEntity.stuAdres);
sqlParameter[18] = new SqlParameter("@ADDRESS_LINE_2", studentEntity.stuAdres2);
sqlParameter[19] = new SqlParameter("@STATE", studentEntity.stuState);
sqlParameter[20] = new SqlParameter("@CITY", studentEntity.stuCity);
sqlParameter[21] = new SqlParameter("@ZIP_CODE", studentEntity.stuZip);
sqlParameter[22] = new SqlParameter("@MOBILE", studentEntity.stuMobile);
sqlParameter[23] = new SqlParameter("@PHONE", studentEntity.stuPhone);
sqlParameter[24] = new SqlParameter("@EMAIL", studentEntity.stuEmail);
sqlParameter[25] = new SqlParameter("@SUBJECT", studentEntity.stuSub);
sqlParameter[26] = new SqlParameter("@P_INSTITUTE", studentEntity.stuInst);
sqlParameter[27] = new SqlParameter("@P_BOARD", studentEntity.stuBoard);
sqlParameter[28] = new SqlParameter("@P_COURSE", studentEntity.stuPreCourse);
sqlParameter[29] = new SqlParameter("@P_YEAR", studentEntity.couCompli);
sqlParameter[30] = new SqlParameter("@P_MARKS", studentEntity.stuMarks);
sqlParameter[31] = new SqlParameter("@P_PERCENTAGE", studentEntity.stuPercent);
sqlParameter[32] = new SqlParameter("@LOGIN_ID", studentEntity.stuLogin);
sqlParameter[33] = new SqlParameter("@PASSWORD", Encrypt(studentEntity.stuPwd));
sqlParameter[34] = new SqlParameter("@ACCOUNT_STATUS", studentEntity.stuAccStat);
sqlParameter[35] = new SqlParameter("@CUSTOMER_ID", Convert.ToInt32(objUserEntity.customerId));
sqlParameter[36] = new SqlParameter("@USER_ID", objUserEntity.userId);
sqlParameter[37] = new SqlParameter("@IMAGE", (studentEntity.stuImage));
sqlParameter[38] = new SqlParameter("@TRANSPORT", (studentEntity.stuTrans));
sqlParameter[39] = new SqlParameter("@ROUTE_NAME", (studentEntity.stuRoute));
sqlParameter[40] = new SqlParameter("@VEHICLE_TYPE", (studentEntity.stuVehTyp));
sqlParameter[41] = new SqlParameter("@VEHICLE", (studentEntity.stuVehNo));
sqlParameter[42] = new SqlParameter("@TRAN_AMT", (studentEntity.stuVecAmt));
sqlParameter[43] = new SqlParameter("@STOP_NAME", (studentEntity.stuVehStop));
sqlParameter[44] = new SqlParameter("@HOSTEL", (studentEntity.stuHostel));
sqlParameter[45] = new SqlParameter("@HOSTEL_NAME", (studentEntity.stuHostelName));
sqlParameter[46] = new SqlParameter("@FLOOR", (studentEntity.stuHostelFlr));
sqlParameter[47] = new SqlParameter("@ROOM_TYPE", (studentEntity.stuRoomTyp));
sqlParameter[48] = new SqlParameter("@ROOM_NO", (studentEntity.stuRoomNo));
sqlParameter[49] = new SqlParameter("@BED_NO", (studentEntity.stuBedNo));
sqlParameter[50] = new SqlParameter("@HOST_PRICE", (studentEntity.stuHostPrc));
sqlParameter[51] = new SqlParameter("@SECTION", (studentEntity.sectionName));
sqlParameter[52] = new SqlParameter("@FLAG", SqlDbType.Char);
sqlParameter[52].Direction = ParameterDirection.Output;
sqlParameter[52].Size = 1;
sqlParameter[53] = new SqlParameter("@MSG", SqlDbType.NVarChar);
sqlParameter[53].Direction = ParameterDirection.Output;
sqlParameter[53].Size = 500;
DataSet ds = new DataSet();
int count = SqlHelper.ExecuteNonQuery(sqlConn, CommandType.StoredProcedure, "SP_MANAGE_STUDENT", sqlParameter);
result.flag = sqlParameter[52].Value.ToString();
result.msg = sqlParameter[53].Value.ToString();
//if (result.flag.ToUpper() == "S")
//{
// if (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 CheckLogin(string email, string password)
{
ResultEntity result = new ResultEntity();
try
{
SqlParameter[] sqlParameter = new SqlParameter[5];
sqlParameter[0] = new SqlParameter("@LOGIN_ID", email);
sqlParameter[1] = new SqlParameter("@PASSWORD", Encrypt(password));
sqlParameter[2] = new SqlParameter("@USER_TYPE", SqlDbType.Char);
sqlParameter[2].Direction = ParameterDirection.Output;
sqlParameter[2].Size = 50;
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 = 200;
DataSet ds = new DataSet();
ds = SqlHelper.ExecuteDataset(sqlConn, CommandType.StoredProcedure, "SP_CHECK_LOGIN", sqlParameter);
result.flag = sqlParameter[3].Value.ToString();
result.msg = sqlParameter[4].Value.ToString();
result.userType = sqlParameter[2].Value.ToString();
UserEntity objUserEntity = UserEntity.GetInstance();
if (result.flag.ToUpper() == "S")
{
HttpContext.Current.Session["ModuelInfo"] = ds.Tables[0];
if (result.userType == "2")
{
objUserEntity.userId = ds.Tables[1].Rows[0]["USER_ID"].ToString();
objUserEntity.firstName = ds.Tables[1].Rows[0]["FIRST_NAME"].ToString();
objUserEntity.lastName = ds.Tables[1].Rows[0]["LAST_NAME"].ToString();
objUserEntity.fatherName = ds.Tables[1].Rows[0]["FATHER_NAME"].ToString();
objUserEntity.motherName = ds.Tables[1].Rows[0]["MOTHER_NAME"].ToString();
objUserEntity.gender = ds.Tables[1].Rows[0]["GENDER"].ToString();
objUserEntity.dob = ds.Tables[1].Rows[0]["DATE_OF_BIRTH"].ToString();
objUserEntity.course = ds.Tables[1].Rows[0]["COURSE"].ToString();
objUserEntity.semester = ds.Tables[1].Rows[0]["SEMESTER"].ToString();
objUserEntity.category = ds.Tables[1].Rows[0]["CATEGORY"].ToString();
objUserEntity.academicYear = ds.Tables[1].Rows[0]["ACADEMIC_YEAR"].ToString();
//objUserEntity.admissionDate = ds.Tables[1].Rows[0]["ADMISSION_DATE"].ToString();
//objUserEntity.isActive = ds.Tables[1].Rows[0]["IS_ACTIVE"].ToString();
objUserEntity.accountLocked = ds.Tables[1].Rows[0]["ACCOUNT_LOCKED"].ToString();
}
else
{
objUserEntity.userId = ds.Tables[1].Rows[0]["USER_ID"].ToString();
objUserEntity.deptId = ds.Tables[1].Rows[0]["DEPARTMENT"].ToString();
objUserEntity.desigId = ds.Tables[1].Rows[0]["DESIGNATION"].ToString();
objUserEntity.firstName = ds.Tables[1].Rows[0]["FIRST_NAME"].ToString();
//objUserEntity.middleName = ds.Tables[1].Rows[0]["MIDDLE_NAME"].ToString();
objUserEntity.lastName = ds.Tables[1].Rows[0]["LAST_NAME"].ToString();
objUserEntity.gender = ds.Tables[1].Rows[0]["GENDER"].ToString();
objUserEntity.joinDate = ds.Tables[1].Rows[0]["JOINING_DATE"].ToString();
//objUserEntity.isActive = ds.Tables[1].Rows[0]["IS_ACTIVE"].ToString();
objUserEntity.accountLocked = ds.Tables[1].Rows[0]["ACCOUNT_LOCKED"].ToString();
objUserEntity.role = ds.Tables[1].Rows[0]["ROLE"].ToString();
//role should be there//gender
}
if (ds.Tables[2].Rows.Count == 1)
{
objUserEntity.customerId = ds.Tables[2].Rows[0]["CUSTOMER_ID"].ToString();
objUserEntity.customerName = ds.Tables[2].Rows[0]["CUSTOMER_NAME"].ToString();
objUserEntity.address = ds.Tables[2].Rows[0]["ADDRESS"].ToString();
objUserEntity.city = ds.Tables[2].Rows[0]["CITY"].ToString();
objUserEntity.mobile = ds.Tables[2].Rows[0]["MOBILE"].ToString();
objUserEntity.website = ds.Tables[2].Rows[0]["WEBSITE"].ToString();
objUserEntity.faxNo = ds.Tables[2].Rows[0]["FAX_NO"].ToString();
objUserEntity.cEmail = ds.Tables[2].Rows[0]["EMAIL_ADDRESS"].ToString();
objUserEntity.panNo = ds.Tables[2].Rows[0]["PAN_NO"].ToString();
objUserEntity.cActive = ds.Tables[2].Rows[0]["IS_ACTIVE"].ToString();
objUserEntity.state = ds.Tables[2].Rows[0]["STATE"].ToString();
objUserEntity.pinCode = ds.Tables[2].Rows[0]["PIN_CODE"].ToString();
}
else
{
result.addParams = CommonFunc.DtToJSON(ds.Tables[2]);
}
HttpContext.Current.Session["UserDetails"] = objUserEntity;
}
return(result);
}
catch (Exception ex)
{
Excep.WriteException(ex);
return(result);
}
}