public User GetUser(int UserId)
{
User objUser = new User();
try
{
using (var entity = new BKDHEntities11())
{
objUser = (from r in entity.Inv_M_UserMaster
where r.UserId == UserId
select new User
{
UserId = (int)r.UserId,
UserName = r.UserName,
Password = r.Passw,
FCode = r.FCode,
GroupId = (int)r.GroupId,
Remarks = r.Remarks,
ActiveStatus = r.ActiveStatus
}
).FirstOrDefault();
}
}
catch (Exception ex)
{
}
return(objUser);
}
public List <User> GetAllUserList()
{
List <User> objUserList = new List <User>();
try
{
using (var entity = new BKDHEntities11())
{
objUserList = (from r in entity.Inv_M_UserMaster
where r.GroupId != 0 && r.GroupId != 105 && r.GroupId != 101
join p in entity.M_LedgerMaster on r.BranchCode equals p.PartyCode
select new User
{
UserId = (int)r.UserId,
UserName = r.UserName,
Password = r.Passw,
FCode = r.FCode,
PartyName = p.PartyName,
Remarks = r.Remarks,
ActiveStatus = r.ActiveStatus
}
).ToList();
}
}
catch (Exception ex)
{
}
return(objUserList);
}
public ResponseDetail IsDuplicateUserName(string IsActionType, string UserCode, string UserName)
{
ResponseDetail objResponse = new ResponseDetail();
try
{
using (var entity = new BKDHEntities11())
{
if (IsActionType == "Add")
{
var result = (from r in entity.Inv_M_UserMaster
where r.UserName == UserName
select r
).FirstOrDefault();
if (result != null)
{
objResponse.ResponseStatus = "FAILED";
objResponse.ResponseMessage = "Match Found!";
}
else
{
objResponse.ResponseStatus = "OK";
objResponse.ResponseMessage = "No Match Found!";
}
}
else if (IsActionType == "Edit")
{
int UId = 0;
if (!string.IsNullOrEmpty(UserCode))
{
UId = int.Parse(UserCode);
}
var result = (from r in entity.Inv_M_UserMaster
where r.UserName == UserName && r.UserId != UId
select r
).FirstOrDefault();
if (result != null)
{
objResponse.ResponseStatus = "FAILED";
objResponse.ResponseMessage = "Match Found!";
}
else
{
objResponse.ResponseStatus = "OK";
objResponse.ResponseMessage = "No Match Found!";
}
}
else
{
objResponse.ResponseStatus = "OK";
objResponse.ResponseMessage = "No Match Found!";
}
}
}
catch (Exception ex)
{
}
return(objResponse);
}
public decimal GetPartyGroupId(string PartyCode)
{
decimal GroupId = 0;
try
{
using (var entity = new BKDHEntities11())
{
GroupId = (from r in entity.M_LedgerMaster
where r.PartyCode == PartyCode
select r.GroupId
).FirstOrDefault();
}
}
catch (Exception ex)
{
}
return(GroupId);
}
public List <PartyModel> GetPartyListForUsers()
{
List <PartyModel> objListParty = new List <PartyModel>();
try
{
using (var entity = new BKDHEntities11())
{
objListParty = (from r in entity.M_LedgerMaster
where r.ActiveStatus == "Y" && r.GroupId != 0 && r.GroupId != 105
select new PartyModel
{
PartyCode = r.PartyCode,
PartyName = r.PartyName
}).ToList();
}
}
catch (Exception ex)
{
}
return(objListParty);
}
public List <User> GetUserList()
{
List <User> objUserList = new List <User>();
try
{
using (var entity = new BKDHEntities11())
{
objUserList = (from r in entity.Inv_M_UserMaster
where r.ActiveStatus == "Y" && r.IsAdmin == "N"
select new User
{
UserId = (int)r.UserId,
UserName = r.UserName
}
).ToList();
}
}
catch (Exception ex) {
}
return(objUserList);
}
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);
}
//Accordig to new schema Inventory Db
//public User ValidateUser(LoginModel model)
//{
// User objResponse = new User();
// try
// {
// using(var entity=new InventoryEntities())
// {
// objResponse = (from result in entity.Inv_M_UserMaster
// where result.ActiveStatus == "Y" && result.UserName.ToLower() == model.UserName.ToLower() && result.Passw.ToLower() == model.password.ToLower()
// join ledger in entity.M_LedgerMaster on result.BranchCode equals ledger.PartyCode
// join groupid in entity.M_GroupMaster on ledger.GroupId equals groupid.GroupId
// select new User
// {
// UserId=(int)result.UserId,
// UserName=result.UserName,
// Password=result.Passw,
// BranchCode=result.BranchCode,
// PartyCode=ledger.PartyCode,
// PartyName=ledger.PartyName,
// GroupId=(int)ledger.GroupId,
// FCode=ledger.PartyCode,
// StateCode= (int)ledger.StateCode
// }
// ).FirstOrDefault();
// }
// }
// catch(Exception ex)
// {
// }
// //if (string.IsNullOrEmpty(objResponse.UserName))
// //{
// // objResponse = null;
// //}
// return objResponse;
//}
public User ValidateUser(LoginModel model)
{
User objResponse = new User();
try
{
using (var entity = new BKDHEntities11())
{
objResponse = (from result in entity.Inv_M_UserMaster
where result.ActiveStatus == "Y" && result.UserName == model.UserName && result.Passw == model.password
join ledger in entity.M_LedgerMaster on result.BranchCode equals ledger.PartyCode
join groupid in entity.M_GroupMaster on ledger.GroupId equals groupid.GroupId
select new User
{
UserId = (int)result.UserId,
UserName = result.UserName,
Password = result.Passw,
BranchCode = result.BranchCode,
PartyCode = ledger.PartyCode,
PartyName = ledger.PartyName,
GroupId = (int)ledger.GroupId,
FCode = ledger.PartyCode,
StateCode = (int)ledger.StateCode,
IsAdmin = result.IsAdmin,
ParentPartyCode = ledger.ParentPartyCode
}
).FirstOrDefault();
if ((!objResponse.UserName.Equals(model.UserName) || (!objResponse.Password.Equals(model.password))))
{
objResponse = null;
}
//dynamic menus
objResponse.objMenuList = new List <MenuMasterModel>();
if (objResponse != null && objResponse.IsAdmin == "N")
{
List <decimal> PermittedMenuId = (from r in entity.Web_M_UserPermissionMaster where r.GroupId == objResponse.UserId select r.MenuId).ToList();
objResponse.objMenuList = (from r in entity.Web_M_MenuMaster
where r.ActiveStatus == "Y" && PermittedMenuId.Contains(r.MenuId)
select new MenuMasterModel
{
MenuId = r.MenuId,
MenuName = r.MenuName,
ParentId = r.ParentId,
ActiveStatus = r.ActiveStatus,
Hierarchy = r.Hierar,
OnSelect = r.OnSelect,
Sequence = r.Sequence,
ChildSequence = r.ChildSequence
}).OrderBy(m => m.Sequence).ToList();
}
else
{
objResponse.objMenuList = (from r in entity.Web_M_MenuMaster
where r.ActiveStatus == "Y"
select new MenuMasterModel
{
MenuId = r.MenuId,
MenuName = r.MenuName,
ParentId = r.ParentId,
ActiveStatus = r.ActiveStatus,
Hierarchy = r.Hierar,
OnSelect = r.OnSelect,
Sequence = r.Sequence,
ChildSequence = r.ChildSequence
}).OrderBy(m => m.Sequence).ToList();
}
}
}
catch (Exception ex)
{
objResponse = null;
}
//if (string.IsNullOrEmpty(objResponse.UserName))
//{
// objResponse = null;
//}
if (objResponse != null)
{
objResponse.IsSoldByHo = false;
if (objResponse.GroupId == 0)
{
objResponse.IsSoldByHo = true;
}
if (objResponse.IsSoldByHo)
{
int indexOfOrderCreationMenu = objResponse.objMenuList.FindIndex(m => m.MenuName == "Order Creation");
if (indexOfOrderCreationMenu > -1)
{
objResponse.objMenuList.RemoveAt(indexOfOrderCreationMenu);
}
}
else
{
int indexOfOrderCreationMenu = objResponse.objMenuList.FindIndex(m => m.MenuName == "Purchase Reports");
if (indexOfOrderCreationMenu > -1)
{
decimal ParentId = objResponse.objMenuList.Where(m => m.MenuName == "Purchase Reports").Select(m => m.MenuId).FirstOrDefault();
objResponse.objMenuList.RemoveAt(indexOfOrderCreationMenu);
List <MenuMasterModel> PurchaseReportsMenus = objResponse.objMenuList.Where(m => m.ParentId == ParentId).ToList();
foreach (MenuMasterModel obj in PurchaseReportsMenus)
{
indexOfOrderCreationMenu = objResponse.objMenuList.FindIndex(m => m.MenuId == obj.MenuId);
objResponse.objMenuList.RemoveAt(indexOfOrderCreationMenu);
}
}
}
}
return(objResponse);
}
public List <UserPermissionMasterModel> ListUserPermittedMenus(decimal UserId)
{
List <UserPermissionMasterModel> objUserPermittedMenus = new List <UserPermissionMasterModel>();
try
{
using (var entity = new BKDHEntities11())
{
objUserPermittedMenus = (from r in entity.Web_M_UserPermissionMaster
where r.GroupId == UserId
select new UserPermissionMasterModel
{
MenuId = r.MenuId,
UserId = r.GroupId,
IsPermitted = true,
}).ToList();
var FullMenuList = (from r in entity.Web_M_MenuMaster
from g in entity.M_GrpPermissionMaster
from l in entity.M_LedgerMaster
from u in entity.Inv_M_UserMaster
where r.ActiveStatus == "Y" && u.BranchCode == l.PartyCode && l.GroupId == g.GroupID &&
g.MenuID == r.MenuId && u.UserId == UserId
select new MenuMasterModel
{
MenuId = r.MenuId,
MenuName = r.MenuName,
ParentId = r.ParentId,
Sequence = r.Sequence,
Hierarchy = r.Hierar,
ChildSequence = r.ChildSequence
}).ToList();
if (objUserPermittedMenus.Count == 0)
{
objUserPermittedMenus = new List <UserPermissionMasterModel>();
foreach (var obj in FullMenuList)
{
objUserPermittedMenus.Add(new UserPermissionMasterModel
{
UserId = UserId,
MenuId = obj.MenuId,
MenuName = obj.MenuName,
IsPermitted = false,
ParentId = obj.ParentId,
Sequence = obj.Sequence,
ChildSequence = obj.ChildSequence,
ParentName = FullMenuList.Where(m => m.MenuId == obj.ParentId).Select(m => m.MenuName).FirstOrDefault() == null ? "" : FullMenuList.Where(m => m.MenuId == obj.ParentId).Select(m => m.MenuName).FirstOrDefault(),
});
}
//objUserPermittedMenus.Add(new UserPermissionMasterModel
//{
// MenuList = FullMenuList
//});
}
else
{
int j = 0;
foreach (var obj in FullMenuList)
{
var IsExists = objUserPermittedMenus.Where(m => m.MenuId == obj.MenuId).Select(m => m).FirstOrDefault();
if (IsExists == null)
{
objUserPermittedMenus.Add(new UserPermissionMasterModel
{
UserId = UserId,
MenuId = obj.MenuId,
MenuName = obj.MenuName,
IsPermitted = false,
ParentId = obj.ParentId,
Sequence = obj.Sequence,
ChildSequence = obj.ChildSequence,
ParentName = FullMenuList.Where(m => m.MenuId == obj.ParentId).Select(m => m.MenuName).FirstOrDefault() == null ? "" : FullMenuList.Where(m => m.MenuId == obj.ParentId).Select(m => m.MenuName).FirstOrDefault(),
});
}
else
{
objUserPermittedMenus.Where(m => m.MenuId == obj.MenuId).Select(m =>
{
m.MenuId = m.MenuId;
m.UserId = m.UserId;
m.MenuName = obj.MenuName;
m.IsPermitted = m.IsPermitted;
m.ParentId = obj.ParentId;
m.ParentName = FullMenuList.Where(k => k.MenuId == obj.ParentId).Select(k => k.MenuName).FirstOrDefault() == null ? "" : FullMenuList.Where(k => k.MenuId == obj.ParentId).Select(k => k.MenuName).FirstOrDefault();
m.Sequence = obj.Sequence;
m.ChildSequence = obj.ChildSequence;
return(m);
}).ToList();
}
j++;
}
//if (objUserPermittedMenus.Count != FullMenuList.Count)
//{
// var ListId = objUserPermittedMenus.Select(p => p.MenuId).ToList();
// var ResultList = FullMenuList.Select(m =>m.MenuId).ToList();
// var RemainingList = ResultList.Except(ListId).ToList();
// foreach (var Id in RemainingList)
// {
// objUserPermittedMenus.Add(new UserPermissionMasterModel
// {
// UserId = UserId,
// MenuId = Id,
// MenuName = FullMenuList.Where(m => m.MenuId == Id).Select(m => m.MenuName).FirstOrDefault() == null ? "" : FullMenuList.Where(m => m.MenuId == Id).Select(m => m.MenuName).FirstOrDefault(),
// IsPermitted = false,
// ParentId = FullMenuList.Where(m => m.MenuId == Id).Select(m => m.ParentId).FirstOrDefault() == null ? 0 : FullMenuList.Where(m => m.MenuId == Id).Select(m => m.ParentId).FirstOrDefault(),
// ParentName = FullMenuList.Where(m => m.MenuId == FullMenuList.Where(p => p.MenuId == Id).Select(p => p.ParentId).FirstOrDefault()).Select(m => m.MenuName).FirstOrDefault() == null ? "" : FullMenuList.Where(m => m.MenuId == FullMenuList.Where(p => p.MenuId == Id).Select(p => p.ParentId).FirstOrDefault()).Select(m => m.MenuName).FirstOrDefault(),
// });
// }
//}
}
}
}
catch (Exception ex)
{
}
// objUserPermittedMenus = objUserPermittedMenus.OrderBy(m=>m.ChildSequence).OrderBy(m=>m.Sequence).ToList();
objUserPermittedMenus = objUserPermittedMenus.Where(m => m.MenuName != null).OrderBy(m => m.ChildSequence).OrderBy(m => m.Sequence).ToList();
return(objUserPermittedMenus);
}
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 BKDHEntities11())
{
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 = System.Configuration.ConfigurationManager.ConnectionStrings["BKDHServices"].ConnectionString;
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.IsAdmin = "N";
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.UId = 0;
DTUser.UserName = objModel.UserName;
if (objModel.IsActionName == "Add")
{
DTUser.ActiveStatus = "Y";
DTUser.GroupId = objModel.GroupId;
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);
}
public ResponseDetail SetUserRights(List <UserPermissionMasterModel> objPermissionList)
{
ResponseDetail objResponse = new ResponseDetail();
objResponse.ResponseStatus = "FAILED";
objResponse.ResponseMessage = "Something went wrong!";
try
{
using (var entity = new BKDHEntities11())
{
var FullPermissionList = (from r in entity.Web_M_UserPermissionMaster select r).ToList();
if (FullPermissionList.Count > 0)
{
foreach (var obj in objPermissionList)
{
Web_M_UserPermissionMaster objDTUserPermission = new Web_M_UserPermissionMaster();
var IsExistsRecord = (from r in FullPermissionList where r.MenuId == obj.MenuId && r.GroupId == obj.UserId select r).FirstOrDefault();
if (obj.IsPermitted)
{
if (IsExistsRecord != null)
{
}
else
{
objDTUserPermission.GroupId = obj.UserId;
objDTUserPermission.MenuId = obj.MenuId;
objDTUserPermission.UserId = obj.CurrentLoginUser.UserId;
objDTUserPermission.RecTimeStamp = DateTime.Now;
entity.Web_M_UserPermissionMaster.Add(objDTUserPermission);
}
}
else
{
if (IsExistsRecord != null)
{
objDTUserPermission = IsExistsRecord;
entity.Web_M_UserPermissionMaster.Remove(objDTUserPermission);
}
}
}
}
else
{
foreach (var obj in objPermissionList)
{
Web_M_UserPermissionMaster objDTUserPermission = new Web_M_UserPermissionMaster();
if (obj.IsPermitted)
{
objDTUserPermission.GroupId = obj.UserId;
objDTUserPermission.MenuId = obj.MenuId;
objDTUserPermission.UserId = obj.CurrentLoginUser.UserId;
objDTUserPermission.RecTimeStamp = DateTime.Now;
entity.Web_M_UserPermissionMaster.Add(objDTUserPermission);
}
}
}
int i = 0;
i = entity.SaveChanges();
if (i > 0)
{
objResponse.ResponseMessage = "Saved Successfully";
objResponse.ResponseStatus = "OK";
}
}
}
catch (Exception ex)
{
}
return(objResponse);
}