public ResultModel DeleteUser(long UserID)
{
ResultModel resultModel = new ResultModel();
using (var context = new RealStateEntities())
{
try
{
var Result = (from e in context.UserMasters where e.UserID == UserID select e).FirstOrDefault();
if (Result != null)
{
context.UserMasters.Attach(Result);
context.UserMasters.Remove(Result);
context.SaveChanges();
resultModel.Message = "Record Has been Deleted";
}
else
{
resultModel.Message = "Record Not Found";
}
}
catch (Exception ex)
{
resultModel.Message = ex.Message;
return(resultModel);
}
}
return(resultModel);
}
public AccountModel GetUserdetailbyUserId(long UserID)
{
AccountModel model = new AccountModel();
try
{
using (var context = new RealStateEntities())
{
var result = (from u in context.UserMasters.Where(x => x.UserID == UserID)
select new AccountModel
{
FirstName = u.FirstName,
LastName = u.LastName,
Email = u.Email,
MobileNo = u.MobileNo,
UserID = u.UserID,
Role = u.Role
}).FirstOrDefault();
model = result;
}
}
catch (Exception ex)
{
}
return(model);
}
public ResultModel Adduser(AccountModel Model)
{
ResultModel resultModel = new ResultModel();
using (var context = new RealStateEntities())
{
try
{
var result = context.UserMasters.Where(x => x.Email == Model.Email).FirstOrDefault();
if (result != null)
{
resultModel.Message = "This Email Id is Already Exist";
}
else
{
var query = context.UserMasters.Create();
query.CreatedBy = 1;
query.CreatedDate = DateTime.Now;
query.Email = Model.Email;
query.FirstName = Model.FirstName;
query.LastName = Model.LastName;
query.MobileNo = Model.MobileNo;
query.password = Model.password;
query.Role = Model.Role;
query.Status = true;
context.UserMasters.Add(query);
int i = context.SaveChanges();
if (i > 0)
{
resultModel.Message = "Your Record is succuessfully inserted";
}
else
{
resultModel.Message = "Your Record is not inserted";
}
}
}
catch (Exception ex)
{
resultModel.Message = ex.Message;
return(resultModel);
}
//return Ok(false);
}
return(resultModel);
}
public ResultModel UpdateUser(AccountModel model)
{
ResultModel resultModel = new ResultModel();
using (var context = new RealStateEntities())
{
try
{
var result = (from e in context.UserMasters where e.UserID == model.UserID select e).FirstOrDefault();
if (result != null)
{
result.FirstName = model.FirstName;
result.LastName = model.LastName;
result.MobileNo = model.MobileNo;
result.ModifiedDate = DateTime.Now;
result.Email = model.Email;
result.Status = true;
result.Role = model.Role;
result.ModifiedBy = Convert.ToInt32(model.UserID);
int i = context.SaveChanges();
if (i > 0)
{
resultModel.Message = "Your Record has been succuessfully Updated";
}
else
{
resultModel.Message = "Your Record Not Updated";
}
}
}
catch (Exception ex)
{
resultModel.Message = ex.Message;
}
}
return(resultModel);
}
public AccountRepository(RealStateEntities context)
{
this._Context = context;
}
public AccountRepository()
{
this._Context = new RealStateEntities();
}
