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); }