public SchoolRegistrationModel GetSchoolRegistration(int id)
{
IPTSEDBEntities entity = new IPTSEDBEntities();
var resultModel = entity.IPTSE_School_Reg_table.Where(a => a.Id.Equals(id)).FirstOrDefault();
SchoolRegistrationModel registrationModel = new SchoolRegistrationModel();
if (resultModel != null)
{
registrationModel.addr1 = resultModel.addr1;
registrationModel.addr2 = resultModel.addr2;
registrationModel.branch_name = resultModel.branch_name;
registrationModel.city = resultModel.city;
registrationModel.contact_person_contact = resultModel.contact_person_contact;
registrationModel.contact_person_email = resultModel.contact_person_email;
registrationModel.contact_person_name = resultModel.contact_person_name;
registrationModel.country = resultModel.country;
registrationModel.Created_Date = resultModel.Created_Date;
registrationModel.Id = resultModel.Id;
registrationModel.information_source = resultModel.information_source;
registrationModel.institution_contact = resultModel.institution_contact;
registrationModel.institution_email = resultModel.institution_email;
registrationModel.institution_name = resultModel.institution_name;
registrationModel.principal_director_name = resultModel.principal_director_name;
registrationModel.state = resultModel.state;
registrationModel.zipcode = resultModel.zipcode;
}
return(registrationModel);
}
public ActionResult SchoolRegistration(SchoolRegistrationModel schoolModel)
{
if (ModelState.IsValid)
{
try
{
using (var client = new HttpClient())
{
client.BaseAddress = new Uri("http://portal.iptse.com/"); //localhost:63138/
//client.BaseAddress = new Uri("http://localhost:63138/");
var postTask = client.PostAsJsonAsync <SchoolRegistrationModel>("api/SchoolRegistrationAPI", schoolModel);
postTask.Wait();
var result = postTask.Result;
if (result.IsSuccessStatusCode)
{
ViewData["success_msg"] = "Congratulation! you have Registered Successfully.";
return(View("Successfull"));
}
else
{
ViewBag.ErrorMessage = "Registration failed. Please contact IPTSE help line.";
}
}
}
catch (Exception ex1)
{
ViewBag.ErrorMessage = "Already Registered with this Email.";
return(View());
}
}
return(View(schoolModel));
}
// POST: api/Exporter
public HttpResponseMessage Post(SchoolRegistrationModel schoolModel)
{
try
{
SchoolRegistrationBLL _objSchoolRegistration = new SchoolRegistrationBLL();
var insertedRecord = _objSchoolRegistration.InsertSchool(schoolModel);
if (insertedRecord == null || insertedRecord == 0)
{
return(Request.CreateErrorResponse(HttpStatusCode.NotFound, "School Not Created!"));
}
else
{
return(Request.CreateResponse(HttpStatusCode.OK, insertedRecord));
}
}
catch (SecurityException ex)
{
return(Request.CreateErrorResponse(HttpStatusCode.Unauthorized, ex.InnerException));
}
catch (Exception ex)
{
HttpRequestMessage Request = new HttpRequestMessage();
//new EventLogManager().LogException(ex);
return(Request.CreateErrorResponse(HttpStatusCode.InternalServerError, ex.Message));
}
}
public decimal InsertSchool(SchoolRegistrationModel schoolRegistrationModel)
{
IPTSE_School_Reg_table _schoolRegistration = new IPTSE_School_Reg_table();
login_table _objLoginTable = new login_table();
decimal newIdentityValue = -1;
using (var objContext = new IPTSEDBEntities())
{
using (var dbcxtransaction = objContext.Database.BeginTransaction())
{
try
{
_schoolRegistration.institution_name = schoolRegistrationModel.institution_name;
_schoolRegistration.principal_director_name = schoolRegistrationModel.principal_director_name;
_schoolRegistration.branch_name = schoolRegistrationModel.branch_name;
_schoolRegistration.institution_type = schoolRegistrationModel.institution_type;
_schoolRegistration.addr1 = schoolRegistrationModel.addr1;
_schoolRegistration.addr2 = schoolRegistrationModel.addr2;
_schoolRegistration.city = schoolRegistrationModel.city;
_schoolRegistration.state = schoolRegistrationModel.state;
_schoolRegistration.state = schoolRegistrationModel.state;
_schoolRegistration.zipcode = schoolRegistrationModel.zipcode;
_schoolRegistration.country = schoolRegistrationModel.country;
_schoolRegistration.institution_contact = schoolRegistrationModel.institution_contact;
_schoolRegistration.institution_email = schoolRegistrationModel.institution_email;
_schoolRegistration.contact_person_name = schoolRegistrationModel.contact_person_name;
_schoolRegistration.contact_person_contact = schoolRegistrationModel.contact_person_contact;
_schoolRegistration.contact_person_email = schoolRegistrationModel.contact_person_email;
_schoolRegistration.information_source = schoolRegistrationModel.information_source;
_schoolRegistration.Created_Date = DateTime.Now;
//_schoolRegistration.Updated_Date = DateTime.Now;
objContext.IPTSE_School_Reg_table.Add(_schoolRegistration);
objContext.SaveChanges();
newIdentityValue = objContext.IPTSE_School_Reg_table.DefaultIfEmpty().Max(r => r == null ? 0 : r.Id);
_objLoginTable.Id = newIdentityValue;
byte[] encode = new byte[schoolRegistrationModel.password.Length];
encode = System.Text.Encoding.UTF8.GetBytes(schoolRegistrationModel.password);
_objLoginTable.password = Convert.ToBase64String(encode);
_objLoginTable.email = schoolRegistrationModel.institution_email;
_objLoginTable.Login_type = "Institution";
objContext.login_table.Add(_objLoginTable);
objContext.SaveChanges();
dbcxtransaction.Commit();
return(newIdentityValue);
}
catch (Exception ex)
{
dbcxtransaction.Rollback();
throw ex;
}
}
}
}
// PUT: api/Exporter/5
public HttpResponseMessage Put(SchoolRegistrationModel schoolModel)
{
try
{
return(Request.CreateErrorResponse(HttpStatusCode.NotFound, "Not Found!"));
}
catch (SecurityException ex)
{
return(Request.CreateErrorResponse(HttpStatusCode.Unauthorized, ex.InnerException));
}
catch (Exception ex)
{
HttpRequestMessage Request = new HttpRequestMessage();
//new EventLogManager().LogException(ex);
return(Request.CreateErrorResponse(HttpStatusCode.InternalServerError, ex.Message));
}
}
// GET: api/SchoolRegistrationAPI/1
public HttpResponseMessage Get(string searchText)
{
try
{
try
{
SchoolRegistrationBLL _objSchoolRegistration = new SchoolRegistrationBLL();
SchoolRegistrationModel record = _objSchoolRegistration.GetSchoolRegistration(Convert.ToInt32(searchText));
if (record == null)
{
return(Request.CreateErrorResponse(HttpStatusCode.NotFound, "School Not found!"));
}
else
{
return(Request.CreateResponse(HttpStatusCode.OK, record));
}
}
catch (SecurityException ex)
{
return(Request.CreateErrorResponse(HttpStatusCode.Unauthorized, ex.InnerException));
}
catch (Exception ex)
{
HttpRequestMessage Request = new HttpRequestMessage();
//new EventLogManager().LogException(ex);
return(Request.CreateErrorResponse(HttpStatusCode.InternalServerError, ex.Message));
}
}
catch (SecurityException ex)
{
return(Request.CreateErrorResponse(HttpStatusCode.Unauthorized, ex.InnerException));
}
catch (Exception ex)
{
HttpRequestMessage Request = new HttpRequestMessage();
//new EventLogManager().LogException(ex);
return(Request.CreateErrorResponse(HttpStatusCode.InternalServerError, ex.InnerException));
}
}
public List <SchoolRegistrationModel> GetSchoolRegistrations()
{
IPTSEDBEntities entity = new IPTSEDBEntities();
var resultModels = entity.IPTSE_School_Reg_table.Where(s => s.IsActive == true || s.IsActive == null);
List <SchoolRegistrationModel> registrationModels = new List <SchoolRegistrationModel>();
foreach (var resultModel in resultModels)
{
SchoolRegistrationModel registrationModel = new SchoolRegistrationModel();
if (resultModel != null)
{
registrationModel.addr1 = resultModel.addr1;
registrationModel.addr2 = resultModel.addr2;
registrationModel.branch_name = resultModel.branch_name;
registrationModel.city = resultModel.city;
registrationModel.contact_person_contact = resultModel.contact_person_contact;
registrationModel.contact_person_email = resultModel.contact_person_email;
registrationModel.contact_person_name = resultModel.contact_person_name;
registrationModel.country = resultModel.country;
registrationModel.Created_Date = resultModel.Created_Date;
registrationModel.Id = resultModel.Id;
registrationModel.information_source = resultModel.information_source;
registrationModel.institution_contact = resultModel.institution_contact;
registrationModel.institution_email = resultModel.institution_email;
registrationModel.institution_name = resultModel.institution_name;
registrationModel.principal_director_name = resultModel.principal_director_name;
registrationModel.state = resultModel.state;
registrationModel.zipcode = resultModel.zipcode;
registrationModels.Add(registrationModel);
}
}
return(registrationModels);
}