public int SaveUserMenu(Security_UserRight newSetupUserRightRow)
{
try
{
SCMSDataContext dbSCMS = Connection.Create();
//Security_UserRight existingSetupUserMenuRow = dbSCMS.Security_UserRights.Where(c => c.UsrSec_Id.Equals(newSetupUserRightRow.UsrGrp_Id)).SingleOrDefault();
//if (existingSetupUserMenuRow != null)
//{
//existingSetupUserMenuRow.Cmp_Id = newSetupUserRightRow.Cmp_Id;
//existingSetupUserMenuRow.Loc_Id = newSetupUserRightRow.Loc_Id;
//existingSetupUserMenuRow.UsrGrp_Title = newSetupUserRightRow.UsrGrp_Title;
//}
//else
//{
dbSCMS.Security_UserRights.InsertOnSubmit(newSetupUserRightRow);
//}
dbSCMS.SubmitChanges();
// return Convert.ToInt32(newSetupUserRightRow.UsrGrp_Id);
return 1;
}
catch
{
return 0;
}
}
// Insetion User Menu
public ActionResult SaveUserMenu(String UserMenu, int UserGroup)
{
try
{
Security_UserRight setupUserMenuRow = new Security_UserRight();
//if (String.IsNullOrEmpty(Code))
//{
// Code = DALCommon.GetMaximumCode("SECURITY_UserGroup", "UsrGrp_Id");
//}
//String UserGroupId = "0";
//if (!String.IsNullOrEmpty(Code))
//{
setupUserMenuRow.UsrSec_Code = UserGroup.ToString();
setupUserMenuRow.Grp_Id = UserGroup;
setupUserMenuRow.Mnu_Id = Convert.ToInt32(UserMenu);
setupUserMenuRow.UsrSec_Active = 1;
UserMenuId = objDalUserMenu.SaveUserMenu(setupUserMenuRow).ToString();
ViewData["UserGroupId"] = UserMenuId;
//}
return PartialView("GridData");
}
catch
{
return PartialView("GridData");
}
}
public string SaveUserRights(int GroupId, int? UserId, bool isGroup, string UserMenus)
{
try
{
string[] UserMenuIds = UserMenus.Split(',');
DALUserMenuRights objUserMenuRights = new DALUserMenuRights();
int Success = objUserMenuRights.DeleteRecordByGroupId(GroupId, UserId, SystemParameters.ModuleId);
if (Success >= 0)
{
foreach (string userMenuId in UserMenuIds)
{
Security_UserRight userRightRow = new Security_UserRight();
string Code = "";
if (DALCommon.AutoCodeGeneration("Security_UserRights") == 1)
{
Code = DALCommon.GetMaximumCode("Security_UserRights");
}
userRightRow.UsrSec_Code = Code;
userRightRow.Grp_Id = GroupId;
if (UserId != null)
{
userRightRow.UsrSec_UserId = UserId.ToString();
}
string[] cols = userMenuId.Split('~');
userRightRow.Mnu_Id = Convert.ToInt32(cols[0]);
userRightRow.UsrSec_Add = Convert.ToBoolean(cols[1]);
userRightRow.UsrSec_Edit = Convert.ToBoolean(cols[2]);
userRightRow.UsrSec_Delete = Convert.ToBoolean(cols[3]);
userRightRow.UsrSec_Print = Convert.ToBoolean(cols[4]);
userRightRow.UsrSec_Import = Convert.ToBoolean(cols[5]);
userRightRow.Mod_Id = SystemParameters.ModuleId;
objUserMenuRights.SaveRecord(userRightRow);
}
}
return "1";
}
catch
{
return "0";
}
}
public int SaveRecord(Security_UserRight pRow_NewData)
{
int li_ReturnValue = 0;
try
{
SCMSDataContext dbSCMS = Connection.Create();
dbSCMS.Security_UserRights.InsertOnSubmit(pRow_NewData);
dbSCMS.SubmitChanges();
li_ReturnValue = Convert.ToInt32(pRow_NewData.Mnu_Id);
}
catch
{
return 0;
}
return li_ReturnValue;
}
public int CopyUserRights(string CurrentUserId, string NewUserId, string SelectedTab)
{
try
{
string GroupId = "";
GroupId = new DALUser().GetAllData().Where(c => c.User_Id.Equals(NewUserId)).SingleOrDefault().UsrGrp_Id;
SCMSDataContext dbSCMS = Connection.Create();
if (SelectedTab == "Menus")
{
List<Security_UserRight> currentUserMenuRights = dbSCMS.Security_UserRights.Where(c => c.UsrSec_UserId.Equals(Convert.ToInt32(CurrentUserId))).ToList();
List<Security_UserRight> newUserMenuRights = dbSCMS.Security_UserRights.Where(c => c.UsrSec_UserId.Equals(Convert.ToInt32(NewUserId))).ToList();
if (newUserMenuRights != null && newUserMenuRights.Count > 0)
{
dbSCMS.Security_UserRights.DeleteAllOnSubmit(newUserMenuRights);
dbSCMS.SubmitChanges();
}
if (currentUserMenuRights != null && currentUserMenuRights.Count > 0)
{
foreach (Security_UserRight userRight in currentUserMenuRights)
{
Security_UserRight newUserRight = new Security_UserRight();
newUserRight.Grp_Id = Convert.ToInt32(GroupId); //userRight.Grp_Id;
newUserRight.Mnu_Id = userRight.Mnu_Id;
newUserRight.Mod_Id = userRight.Mod_Id;
newUserRight.UsrSec_UserId = Convert.ToInt32(NewUserId).ToString();
newUserRight.UsrSec_Add = userRight.UsrSec_Add;
newUserRight.UsrSec_Edit = userRight.UsrSec_Edit;
newUserRight.UsrSec_Delete = userRight.UsrSec_Delete;
newUserRight.UsrSec_Print = userRight.UsrSec_Print;
newUserRight.UsrSec_Import = userRight.UsrSec_Import;
SaveRecord(newUserRight);
}
}
else
{
return 0;
}
}
else if (SelectedTab == "Locations")
{
List<Security_UserLocation> currentUserLocations = dbSCMS.Security_UserLocations.Where(c => c.User_Id.Equals(CurrentUserId)).ToList();
List<Security_UserLocation> newUserLocations = dbSCMS.Security_UserLocations.Where(c => c.User_Id.Equals(NewUserId)).ToList();
if (newUserLocations != null && newUserLocations.Count > 0)
{
dbSCMS.Security_UserLocations.DeleteAllOnSubmit(newUserLocations);
dbSCMS.SubmitChanges();
}
if (currentUserLocations != null && currentUserLocations.Count > 0)
{
foreach (Security_UserLocation userLocation in currentUserLocations)
{
Security_UserLocation newUserLocation = new Security_UserLocation();
newUserLocation.UsrGrp_Id = GroupId;
newUserLocation.User_Id = NewUserId;
newUserLocation.Loc_Id = userLocation.Loc_Id;
SetUserLocations(newUserLocation);
}
}
else
{
return 0;
}
}
else if (SelectedTab == "VoucherTypes")
{
List<Security_UserVoucherType> currentVoucherTypes = dbSCMS.Security_UserVoucherTypes.Where(c => c.User_Id.Equals(CurrentUserId)).ToList();
List<Security_UserVoucherType> newVouchertTypes = dbSCMS.Security_UserVoucherTypes.Where(c => c.User_Id.Equals(NewUserId)).ToList();
if (newVouchertTypes != null && newVouchertTypes.Count > 0)
{
dbSCMS.Security_UserVoucherTypes.DeleteAllOnSubmit(newVouchertTypes);
dbSCMS.SubmitChanges();
}
if (currentVoucherTypes != null && currentVoucherTypes.Count > 0)
{
foreach (Security_UserVoucherType userVoucherType in currentVoucherTypes)
{
Security_UserVoucherType newUserVoucherType = new Security_UserVoucherType();
newUserVoucherType.UserGrp_Id = GroupId;
newUserVoucherType.User_Id = NewUserId;
newUserVoucherType.VchrType_Id = userVoucherType.VchrType_Id;
SetUserVoucherTypes(newUserVoucherType);
}
}
else
{
return 0;
}
}
else if (SelectedTab == "ChartOfAccounts")
{
List<Security_UserChartOfAccount> currentChartOfAccounts = dbSCMS.Security_UserChartOfAccounts.Where(c => c.User_Id.Equals(CurrentUserId)).ToList();
List<Security_UserChartOfAccount> newChartOfAccounts = dbSCMS.Security_UserChartOfAccounts.Where(c => c.User_Id.Equals(NewUserId)).ToList();
if (newChartOfAccounts != null && newChartOfAccounts.Count > 0)
{
dbSCMS.Security_UserChartOfAccounts.DeleteAllOnSubmit(newChartOfAccounts);
dbSCMS.SubmitChanges();
}
if (currentChartOfAccounts != null && currentChartOfAccounts.Count > 0)
{
foreach (Security_UserChartOfAccount userChartOfAccount in currentChartOfAccounts)
{
Security_UserChartOfAccount newUserChartOfAccount = new Security_UserChartOfAccount();
newUserChartOfAccount.UserGrp_Id = GroupId;
newUserChartOfAccount.User_Id = NewUserId;
newUserChartOfAccount.ChrtAcc_Id = userChartOfAccount.ChrtAcc_Id;
SetUserChartOfAccount(newUserChartOfAccount);
}
}
else
{
return 0;
}
}
return 1;
}
catch
{
return 0;
}
}
