public Int32 InsertStudentMaster(StudentMasterInfo objStudent)
{
SqlConnection mCon = new SqlConnection(ConnectionString);
SqlCommand mCmd = new SqlCommand();
mCmd.CommandText = "StudentMasterInsert";
mCmd.CommandType = CommandType.StoredProcedure;
mCmd.Parameters.AddWithValue("@StudentId", objStudent.StudentId);
mCmd.Parameters.AddWithValue("@NatureOfEntry", objStudent.NatureOfEntry);
mCmd.Parameters.AddWithValue("@RegistrationNo", objStudent.RegistrationNo);
mCmd.Parameters.AddWithValue("@Name", objStudent.Name);
mCmd.Parameters.AddWithValue("@FatherName", objStudent.FatherName);
mCmd.Parameters.AddWithValue("@MotherName", objStudent.MotherName);
mCmd.Parameters.AddWithValue("@DateOfBirth", objStudent.DateOfBirth);
mCmd.Parameters.AddWithValue("@Gender", objStudent.Gender);
mCmd.Parameters.AddWithValue("@Category", objStudent.Category);
mCmd.Parameters.AddWithValue("@PhysicallyChallenged", objStudent.PhysicallyChallenged);
mCmd.Parameters.AddWithValue("@TypeOfChallenge", objStudent.TypeOfChallange);
mCmd.Parameters.AddWithValue("@FamilyIncome", objStudent.FamilyIncome);
mCmd.Parameters.AddWithValue("@Medium", objStudent.Medium);
mCmd.Parameters.AddWithValue("@MILSubjectCode", objStudent.MILSubjectCode);
mCmd.Parameters.AddWithValue("@MILGroup", objStudent.MILGroup);
mCmd.Parameters.AddWithValue("@LIEUSubjectCode", objStudent.LIEUSubjectCode);
mCmd.Parameters.AddWithValue("@ElectiveSubjectCode", objStudent.ElectiveSubjectCode);
mCmd.Parameters.AddWithValue("@Remarks", objStudent.Remarks);
mCmd.Parameters.AddWithValue("@CreatedBy", objStudent.CreatedBy);
mCmd.Parameters.Add("@ReturnValue", SqlDbType.Int).Direction = ParameterDirection.ReturnValue;
int ReturnVal = 0;
mCmd.Connection = mCon;
try
{
mCon.Open();
mCmd.Connection = mCon;
mCmd.ExecuteNonQuery();
ReturnVal = Convert.ToInt32(mCmd.Parameters["@ReturnValue"].Value.ToString());
}
catch (Exception ex)
{
log.Error(ex.ToString());
}
finally
{
mCmd = null;
mCon.Close();
}
return(ReturnVal);
}
public async Task <IActionResult> UpdateStudentMaster([FromBody] StudentMasterInfo StudentMasterModel)
{
try
{
StudentMasterModel.ModifiedBy = "Admin";
StudentMasterModel.ModifiedDate = DateTime.Now;
db.Entry(StudentMasterModel).State = Microsoft.EntityFrameworkCore.EntityState.Modified;
db.SaveChanges();
return(Ok(StudentMasterModel));
}
catch (Exception ex)
{
return(BadRequest());
}
}
public async Task <IActionResult> CreateStudentMaster([FromBody] StudentMasterInfo StudentMasterModel)
{
try
{
//bannerMaster.EnquiryID = 0;
StudentMasterModel.CreatedBy = "Admin";
StudentMasterModel.CreatedDate = DateTime.Now;
StudentMasterModel.ModifiedBy = "Admin";
StudentMasterModel.ModifiedDate = DateTime.Now;
StudentMasterModel.Active = true;
db.studentMasterInfo.Add(StudentMasterModel);
db.SaveChanges();
return(Ok(StudentMasterModel));
}
catch (Exception ex)
{
return(BadRequest());
}
}
public Int32 UpdateStudentMaster(StudentMasterInfo objStudent)
{
SqlConnection mCon = new SqlConnection(ConnectionString);
SqlCommand mCmd = new SqlCommand();
mCmd.CommandText = "StudentMasterUpdate";
mCmd.CommandType = CommandType.StoredProcedure;
mCmd.Parameters.AddWithValue("@StudID", objStudent.StudentId);
mCmd.Parameters.AddWithValue("@CorrType", objStudent.NatureOfEntry);
mCmd.Parameters.AddWithValue("@REGNo", objStudent.RegistrationNo);
mCmd.Parameters.AddWithValue("@Candidate_Name", objStudent.Name);
mCmd.Parameters.AddWithValue("@Father_Name", objStudent.FatherName);
mCmd.Parameters.AddWithValue("@Mother_Name", objStudent.MotherName);
mCmd.Parameters.AddWithValue("@DOB", objStudent.DateOfBirth);
mCmd.Parameters.AddWithValue("@Gender", objStudent.Gender);
mCmd.Parameters.AddWithValue("@Category", objStudent.Category);
mCmd.Parameters.AddWithValue("@PH", objStudent.PhysicallyChallenged);
mCmd.Parameters.AddWithValue("@PH_Type", objStudent.TypeOfChallange);
mCmd.Parameters.AddWithValue("@Family_Income_Upto_Rs1Lac", objStudent.FamilyIncome);
mCmd.Parameters.AddWithValue("@Medium", objStudent.Medium);
mCmd.Parameters.AddWithValue("@MIL_Code", objStudent.MILSubjectCode);
mCmd.Parameters.AddWithValue("@MIL_Sub", objStudent.MIL_Subject);
mCmd.Parameters.AddWithValue("@MIL_Group", objStudent.MILGroup);
mCmd.Parameters.AddWithValue("@LIEU_Code", objStudent.LIEUSubjectCode);
mCmd.Parameters.AddWithValue("@LIEU_Sub", objStudent.LIEUSubject);
mCmd.Parameters.AddWithValue("@ELEC_Code", objStudent.ElectiveSubjectCode);
mCmd.Parameters.AddWithValue("@ELEC_Sub", objStudent.ElectiveSubject);
mCmd.Parameters.AddWithValue("@Remarks", objStudent.Remarks);
if (objStudent.NatureOfEntry == "A")
{
mCmd.Parameters.AddWithValue("@ModifiedBy", objStudent.CreatedBy);
}
else
{
mCmd.Parameters.AddWithValue("@ModifiedBy", objStudent.ModifiedBy);
}
mCmd.Parameters.Add("@ReturnValue", SqlDbType.Int).Direction = ParameterDirection.ReturnValue;
int ReturnVal = 0;
mCmd.Connection = mCon;
try
{
mCon.Open();
mCmd.Connection = mCon;
mCmd.ExecuteNonQuery();
ReturnVal = Convert.ToInt32(mCmd.Parameters["@ReturnValue"].Value.ToString());
}
catch (Exception ex)
{
log.Error(ex.ToString());
}
finally
{
mCmd = null;
mCon.Close();
}
return(ReturnVal);
}
