// PUT api/<controller>/5
public HttpResponseMessage Put_PaymentDetails(int id, PaymentDetail PaymentDetails)
{
try
{
if (id != PaymentDetails.PMId)
{
return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ""));
}
using (OVODEntities entities = new OVODEntities())
{
var entity = entities.PaymentDetails.FirstOrDefault(e => e.PMId == PaymentDetails.PMId);
if (entity == null)
{
return(Request.CreateErrorResponse(HttpStatusCode.NotFound, "Paymentdetails id: " + PaymentDetails.PMId.ToString() + " not found to update."));
}
else
{
entity.CardOwnerName = PaymentDetails.CardOwnerName;
entity.CardNumber = PaymentDetails.CardNumber;
entity.ExpirationDate = PaymentDetails.ExpirationDate;
entity.CVV = PaymentDetails.CVV;
entities.SaveChanges();
return(Request.CreateResponse(HttpStatusCode.OK, entity));
}
}
}
catch (Exception ex)
{
return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ex));
}
}
public HttpResponseMessage GetANG_EMPLOYEEs(string gender = "All")
{
using (OVODEntities entities = new OVODEntities())
{
switch (gender.ToLower())
{
case "all":
return(Request.CreateResponse(HttpStatusCode.OK, entities.ANG_EMPLOYEE.ToList()));
case "male":
return(Request.CreateResponse(HttpStatusCode.OK,
entities.ANG_EMPLOYEE.Where(e => e.gender.ToLower() == "male").ToList()));
case "female":
return(Request.CreateResponse(HttpStatusCode.OK,
entities.ANG_EMPLOYEE.Where(e => e.gender.ToLower() == "female").ToList()));
default:
return(Request.CreateResponse(HttpStatusCode.OK,
entities.ANG_EMPLOYEE.Where(e => e.gender.ToLower() == "female").ToList()));
//return Request.CreateErrorResponse(HttpStatusCode.BadRequest,
//"Value for gender must be All,Male of Female." + gender + "is invalid.");
}
}
}
// GET api/<controller>
public HttpResponseMessage Get_PaymentDetailsList()
{
using (OVODEntities entities = new OVODEntities())
{
return(Request.CreateResponse(HttpStatusCode.OK, entities.PaymentDetails.ToList()));
}
}
public HttpResponseMessage TTList()
{
using (OVODEntities entities = new OVODEntities())
{
return(Request.CreateResponse(HttpStatusCode.OK, entities.TTMASTs.ToList()));
}
}
public IHttpActionResult TTList(int id)
{
using (OVODEntities entities = new OVODEntities())
{
//return Request.CreateResponse(HttpStatusCode.OK, entities.TTMASTs.Where(x => x.TT_ID == id).ToList());
var Ttmast = (from a in entities.TTMASTs
where a.TT_ID == id
select new
{
a.TT_ID,
a.TT_CODE,
a.TT_DESC,
a.TT_ED,
a.TT_GRATACCR,
a.TT_GROUP,
a.TT_LVEACCR,
a.TT_LVERESUME,
a.TT_SUSAIR,
a.TT_SUSGRAT,
a.TT_SUSLVE,
a.TT_TYPE
}).FirstOrDefault();
return(Ok(new { Ttmast }));
}
}
public HttpResponseMessage UploadImage()
{
string ImageName = null;
int EmpId;
var httpRequest = HttpContext.Current.Request;
var PostedFile = httpRequest.Files["Image"];
ImageName = new string(Path.GetFileNameWithoutExtension(PostedFile.FileName).Take(10).ToArray()).Replace(" ", "_");
ImageName = ImageName + DateTime.Now.ToString("yymmssfff") + Path.GetExtension(PostedFile.FileName);
var filePath = HttpContext.Current.Server.MapPath("~/Image/" + ImageName);
PostedFile.SaveAs(filePath);
EmpId = Convert.ToInt32(httpRequest["EmployeeId"]);
using (OVODEntities entities = new OVODEntities())
{
var entity = entities.ANG_EMPLOYEE.FirstOrDefault(e => e.id == EmpId);
if (entity == null)
{
return(Request.CreateErrorResponse(HttpStatusCode.NotFound, "Employee id: " + EmpId.ToString() + " not found to update."));
}
else
{
entity.PhotoPath = ImageName;
entities.SaveChanges();
return(Request.CreateResponse(HttpStatusCode.Created));
}
}
}
public Participant UpdateOutput(Participant model)
{
using (OVODEntities db = new OVODEntities())
{
db.Entry(model).State = EntityState.Modified;
db.SaveChanges();
return(model);
}
}
public Participant Insert(Participant model)
{
using (OVODEntities db = new OVODEntities())
{
db.Participants.Add(model);
db.SaveChanges();
return(model);
}
}
public HttpResponseMessage GetAnswers(int[] qIDs)
{
using (OVODEntities db = new OVODEntities())
{
var result = db.Questions
.AsEnumerable()
.Where(z => qIDs.Contains(z.QnID))
.OrderBy(x => { return(Array.IndexOf(qIDs, x.QnID)); })
.Select(z => z.Answer)
.ToArray();
return(this.Request.CreateResponse(HttpStatusCode.OK, result));
}
}
public HttpResponseMessage GetANG_EMPLOYEEs(int id)
{
using (OVODEntities entities = new OVODEntities())
{
var entity = entities.ANG_EMPLOYEE.FirstOrDefault(e => e.id == id);
if (entities != null)
{
return(Request.CreateResponse(HttpStatusCode.OK, entity));
}
else
{
return(Request.CreateErrorResponse(HttpStatusCode.NotFound, "Employee id: " + id.ToString() + " not found"));
}
}
}
// POST api/<controller>
public HttpResponseMessage Post([FromBody] PaymentDetail PaymentDetails)
{
try
{
using (OVODEntities entities = new OVODEntities())
{
//eMPLOYEE.PhotoPath = imageName;
entities.PaymentDetails.Add(PaymentDetails);
entities.SaveChanges();
}
return(Request.CreateResponse(HttpStatusCode.OK));
}
catch (Exception ex)
{
return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ex));
}
}
//public HttpResponseMessage PostAng_Employees([FromBody]ANG_EMPLOYEE employee) {
// try
// {
// using (OVODEntities entities = new OVODEntities()) {
// entities.ANG_EMPLOYEE.Add(employee);
// entities.SaveChanges();
// var message = Request.CreateResponse(HttpStatusCode.Created, employee);
// message.Headers.Location = new Uri(Request.RequestUri + employee.id.ToString());
// return message;
// }
// }
// catch (Exception ex){
// return Request.CreateErrorResponse(HttpStatusCode.BadRequest, ex);
// }
//}
public HttpResponseMessage PutAng_Employees([FromBody] ANG_EMPLOYEE employee)
{
try
{
string imageName = null;
var httpRequest = System.Web.HttpContext.Current.Request;
var postedFile = httpRequest.Files["Image"];
imageName = new string(Path.GetFileNameWithoutExtension(postedFile.FileName).Take(10).ToArray()).Replace(" ", "-");
imageName = imageName + DateTime.Now.ToString("yymmssfff") + Path.GetExtension(postedFile.FileName);
var filePath = HttpContext.Current.Server.MapPath("~/Image/" + imageName);
postedFile.SaveAs(imageName);
using (OVODEntities entities = new OVODEntities())
{
var entity = entities.ANG_EMPLOYEE.FirstOrDefault(e => e.id == employee.id);
if (entity == null)
{
return(Request.CreateErrorResponse(HttpStatusCode.NotFound, "Employee id: " + employee.id.ToString() + " not found to update."));
}
else
{
entity.name = employee.name;
entity.isActive = employee.isActive;
entity.password = employee.password;
entity.PhoneNumber = employee.PhoneNumber;
//entity.PhotoPath = employee.PhotoPath;
entity.PhotoPath = imageName;
entity.gender = employee.gender;
entity.email = employee.email;
entity.department = employee.department;
entity.dateofBirth = employee.dateofBirth;
entity.ContactPreference = employee.ContactPreference;
entities.SaveChanges();
return(Request.CreateResponse(HttpStatusCode.OK, entity));
}
}
}
catch (Exception ex)
{
return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ex));
}
}
public HttpResponseMessage GetQuestions()
{
using (OVODEntities db = new OVODEntities())
{
var qns = db.Questions
.Select(x => new { QnId = x.QnID, Qn = x.Qn, ImageName = x.ImageName, x.Option1, x.Option2, x.Option3, x.Option4 })
.OrderBy(y => Guid.NewGuid())
.Take(10)
.ToArray();
var updated = qns.AsEnumerable()
.Select(x => new
{
QnID = x.QnId,
Qn = x.Qn,
ImageName = x.ImageName,
Options = new string[] { x.Option1, x.Option2, x.Option3, x.Option4 }
}).ToList();
return(this.Request.CreateResponse(HttpStatusCode.OK, updated));
}
}
public HttpResponseMessage Post([FromBody] ANG_EMPLOYEE eMPLOYEE)
{
try
{
//string imageName = null;
//var httpRequest = System.Web.HttpContext.Current.Request;
//var postedFile = httpRequest.Files["Image"];
//imageName = new string(Path.GetFileNameWithoutExtension(postedFile.FileName).Take(10).ToArray()).Replace(" ", "_");
//imageName = imageName + DateTime.Now.ToString("yymmssfff") + Path.GetExtension(postedFile.FileName);
//postedFile.SaveAs(imageName);
//if (eMPLOYEE.Image != null)
//{
// //eMPLOYEE.Image.SaveAs(Path.Combine(filePath));
//}
using (OVODEntities entities = new OVODEntities())
{
//eMPLOYEE.PhotoPath = imageName;
entities.ANG_EMPLOYEE.Add(eMPLOYEE);
entities.SaveChanges();
}
//if (eMPLOYEE.Image != null)
//{
// imageName = Path.GetFileNameWithoutExtension(eMPLOYEE.Image.FileName);
// string imageExtn = Path.GetExtension(eMPLOYEE.Image.FileName);
// imageName = imageName + DateTime.Now.ToString("yymmssfff") + imageExtn;
// var filePath = HttpContext.Current.Server.MapPath("~/Image/" + imageName);
// eMPLOYEE.Image.SaveAs(Path.Combine(filePath));
//}
return(Request.CreateResponse(HttpStatusCode.OK));
}
catch (Exception ex)
{
return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ex));
}
}
public HttpResponseMessage TTList([FromBody] TTMAST tTMAST)
{
try
{
using (OVODEntities db = new OVODEntities())
{
if (tTMAST.TT_ID == 0)
{
db.TTMASTs.Add(tTMAST);
db.SaveChanges();
}
else
{
db.Entry(tTMAST).State = EntityState.Modified;
db.SaveChanges();
}
return(Request.CreateResponse(HttpStatusCode.Created));
}
}
catch (Exception ex)
{
return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ex));
}
}
public HttpResponseMessage Delete(int id)
{
try
{
using (OVODEntities entities = new OVODEntities())
{
var entity = entities.ANG_EMPLOYEE.FirstOrDefault(e => e.id == id);
if (entity == null)
{
return(Request.CreateErrorResponse(HttpStatusCode.NotFound, "Employee id: " + id.ToString() + " not found to delete."));
}
else
{
entities.ANG_EMPLOYEE.Remove(entity);
entities.SaveChanges();
return(Request.CreateResponse(HttpStatusCode.OK, entity));
}
}
}
catch (Exception ex)
{
return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ex));
}
}
public IEnumerable <ANG_EMPLOYEE> Get()
{
using (OVODEntities entities = new OVODEntities()) {
return(entities.ANG_EMPLOYEE.ToList());
}
}
