// PUT api/values/5
public void Put(string id, [FromBody] SUPPLIER supplier)
{
SUPPLIER supplierOld = dbContext.SUPPLIERs.Where(a => a.SUPLNO == id).FirstOrDefault();
supplierOld.SUPLNAME = supplier.SUPLNAME;
supplierOld.SUPLADDR = supplier.SUPLADDR;
dbContext.Entry(supplierOld).State = System.Data.Entity.EntityState.Modified;
dbContext.SaveChanges();
}
// PUT api/<controller>/5
public void Put(string id, [FromBody] POMASTER pomaster)
{
POMASTER pomasterOld = dbContext.POMASTERs.Where(a => a.PONO == id).FirstOrDefault();
pomasterOld.PODATE = pomaster.PODATE;
pomasterOld.SUPLNO = pomaster.SUPLNO;
dbContext.Entry(pomasterOld).State = System.Data.Entity.EntityState.Modified;
dbContext.SaveChanges();
}
// PUT api/<controller>/5
public void Put(string id, [FromBody] ITEM value)
{
ITEM item = dbContext.ITEMs.Where(a => a.ITCODE == id).FirstOrDefault();
item.ITDESC = value.ITDESC;
item.ITRATE = value.ITRATE;
dbContext.Entry(item).State = System.Data.Entity.EntityState.Modified;
dbContext.SaveChanges();
}
// PUT api/<controller>/5
public void Put(string id, [FromBody] PODETAIL poDetail)
{
PODETAIL poDetailOld = dbContext.PODETAILs.Where(a => a.PONO == id).FirstOrDefault();
poDetailOld.ITCODE = poDetail.ITCODE;
poDetailOld.QTY = poDetail.QTY;
dbContext.Entry(poDetailOld).State = System.Data.Entity.EntityState.Modified;
dbContext.SaveChanges();
}
public bool SaveTweet(TweetMessage tweetMsg)
{
bool IsSuccess = false;
try
{
using (_dbContext = new FSEAssignmentEntities())
{
var tweets = _dbContext.People.Where(x => x.User_Id.Trim().ToUpper() == tweetMsg.User_Id.Trim().ToUpper()).FirstOrDefault();
var tweet = _dbContext.Tweets.Where(x => x.Tweet_Id == tweetMsg.Tweet_Id).FirstOrDefault();
if (tweet == null && tweetMsg.Tweet_Id == 0)
{
tweet = new Tweet();
tweet.User_Id = tweetMsg.User_Id;
tweet.Message = tweetMsg.Message;
tweet.Created = DateTime.Now;
_dbContext.Entry(tweet).State = System.Data.Entity.EntityState.Added;
}
else
{
tweet.Message = tweetMsg.Message;
}
IsSuccess = true;
_dbContext.SaveChanges();
}
}
catch (Exception ex)
{
}
return(IsSuccess);
}
public bool RegisterOrUpdateUser(PersonModel personModel)
{
bool isRegistered = false;
try
{
using (_dbContext = new FSEAssignmentEntities())
{
Person person = _dbContext.People.Where(x => x.User_Id.ToUpper().Trim() == personModel.User_Id.ToUpper().Trim()).FirstOrDefault();
if (person == null)
{
Person user = new Person();
user.User_Id = personModel.User_Id;
user.Password = personModel.Password;
user.FullName = personModel.FullName;
user.Email = personModel.Email;
user.Joined = DateTime.Now;
user.Active = true;
_dbContext.People.Add(user);
}
else
{
if (string.IsNullOrEmpty(personModel.Password.Trim()))
{
person.Password = personModel.Password;
}
person.FullName = personModel.FullName;
person.Email = personModel.Email;
_dbContext.Entry <Person>(person).State = System.Data.Entity.EntityState.Modified;
}
_dbContext.SaveChanges();
isRegistered = true;
}
}
catch (Exception ex)
{
isRegistered = false;
}
return(isRegistered);
}
public TweetMessage EditTweet(int tweetId)
{
TweetMessage _editTweet = new TweetMessage();
try
{
using (_dbContext = new FSEAssignmentEntities())
{
var tweet = _dbContext.Tweets.Where(x => x.Tweet_Id == tweetId).FirstOrDefault();//_context.TWEETs.Where(x => x.tweet_id == tweetMsg.TweetId).FirstOrDefault();
_editTweet.User_Id = tweet.User_Id;
_editTweet.Message = tweet.Message;
_editTweet.Tweet_Id = tweet.Tweet_Id;
_editTweet.Created = DateTime.Now;
_dbContext.Entry(_editTweet).State = System.Data.Entity.EntityState.Modified;
_dbContext.SaveChanges();
}
}
catch (Exception ex)
{
}
return(_editTweet);
}
