public ResponseDetail ChangePassword(ChangePassword model)
{
ResponseDetail objResponse = new ResponseDetail();
try
{
using (var entity = new BKDHEntities11())
{
if (model != null)
{
Inv_M_UserMaster objDtUserMaser = new Inv_M_UserMaster();
objDtUserMaser = (from r in entity.Inv_M_UserMaster
where r.Passw == model.CurrentPassword && r.UserName == model.UserName
select r
).FirstOrDefault();
if (objDtUserMaser != null)
{
objDtUserMaser.Passw = model.NewPassword;
int i = entity.SaveChanges();
if (i > 0)
{
objResponse.ResponseStatus = "OK";
objResponse.ResponseMessage = "Password successfully changed!";
}
else
{
objResponse.ResponseStatus = "Failed";
objResponse.ResponseMessage = "Something went wrong!";
}
}
}
}
}
catch (Exception ex)
{
}
return(objResponse);
}
public ResponseDetail AddEditUserDetails(User objModel, User LoggedUser)
{
ResponseDetail objResponse = new ResponseDetail();
objResponse.ResponseMessage = "Something went wrong!";
objResponse.ResponseStatus = "FAILED";
Inv_M_UserMaster DTUser = new Inv_M_UserMaster();
Inv_TempUserMaster TempDTUser = new Inv_TempUserMaster();
string Version = "";
try
{
using (var entity = new InventoryEntities(enttConstr))
{
Version = (from result in entity.M_NewHOVersionInfo select result.VersionNo).FirstOrDefault();
decimal maxUserId = 0;
maxUserId = (from r in entity.Inv_M_UserMaster
select r.UserId
).DefaultIfEmpty(0).Max();
maxUserId = maxUserId + 1;
DTUser = (from r in entity.Inv_M_UserMaster where r.UserId == objModel.UserId select r).FirstOrDefault();
if (DTUser == null)
{
DTUser = new Inv_M_UserMaster();
}
else
{
////insert into temp table
//TempDTUser.UserId = DTUser.UserId;
//TempDTUser.UserName = DTUser.UserName;
//TempDTUser.Passw = DTUser.Passw;
//TempDTUser.Remarks = DTUser.Remarks;
//TempDTUser.Status = DTUser.Status;
//TempDTUser.FCode = DTUser.FCode;
//TempDTUser.BranchCode = DTUser.BranchCode;
//TempDTUser.ActiveStatus = DTUser.ActiveStatus;
//TempDTUser.CreateBy = DTUser.CreateBy;
//TempDTUser.RecTimeStamp = DTUser.RecTimeStamp;
//TempDTUser.CreateDate = DTUser.CreateDate;
//TempDTUser.GroupId = DTUser.GroupId;
//TempDTUser.IsAdmin = DTUser.IsAdmin;
//TempDTUser.LastIP = DTUser.LastIP;
//TempDTUser.LastLoginTime = DTUser.LastLoginTime;
//TempDTUser.LastLogOutTime = DTUser.LastLogOutTime;
//TempDTUser.LastModified = DTUser.LastModified;
//TempDTUser.LoginStatus = DTUser.LoginStatus;
//TempDTUser.LUserId = DTUser.LUserId;
//TempDTUser.MRecTimeStamp = DateTime.Now.Date;
//TempDTUser.MUserId = LoggedUser.UserId;
//TempDTUser.TId = 0;
//TempDTUser.UId = DTUser.UId;
//TempDTUser.Version = DTUser.Version;
//entity.Inv_TempUserMaster.Add(TempDTUser);
string AppConnectionString = InvConstr;
SqlConnection SC = new SqlConnection(AppConnectionString);
string query = "INSERT Inv_TempUserMaster Select *,'" + LoggedUser.UserId + "',Getdate() FROM Inv_M_UserMaster WHERE UserID='" + DTUser.UserId + "'";
SC.Open();
SqlCommand cmd = new SqlCommand(query, SC);
cmd.ExecuteNonQuery();
SC.Close();
}
//updating values
if (objModel.IsActionName == "Delete")
{
DTUser.ActiveStatus = "N";
}
else
{
DTUser.BranchCode = objModel.FCode;
DTUser.FCode = objModel.FCode;
DTUser.LastModified = DateTime.Now.Date.ToString();
DTUser.GroupId = objModel.GroupId;
DTUser.IsAdmin = DTUser.IsAdmin;
DTUser.LastIP = "0";
DTUser.LastLoginTime = DateTime.Now.Date;
DTUser.LastLogOutTime = "";
DTUser.LoginStatus = "";
DTUser.LUserId = LoggedUser.UserId;
DTUser.Passw = objModel.Password;
DTUser.RecTimeStamp = DateTime.Now.Date;
DTUser.Remarks = objModel.Remarks != null ? objModel.Remarks : "";
DTUser.Status = objModel.ActiveStatus;
DTUser.Mobile = objModel.Mobile;
DTUser.Email = objModel.Email;
DTUser.ActiveStatus = objModel.ActiveStatus;
//DTUser.UId = 0;
DTUser.UserName = objModel.UserName;
if (objModel.IsActionName == "Add")
{
DTUser.IsAdmin = "N";
DTUser.ActiveStatus = "Y";
DTUser.CreateBy = LoggedUser.UserId.ToString();
DTUser.CreateDate = DateTime.Now.Date;
DTUser.UserId = maxUserId;
entity.Inv_M_UserMaster.Add(DTUser);
}
DTUser.Version = Version;
}
int i = entity.SaveChanges();
if (objModel.IsActionName == "Edit" || i > 0)
{
if (objModel.IsActionName == "Edit")
{
objResponse.ResponseMessage = "Updated Successfully!";
}
else if (objModel.IsActionName == "Add")
{
objResponse.ResponseMessage = "Saved Successfully!";
}
else
{
objResponse.ResponseMessage = "Deleted Successfully!";
}
objResponse.ResponseStatus = "OK";
}
else
{
objResponse.ResponseMessage = "Something went wrong!";
objResponse.ResponseStatus = "FAILED";
}
}
}
catch (Exception ex)
{
}
return(objResponse);
}
