public IHttpActionResult PostColorTemplate(tblUserMaster UserMaster)
{
db.tblUserMasters.Add(UserMaster);
db.SaveChanges();
return(CreatedAtRoute("DefaultApi", new { id = UserMaster.UserID }, UserMaster));
}
public HttpResponseMessage Put(int id, [FromBody] tblUserMaster value)
{
if (benmoonDB.tblUserMasters.Any(x => x.LoginName == value.LoginName && x.UserID != value.UserID))
{
return(ErrorJson("Record with same Login Name already Exists"));
}
if (benmoonDB.tblUserMasters.Any(x => x.Email == value.Email && x.UserID != value.UserID))
{
return(ErrorJson("Record with same Email already Exists"));
}
benmoonDB.tblUserMasters.Attach(value);
value.CommandID = 2;
value.UpdateDate = DateTime.Now;
value.UpdateIP = "";
benmoonDB.Entry(value).Property(x => x.RoleID).IsModified = true;
benmoonDB.Entry(value).Property(x => x.LoginName).IsModified = true;
benmoonDB.Entry(value).Property(x => x.UserName).IsModified = true;
benmoonDB.Entry(value).Property(x => x.Pwd).IsModified = true;
benmoonDB.Entry(value).Property(x => x.Email).IsModified = true;
benmoonDB.Entry(value).Property(x => x.Mobile).IsModified = true;
benmoonDB.Entry(value).Property(x => x.IsActive).IsModified = true;
benmoonDB.Entry(value).Property(x => x.CommandID).IsModified = true;
benmoonDB.Entry(value).Property(x => x.UpdateDate).IsModified = true;
benmoonDB.Entry(value).Property(x => x.UpdateIP).IsModified = true;
return(ToJson(benmoonDB.SaveChanges()));
}
public IHttpActionResult PutUserMasters(int id, tblUserMaster UserMaster)
{
if (id != UserMaster.UserID)
{
return(BadRequest());
}
db.Entry(UserMaster).State = EntityState.Modified;
try
{
db.SaveChanges();
}
catch (DbUpdateConcurrencyException)
{
if (!UserMastersExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(StatusCode(HttpStatusCode.NoContent));
}
public IHttpActionResult DeleteColorTemplate(int id)
{
tblUserMaster objUserMaster = db.tblUserMasters.Find(id);
if (objUserMaster == null)
{
return(NotFound());
}
db.tblUserMasters.Remove(objUserMaster);
db.SaveChanges();
return(Ok(objUserMaster));
}
public HttpResponseMessage Post([FromBody] tblUserMaster value)
{
var obj = benmoonDB.tblUserMasters.Where(x => x.LoginName.Equals(value.LoginName) && x.Pwd.Equals(value.Pwd)).Select(x => new { x.UserID, x.UserName, x.LoginName }).FirstOrDefault();
if (obj != null)
{
//HttpContext.Current.Session["UserID"] = obj.UserID;
return(ToJson(obj));
}
else
{
return(ErrorJson("Invalid Login"));
}
}
public async Task <mdlUserMasterApi> LoginAsync([FromServices] IAccount account, mdlLogin mdl)
{
mdlUserMasterApi userMaster = new mdlUserMasterApi();
string IPAddress = HttpContext.Connection.RemoteIpAddress.ToString();
if (ModelState.IsValid)
{
try
{
tblUserMaster tbl = await account.LoginAsync(mdl, IPAddress);
if (tbl.CustomerId != null)
{
userMaster.TokenData = await GenerateJSONWebTokenAsync(new mdlTookenRequest()
{
CustomerId = tbl.CustomerId ?? 0, UserId = tbl.Id, customerType = tbl.tblCustomerMaster.CustomerType, Name = tbl.tblCustomerMaster.CustomerName
});
userMaster.StatusCode = 1;
userMaster.StatusMessage = "Success";
}
else
{
userMaster.TokenData = "";
userMaster.StatusCode = 0;
userMaster.StatusMessage = "Invalid Customer Details";
}
}
catch (Exception ex)
{
userMaster.TokenData = "";
userMaster.StatusCode = 0;
userMaster.StatusMessage = ex.Message;
}
}
return(userMaster);
}
public HttpResponseMessage Post([FromBody] tblUserMaster value)
{
if (benmoonDB.tblUserMasters.Any(x => x.LoginName == value.LoginName))
{
return(ErrorJson("Record with same Login Name already Exists"));
}
if (benmoonDB.tblUserMasters.Any(x => x.Email == value.Email))
{
return(ErrorJson("Record with same Email already Exists"));
}
int intUserID = benmoonDB.tblUserMasters.Max(x => x.UserID) + 1;
value.UserID = intUserID;
value.CommandID = 1;
value.CreateDate = DateTime.Now;
value.UpdateDate = DateTime.Now;
value.CreateIP = "";
value.UpdateIP = "";
benmoonDB.tblUserMasters.Add(value);
return(ToJson(benmoonDB.SaveChanges()));
}
public string SaveUserDetails(UserModel UserModel)
{
try
{
if (entity.tblUserMasters.Any(t => t.EMAIL.ToLower() == UserModel.Email.ToLower() && t.ID != UserModel.Id))
{
return("Email already exists");
}
List <int> GroupIds = new List <int>();
if (UserModel.UserGroups != null)
{
GroupIds = UserModel.UserGroups.Split(',').Select(int.Parse).ToList();
}
if (UserModel.Id == 0)
{
var user = new tblUserMaster()
{
CELLPHONE = UserModel.Cellphone,
COMPANYID = UserModel.CompanyId,
EMERGENCYCONTACT = UserModel.EmergencyContact,
EMERGENCYCONTACTNO = UserModel.EmergencyContactNo,
EMAIL = UserModel.Email,
ENDTIME = UserModel.EndTime,
STARTTIME = UserModel.StartTime,
FIRSTNAME = UserModel.FirstName,
PASSWORD = UserModel.Password,
SURNAME = UserModel.SurName,
USERNAME = UserModel.UserName,
USERSTATUS = "A",
USERTEAMID = UserModel.UserTeamId,
USERTOKEN = UserModel.UserToken,
USERTYPE = UserModel.UserType,
WORKINGDAYS = UserModel.WorkingDays
};
entity.tblUserMasters.Add(user);
if (GroupIds != null)
{
foreach (var item in GroupIds)
{
var usergroup = new tblUserTeam()
{
TEAMID = item,
USERID = user.ID,
ARCHIVE = "A"
};
entity.tblUserTeams.Add(usergroup);
}
}
}
else
{
var y = entity.tblUserMasters.FirstOrDefault(t => t.ID == UserModel.Id);
y.CELLPHONE = UserModel.Cellphone;
y.COMPANYID = UserModel.CompanyId;
y.EMERGENCYCONTACT = UserModel.EmergencyContact;
y.EMERGENCYCONTACTNO = UserModel.EmergencyContactNo;
y.EMAIL = UserModel.Email;
y.ENDTIME = UserModel.EndTime;
y.STARTTIME = UserModel.StartTime;
y.FIRSTNAME = UserModel.FirstName;
y.PASSWORD = UserModel.Password;
y.SURNAME = UserModel.SurName;
y.USERNAME = UserModel.UserName;
y.USERSTATUS = "A";
//y.USERTEAMID = 1;
y.USERTYPE = UserModel.UserType;
y.WORKINGDAYS = UserModel.WorkingDays;
if (GroupIds != null)
{
var UserTeam = y.tblUserTeams.ToList();
var DeleteUserGroups = from p in UserTeam
where !GroupIds.Contains(p.TEAMID)
select p;
foreach (var deleteItem in DeleteUserGroups)
{
entity.tblUserTeams.Remove(deleteItem);
}
//var InsertUserGroups = from p in GroupIds
// join t in UserTeam
// on p equals t.TEAMID into tp
// from list in tp.Where(x=>x.TEAMID)
// select p;
var InsertUserGroups = new List <int>();
foreach (var item in GroupIds)
{
if ((from t in entity.tblUserTeams where t.USERID == UserModel.Id && t.TEAMID == item select t.ID).Count() == 0)
{
InsertUserGroups.Add(item);
}
}
foreach (var item in InsertUserGroups)
{
var usergroup = new tblUserTeam()
{
TEAMID = item,
USERID = UserModel.Id,
ARCHIVE = "A"
};
entity.tblUserTeams.Add(usergroup);
}
}
}
entity.SaveChanges();
return(null);
}
catch (Exception ex)
{
return("Error");
}
}
public HttpResponseMessage Put(int id, [FromBody] tblUserMaster value)
{
benmoonDB.Entry(value).State = EntityState.Modified;
return(ToJson(benmoonDB.SaveChanges()));
}
public HttpResponseMessage Post([FromBody] tblUserMaster value)
{
benmoonDB.tblUserMasters.Add(value);
return(ToJson(benmoonDB.SaveChanges()));
}
