public IHttpActionResult UpdateAdmission(MSEADEW_BAL.BAL.Admissions.BAdmission en)
{
try
{
var result = new Dictionary <string, object>();
int newAdmissionId;
_admission = new MSEADEW_BAL.BAL.Admissions.BAdmission();
if (en != null)
{
newAdmissionId = _admission.UpdateAdmission(en);
result.Add("Success", true);
result.Add("AdmissionId", newAdmissionId.ToString());
}
else
{
result.Add("Success", false);
}
return(Ok(result));
}
catch (Exception e)
{
return(InternalServerError(e));
}
}
public int UpdateAdmission(BAdmission adm)
{
try
{
int newAdmissionId = 0;
_dataSet = new DataSet();
newAdmissionId = new Admission().UpdateAdmission(adm);
return(newAdmissionId);
}
catch (SqlException ex)
{
throw ex;
}
}
public int UpdateAdmission(MSEADEW_BAL.BAL.Admissions.BAdmission adm)
{
try
{
int newAdmissionId = 0;
_storedProcedure = "UpdateAdmission";
_parameters = new SqlParameter[38];
_parameters[0] = new SqlParameter("@AdmissionId", SqlDbType.Int);
_parameters[0].Value = adm.id;
_parameters[1] = new SqlParameter("@ApplicationNo", SqlDbType.Int);
_parameters[1].Value = Convert.ToInt32(adm.applicationNo);
_parameters[2] = new SqlParameter("@FirstName", SqlDbType.VarChar);
_parameters[2].Value = adm.firstName;
_parameters[3] = new SqlParameter("@LastName", SqlDbType.VarChar);
_parameters[3].Value = adm.lastName;
_parameters[4] = new SqlParameter("@EducationLevelId", SqlDbType.Int);
_parameters[4].Value = Convert.ToInt32(adm.educationLevelId);
_parameters[5] = new SqlParameter("@CourseId", SqlDbType.Int);
_parameters[5].Value = Convert.ToInt32(adm.courseId);
_parameters[6] = new SqlParameter("@QualifyingExamId", SqlDbType.Int);
_parameters[6].Value = Convert.ToInt32(adm.qualifyingExamId);
_parameters[7] = new SqlParameter("@OtherQualifyingExamName", SqlDbType.VarChar);
_parameters[7].Value = adm.otherQualifyingExamName;
_parameters[8] = new SqlParameter("@HTRollNo", SqlDbType.VarChar);
_parameters[8].Value = adm.htRollNo;
_parameters[9] = new SqlParameter("@Gender", SqlDbType.Bit);
_parameters[9].Value = Convert.ToBoolean(adm.gender);
_parameters[10] = new SqlParameter("@DOB", SqlDbType.DateTime);
_parameters[10].Value = Convert.ToDateTime(adm.dob);
_parameters[11] = new SqlParameter("@CategoryId", SqlDbType.Int);
_parameters[11].Value = adm.categoryId;
_parameters[12] = new SqlParameter("@GuardianId", SqlDbType.Int);
_parameters[12].Value = Convert.ToInt32(adm.guardianId);
_parameters[13] = new SqlParameter("@AdhaarNo", SqlDbType.VarChar);
_parameters[13].Value = adm.adhaarNo;
_parameters[14] = new SqlParameter("@AcademicYear", SqlDbType.Int);
_parameters[14].Value = Convert.ToInt32(adm.academicYear);
_parameters[15] = new SqlParameter("@TCEnclosed", SqlDbType.Bit);
_parameters[15].Value = Convert.ToBoolean(adm.tCEnclosed);
_parameters[16] = new SqlParameter("@StatusId", SqlDbType.Int);
_parameters[16].Value = Convert.ToInt32(adm.statusId);
_parameters[17] = new SqlParameter("@Remarks", SqlDbType.VarChar);
_parameters[17].Value = adm.remarks;
_parameters[18] = new SqlParameter("@AssignedTo", SqlDbType.Int);
_parameters[18].Value = Convert.ToInt32(adm.assignedTo);
_parameters[19] = new SqlParameter("@BranchId", SqlDbType.Int);
_parameters[19].Value = Convert.ToInt32(adm.branchId);
_parameters[20] = new SqlParameter("@ModifiedBy", SqlDbType.Int);
_parameters[20].Value = Convert.ToInt32(adm.modifiedBy);
_parameters[21] = new SqlParameter("@Discount", SqlDbType.Decimal);
_parameters[21].Value = adm.Discount;
_parameters[22] = new SqlParameter("@Discount_Reason", SqlDbType.VarChar);
_parameters[22].Value = adm.Discount_Reason;
_parameters[23] = new SqlParameter("@Term1", SqlDbType.Decimal);
_parameters[23].Value = adm.Term1;
_parameters[24] = new SqlParameter("@Term2", SqlDbType.Decimal);
_parameters[24].Value = adm.Term2;
_parameters[25] = new SqlParameter("@Term3", SqlDbType.Decimal);
_parameters[25].Value = adm.Term3;
_parameters[26] = new SqlParameter("@Term4", SqlDbType.Decimal);
_parameters[26].Value = adm.Term4;
_parameters[27] = new SqlParameter("@Term1Date", SqlDbType.DateTime);
_parameters[27].Value = adm.Term1Date;
_parameters[28] = new SqlParameter("@Term2Date", SqlDbType.DateTime);
_parameters[28].Value = adm.Term2Date;
_parameters[29] = new SqlParameter("@Term3Date", SqlDbType.DateTime);
_parameters[29].Value = adm.Term3Date;
_parameters[30] = new SqlParameter("@Term4Date", SqlDbType.DateTime);
_parameters[30].Value = adm.Term4Date;
_parameters[31] = new SqlParameter("@TotalFee_Payable", SqlDbType.Decimal);
_parameters[31].Value = adm.TotalFeePayable;
_parameters[32] = new SqlParameter("@ACCategory", SqlDbType.Bit);
_parameters[32].Value = adm.ACCategory;
_parameters[33] = new SqlParameter("@ReceiptNo1", SqlDbType.VarChar);
_parameters[33].Value = adm.ReceiptNo1;
_parameters[34] = new SqlParameter("@ReceiptNo2", SqlDbType.VarChar);
_parameters[34].Value = adm.ReceiptNo2;
_parameters[35] = new SqlParameter("@ReceiptNo3", SqlDbType.VarChar);
_parameters[35].Value = adm.ReceiptNo3;
_parameters[36] = new SqlParameter("@ReceiptNo4", SqlDbType.VarChar);
_parameters[36].Value = adm.ReceiptNo4;
_parameters[37] = new SqlParameter("@StudentFeeStructureId", SqlDbType.Int);
_parameters[37].Value = adm.StudentFeeStructureId;
dsResponse = RunProcedure(_storedProcedure, _parameters, true);
if (dsResponse == null || dsResponse.Tables.Count == 0)
{
throw new System.ArgumentException("No Admission Added/Updated.");
}
else
{
if (dsResponse.Tables[0].Rows.Count > 0)
{
newAdmissionId = Convert.ToInt32(dsResponse.Tables[0].Rows[0]["AdmissionId"]);
}
}
return(newAdmissionId);
}
catch (SqlException ex)
{
throw ex;
}
}