public IHttpActionResult PostProfile([FromBody] IESAcademicProfile profile)
{
try
{
var context = new xPenEntities();
using (var dbContextTransaction = context.Database.BeginTransaction())
{
var ac = (from ap in context.IESAcademicProfiles
where ap.UserID == profile.UserID
select ap).ToList();
if (ac.Count > 0)
{
context.IESAcademicProfiles.RemoveRange(ac);
context.SaveChanges();
}
context.IESAcademicProfiles.Add(profile);
context.SaveChanges();
dbContextTransaction.Commit();
}
CustomResponse cr = new CustomResponse();
cr.Response = "Ok";
return(Ok(cr));
}
catch (Exception Ex)
{
CustomResponse cr = new CustomResponse();
cr.Response = "Fail";
return(InternalServerError());
}
}
public IHttpActionResult PostQuestion([FromBody] IESQuestion question, int PaperID)
{
try
{
var context = new xPenEntities();
using (var dbContextTransaction = context.Database.BeginTransaction())
{
if (question.QuestionID <= 0)
{
context.IESQuestions.Add(question);
context.SaveChanges();
}
context.IESPaper_Question.Add(new IESPaper_Question {
PaperID = PaperID,
QuesID = question.QuestionID
});
context.SaveChanges();
dbContextTransaction.Commit();
}
return(Ok());
}
catch (Exception ex)
{
return(InternalServerError());
}
}
public IHttpActionResult UpdateCollegeStream([FromBody] IESCourse[] courses)
{
try
{
var context = new xPenEntities();
using (var dbContextTransaction = context.Database.BeginTransaction())
{
int collID = (int)courses.First().CollegeID;
var c = (from a in context.IESCourses
where a.CollegeID == collID
select a).ToList();
context.IESCourses.RemoveRange(c);
context.SaveChanges();
context.IESCourses.AddRange(courses);
context.SaveChanges();
dbContextTransaction.Commit();
}
return(Ok());
}
catch (Exception ex)
{
return(InternalServerError());
}
}
public IHttpActionResult GetChecksum([FromBody] IESOrder value)
{
CustomResponse err = new CustomResponse();
try
{
var context = new xPenEntities();
using (var dbContextTransaction = context.Database.BeginTransaction())
{
var prev = (from p in context.IESOrders
where p.PaperID == value.PaperID && p.UserID == value.UserID
select p).ToList();
if (prev.Count > 0)
{
context.IESOrders.RemoveRange(prev);
context.SaveChanges();
}
context.IESOrders.Add(value);
context.SaveChanges();
if (value.OrderID > 1)
{
checkSum cs = new checkSum();
String csm = CreateChecksum(value.OrderID, value.UserID, value.Paid);
string JSONresult = JsonConvert.SerializeObject(cs);
dbContextTransaction.Commit();
Transaction newTransaction = new Transaction();
newTransaction.UserID = value.UserID;
newTransaction.PaperID = value.PaperID;
newTransaction.Paid = value.Paid;
newTransaction.OrderID = value.OrderID;
newTransaction.CheckSum = csm;
return(Ok(newTransaction));
}
else
{
err.Response = "Error Saving Order";
dbContextTransaction.Rollback();
//return BadRequest(cs);
return(Content(HttpStatusCode.BadRequest, err));
}
}
}
catch (Exception ex)
{
return(InternalServerError());
}
}
public IHttpActionResult PostOrder([FromBody] IESOrder value)
{
List <IESOrder> list = new List <IESOrder>();
var context = new xPenEntities();
var prev = (from s in context.IESOrders
where s.PaperID == value.PaperID && s.UserID == value.UserID
select s).ToList();
if (prev.Count > 0)
{
return(InternalServerError());
}
else
{
context.IESOrders.Add(value);
context.SaveChanges();
return(Ok());
}
//try
//{
// var context = new xPenEntities();
// context.IESOrders.Add(value);
// context.SaveChanges();
// return Ok();
//}
//catch (Exception ex)
//{
// return InternalServerError(ex.InnerException);
//}
}
public IHttpActionResult PostNewTest([FromBody] IESQuestionPaper value)
{
CustomResponse cr = new CustomResponse();
try
{
var context = new xPenEntities();
var old = (from q in context.IESQuestionPapers
where q.UniversityID == value.UniversityID && q.SubjectID == value.SubjectID && q.Year == value.Year
select q).ToList();
if (old.Count > 0)
{
cr.Response = "Paper Already Exist";
return(BadRequest(cr.Response));
}
else
{
cr.Response = "Updated";
context.IESQuestionPapers.Add(value);
context.SaveChanges();
return(Ok(cr));
}
}
catch (Exception ex)
{
return(InternalServerError(ex.InnerException));
}
}
public IHttpActionResult AddNewCollegeWithStream([FromBody] College_Courses college_course)
{
try
{
var context = new xPenEntities();
using (var dbContextTransaction = context.Database.BeginTransaction())
{
IESCollege college = new IESCollege
{
CollegeName = college_course.CollegeName,
UniversityID = college_course.UnivID
};
context.IESColleges.Add(college);
context.SaveChanges();
List <IESStream> courses = college_course.Streams;
foreach (IESStream i in courses)
{
context.IESCourses.Add(
new IESCourse
{
CollegeID = college.CollegeID,
StreamID = i.StreamID
}
);
}
context.SaveChanges();
dbContextTransaction.Commit();
}
return(Ok());
}
catch (Exception ex)
{
return(InternalServerError());
}
}
public IHttpActionResult AddNewCollege([FromBody] IESCollege college)
{
try
{
var context = new xPenEntities();
context.IESColleges.Add(college);
context.SaveChanges();
return(Ok());
}
catch (Exception ex)
{
return(InternalServerError());
}
}
// POST: api/Stream
public IHttpActionResult AddNewUniversity([FromBody] IESStream newstream)
{
try
{
var context = new xPenEntities();
context.IESStreams.Add(newstream);
context.SaveChanges();
return(Ok());
}
catch (Exception ex)
{
return(InternalServerError());
}
}
// POST: api/Subject
public IHttpActionResult AddNewSubject([FromBody] IESSubject subject)
{
try
{
var context = new xPenEntities();
context.IESSubjects.Add(subject);
context.SaveChanges();
return(Ok());
}
catch (Exception ex)
{
return(InternalServerError());
}
}
public IHttpActionResult Get([FromBody] IESUniversity university)
{
try
{
var context = new xPenEntities();
context.IESUniversities.Add(university);
context.SaveChanges();
return(Ok());
}
catch (Exception ex)
{
return(InternalServerError());
}
// return "value";
}
public IHttpActionResult GetProfile(int UserID)
{
try
{
var context = new xPenEntities();
var profile = (from p in context.ViewIESAcademicProfiles
where p.UserID == UserID
select p).First();
context.SaveChanges();
return(Ok(profile));
}
catch (Exception Ex)
{
return(InternalServerError());
}
}
public IHttpActionResult UpdateCollegeStream([FromBody] iescourses courses)
{
var context = new xPenEntities();
IESCourse[] array = courses.courses;
using (var dbContextTransaction = context.Database.BeginTransaction())
{
var oldCourses = (from c in context.IESCourses
where c.CollegeID == array[0].CollegeID
select c).ToList();
context.IESCourses.RemoveRange(oldCourses);
context.SaveChanges();
context.IESCourses.AddRange(array);
dbContextTransaction.Commit();
}
return(Ok());
}
public IHttpActionResult Post([FromBody] IESUserProfile profile)
{
try
{
var context = new xPenEntities();
var user = (from u in context.IESUserProfiles
where u.Email == profile.Email || u.MobileNumber == profile.MobileNumber
select u).ToList();
if (user.Count > 0)
{
return(BadRequest("User Already Exist"));
}
else
{
context.IESUserProfiles.Add(profile);
context.SaveChanges();
return(Ok(profile));
}
}
catch (Exception Ex)
{
return(InternalServerError());
}
}
public IHttpActionResult VerifyCheckSum([FromBody] Transaction trans)
{
CustomResponse res = new CustomResponse();
try
{
Dictionary <String, String> paytmParams = new Dictionary <String, String>();
String merchantMid = "JoyYHn78452054983473";
// Key in your staging and production MID available in your dashboard
String merchantKey = "DQW9YSzGhXyW5&hV";
// Key in your staging and production MID available in your dashboard
String orderId = trans.OrderID.ToString();
String channelId = "WAP";
String custId = trans.UserID.ToString();
String mobileNo = "9591033223";
String email = "*****@*****.**";
String txnAmount = trans.Paid.ToString();
String website = "WEBSTAGING";
// This is the staging value. Production value is available in your dashboard
String industryTypeId = "Retail";
// This is the staging value. Production value is available in your dashboard
String callbackUrl = "https://securegw-stage.paytm.in/theia/paytmCallback?ORDER_ID=" + orderId;
paytmParams.Add("MID", merchantMid);
paytmParams.Add("CHANNEL_ID", channelId);
paytmParams.Add("WEBSITE", website);
paytmParams.Add("CALLBACK_URL", callbackUrl);
paytmParams.Add("CUST_ID", custId);
paytmParams.Add("MOBILE_NO", mobileNo);
paytmParams.Add("EMAIL", email);
paytmParams.Add("ORDER_ID", orderId);
paytmParams.Add("INDUSTRY_TYPE_ID", industryTypeId);
paytmParams.Add("TXN_AMOUNT", txnAmount);
paytmParams.Add("CHECKSUMHASH", trans.CheckSum);
bool result = VerifyChecksum(paytmParams);
if (result)
{
res.Response = "Ok";
int order_id = Convert.ToInt32(orderId);
var context = new xPenEntities();
var order = (from o in context.IESOrders
where o.OrderID == order_id
select o).First();
order.PurchaseDate = DateTime.UtcNow;
order.ClosureDate = DateTime.UtcNow.AddYears(1);
context.SaveChanges();
}
else
{
res.Response = "Fail";
}
return(Ok(res));
}
catch (Exception ex)
{
res.Response = "Server Error";
return(Ok(res));
}
}
