// POST api/values
public int Post([FromBody] TBL_USER_INFO value)
{
try
{
using (DB_APIEntities dbContext = new DB_APIEntities())
{
if (value.Id > 0)
{
TBL_USER_INFO oTBL_USER_INFO = dbContext.TBL_USER_INFO.FirstOrDefault(c => c.Id == value.Id);
oTBL_USER_INFO.FirstName = value.FirstName;
oTBL_USER_INFO.LastName = value.LastName;
oTBL_USER_INFO.Password = value.Password;
oTBL_USER_INFO.EMail = value.EMail;
oTBL_USER_INFO.PhoneNumber = value.PhoneNumber;
dbContext.Entry(oTBL_USER_INFO).State = EntityState.Modified;
}
else
{
value.CreatedDate = DateTime.Now;
value.Gender = "";
value.GroupId = 1;
value.IsActive = true;
dbContext.TBL_USER_INFO.Add(value);
}
dbContext.SaveChanges();
return(1);
}
}
catch (Exception ex)
{
return(-1);
}
}
public ActionResult userLogin(string strEmail, string strPassword)
{
TBL_USER_INFO oTBL_USER_INFO = new TBL_USER_INFO();
oTBL_USER_INFO = db.TBL_USER_INFO
.FirstOrDefault(user => user.EMail.ToLower() == strEmail.ToLower() && user.Password == strPassword);
GetSesstionReady(oTBL_USER_INFO);
return(Json(new { success = 1 }, JsonRequestBehavior.AllowGet));
}
public int GetSesstionReady(TBL_USER_INFO user)
{
try
{
Session["UserProfile"] = user;
return(1);
}
catch (Exception e)
{
e.ToString();
return(-1);
}
}
// DELETE api/values/5
public void Delete(int id)
{
try
{
using (DB_APIEntities dbContext = new DB_APIEntities())
{
TBL_USER_INFO oTBL_USER_INFO = dbContext.TBL_USER_INFO.Find(id);
dbContext.TBL_USER_INFO.Remove(oTBL_USER_INFO);
dbContext.SaveChanges();
}
}
catch (Exception ex)
{
}
}
public ActionResult sendEmailClick(string Ids, string txtSubject, string txtBody)
{
if (string.IsNullOrEmpty(Ids) || string.IsNullOrEmpty(txtSubject) || string.IsNullOrEmpty(txtBody))
{
return(Json(new { success = 0 }, JsonRequestBehavior.AllowGet));
}
var splittedIds = Ids.Split(',');
foreach (var item in splittedIds)
{
int _id = -1;
if (int.TryParse(item, out _id))
{
TBL_USER_INFO obj = db.TBL_USER_INFO.FirstOrDefault(c => c.Id == _id);
sendEmail(obj.EMail, txtSubject, txtBody);
}
}
return(Json(new { success = 1 }, JsonRequestBehavior.AllowGet));
}
// PUT api/values/5
public int Put(int id, [FromBody] TBL_USER_INFO value)
{
try
{
using (DB_APIEntities dbContext = new DB_APIEntities())
{
TBL_USER_INFO oTBL_USER_INFO = dbContext.TBL_USER_INFO.FirstOrDefault(c => c.Id == id);
oTBL_USER_INFO.FirstName = value.FirstName;
oTBL_USER_INFO.LastName = value.LastName;
oTBL_USER_INFO.Password = value.Password;
oTBL_USER_INFO.EMail = value.EMail;
oTBL_USER_INFO.PhoneNumber = value.PhoneNumber;
dbContext.Entry(oTBL_USER_INFO).State = EntityState.Modified;
dbContext.SaveChanges();
return(1);
}
}
catch (Exception ex)
{
return(-1);
}
}
// GET api/values/5
public TBL_USER_INFO Get(int id)
{
TBL_USER_INFO obj = db.TBL_USER_INFO.FirstOrDefault(user => user.Id == id);
return(obj);
}
