public bool InsertUpdateSchoolRecords(bool insertUpdate, StripeEntities context, SP_SCHOOL_DETAILS_FROM_DIRECTOR_Result schoolDetails)
{
try
{
if (insertUpdate)
{
context.SP_SCHOOL_DETAILS_INSERT(schoolDetails.sch_Name,
schoolDetails.sch_Street,
schoolDetails.sch_City,
schoolDetails.sch_State,
schoolDetails.sch_Zip,
schoolDetails.sch_Logo,
schoolDetails.User_Profile_Director_Profile_ID);
}
else
{
//update queries
context.SP_SCHOOL_DETAILS_UPDATE(schoolDetails.sch_Name,
schoolDetails.sch_Street,
schoolDetails.sch_City,
schoolDetails.sch_State,
schoolDetails.sch_Zip,
schoolDetails.sch_Logo,
schoolDetails.User_Profile_Director_Profile_ID);
}
context.SaveChanges();
return true;
}
catch (Exception exception)
{
Console.Write(exception.Message);
return false;
}
}
public ActionResult SchoolDetails(SP_SCHOOL_DETAILS_FROM_DIRECTOR_Result schoolDetails)
{
using (var context = new StripeEntities())
{
SchoolClass schoolClass = new SchoolClass(context);
var schoolRecord = schoolClass.getSchoolDetailsFromDirector(schoolDetails.User_Profile_Director_Profile_ID);
if (schoolRecord == null)
{
schoolClass.InsertUpdateSchoolRecords(true, context, schoolDetails);
}
else
{
schoolClass.InsertUpdateSchoolRecords(false, context, schoolDetails);
}
return RedirectToAction("SchoolDetails");
}
}
public bool InsertUpdateSchoolRecords(bool insertUpdate, StripeEntities context, SP_SCHOOL_DETAILS_FROM_DIRECTOR_Result schoolDetails)
{
try
{
if (insertUpdate)
{
context.SP_SCHOOL_DETAILS_INSERT(schoolDetails.sch_Name,
schoolDetails.sch_Street,
schoolDetails.sch_City,
schoolDetails.sch_State,
schoolDetails.sch_Zip,
schoolDetails.sch_Logo,
schoolDetails.User_Profile_Director_Profile_ID);
}
else
{
//update queries
context.SP_SCHOOL_DETAILS_UPDATE(schoolDetails.sch_Name,
schoolDetails.sch_Street,
schoolDetails.sch_City,
schoolDetails.sch_State,
schoolDetails.sch_Zip,
schoolDetails.sch_Logo,
schoolDetails.User_Profile_Director_Profile_ID);
}
context.SaveChanges();
return(true);
}
catch (Exception exception)
{
Console.Write(exception.Message);
return(false);
}
}
