/// <summary>
/// TMSs the users TMS groups mapping delete dal.
/// </summary>
/// <param name="_ObjTMS_Groups">The object TMS groups.</param>
/// <param name="UpdatedBy">The updated by.</param>
/// <returns>System.Int32.</returns>
public int TMS_Users_TMS_GroupsMapping_DeleteDAL(LoginUserGroups _ObjTMS_Groups, long UpdatedBy)
{
return(ExecuteScalarInt32Sp("TMS_Users_TMS_GroupsMapping_Delete",
ParamBuilder.Par("GroupId", _ObjTMS_Groups.GroupId),
ParamBuilder.Par("MappingId", _ObjTMS_Groups.GroupId),
ParamBuilder.Par("UserID", _ObjTMS_Groups.Id),
ParamBuilder.Par("UpdatedBy", UpdatedBy),
ParamBuilder.Par("UpdatedDate", System.DateTime.UtcNow)));
}
/// <summary>
/// TMSs the users TMS groups mapping create dal.
/// </summary>
/// <param name="_ObjTMS_Groups">The object TMS groups.</param>
/// <param name="CreatedBy">The created by.</param>
/// <returns>System.Int64.</returns>
public long TMS_Users_TMS_GroupsMapping_CreateDAL(LoginUserGroups _ObjTMS_Groups, long CreatedBy)
{
var parameters = new[] { ParamBuilder.Par("MappingId", 0) };
return(ExecuteInt64withOutPutparameterSp("TMS_Users_TMS_GroupsMapping_Create", parameters,
ParamBuilder.Par("GroupId", _ObjTMS_Groups.GroupId),
ParamBuilder.Par("UserID", _ObjTMS_Groups.Id),
ParamBuilder.Par("CreatedBy", CreatedBy),
ParamBuilder.Par("CreatedDate", System.DateTime.UtcNow)));
}
/// <summary>
/// Logins the users update bal.
/// </summary>
/// <param name="_objUsers">The object users.</param>
/// <returns>System.Int32.</returns>
public int LoginUsers_UpdateBAL(LoginUsers _objUsers)
{
if (_objUsers.GroupIds == null)
{
if (_objUsers.UserGroups != null)
{
for (int i = 0; i < _objUsers.UserGroups.Count; i++)
{
if (_objUsers.UserGroups[i] != null)
{
_objUsers.UserGroups[i].Id = _objUsers.UserID;
_objUsers.UserGroups[i].IsNew = false;
_objUsers.UserGroups[i].MappingId = this._GroupsDAL.TMS_Users_TMS_GroupsMapping_CreateDAL(_objUsers.UserGroups[i], _objUsers.UpdatedBy);
_objUsers.GroupIds = _objUsers.GroupIds + _objUsers.UserGroups[i].GroupId.ToString();
if (_objUsers.UserGroups.Count - 1 != i)
{
_objUsers.GroupIds = _objUsers.GroupIds.ToString() + ",";
}
}
}
}
}
else
{
char[] delimiters = new char[] { ',' };
List <string> _GroupIds = _objUsers.GroupIds.Split(delimiters, StringSplitOptions.RemoveEmptyEntries).ToList();
if (_GroupIds.Count > 0)
{
if (_objUsers.UserGroups == null)
{
for (int i = 0; i < _GroupIds.Count; i++)
{
LoginUserGroups _ObjTMS_Groups = new LoginUserGroups();
_ObjTMS_Groups.Id = _objUsers.UserID;
_ObjTMS_Groups.GroupId = Convert.ToInt64(_GroupIds[i]);
this._GroupsDAL.TMS_Users_TMS_GroupsMapping_DeleteDAL(_ObjTMS_Groups, _objUsers.UpdatedBy);
}
//delete all item from the Database
_objUsers.GroupIds = null;
}
else if (_objUsers.UserGroups.Count == 0)
{
for (int i = 0; i < _GroupIds.Count; i++)
{
LoginUserGroups _ObjTMS_Groups = new LoginUserGroups();
_ObjTMS_Groups.Id = _objUsers.UserID;
_ObjTMS_Groups.GroupId = Convert.ToInt64(_GroupIds[i]);
this._GroupsDAL.TMS_Users_TMS_GroupsMapping_DeleteDAL(_ObjTMS_Groups, _objUsers.UpdatedBy);
}
//delete all item from the Database
_objUsers.GroupIds = null;
}
else
{
//if (_objUsers.UserGroups.Count > _GroupIds.Count)
//{
// for (int i = 0; i < _objUsers.UserGroups.Count; i++)
// {
// var _result = _GroupIds.FirstOrDefault(stringToCheck => stringToCheck.Contains(_objUsers.UserGroups[i].GroupId.ToString()));
// if (string.IsNullOrEmpty(_result))
// {
// _objUsers.UserGroups[i].Id = _objUsers.UserID;
// _objUsers.UserGroups[i].IsNew = false;
// _objUsers.UserGroups[i].MappingId =this._GroupsDAL.TMS_Users_TMS_GroupsMapping_CreateDAL(_objUsers.UserGroups[i], _objUsers.UpdatedBy);
// _objUsers.GroupIds = _objUsers.GroupIds + "," + _objUsers.UserGroups[i].GroupId.ToString();
// }
// else
// {
// }
// }
//}
//else
//{
for (int i = 0; i < _GroupIds.Count; i++)
{
var _result = _objUsers.UserGroups.FirstOrDefault(s => s.GroupId == Convert.ToInt64(_GroupIds[i]));
if (_result == null)
{
LoginUserGroups _ObjTMS_Groups = new LoginUserGroups();
_ObjTMS_Groups.Id = _objUsers.UserID;
_ObjTMS_Groups.GroupId = Convert.ToInt64(_GroupIds[i]);
this._GroupsDAL.TMS_Users_TMS_GroupsMapping_DeleteDAL(_ObjTMS_Groups, _objUsers.UpdatedBy);
}
}
foreach (var grop in _objUsers.UserGroups)
{
if (grop.IsNew)
{
grop.IsNew = false;
grop.Id = _objUsers.UserID;
grop.MappingId = this._GroupsDAL.TMS_Users_TMS_GroupsMapping_CreateDAL(grop, _objUsers.UpdatedBy);
}
}
_objUsers.GroupIds = "";
for (int i = 0; i < _objUsers.UserGroups.Count; i++)
{
_objUsers.GroupIds = _objUsers.GroupIds + _objUsers.UserGroups[i].GroupId.ToString();
if (_objUsers.UserGroups.Count - 1 != i)
{
_objUsers.GroupIds = _objUsers.GroupIds.ToString() + ",";
}
}
//}
}
}
else
{
}
}
return(_DAL.LoginUsers_UpdateDAL(_objUsers));
}
