public static IEnumerable <string> GetExistingRoles(System.Web.UI.WebControls.ListItemCollection providedRoles)
{
List <string> existingRoles = new List <string>();
var roleNames = new string[providedRoles.Count];
for (int i = 0; i < providedRoles.Count; i++)
{
roleNames[i] = $"\'{providedRoles[i].Value}\'";
}
string selectRolesQuery = $"SELECT RoleName FROM dbo.aspnet_Roles WHERE RoleName IN ({String.Join(",", roleNames)});";
using (SqlConnection connection = new SqlConnection(Settings.GetConnectionString(Factory.GetDatabase("core").ConnectionStringName)))
{
connection.Open();
SqlCommand command = new SqlCommand(selectRolesQuery, connection);
using (SqlDataReader reader = command.ExecuteReader())
{
while (reader.Read())
{
existingRoles.Add((string)reader[0]);
}
}
}
return(existingRoles);
}
public static void SetSelectionByText(System.Web.UI.WebControls.ListItemCollection listItemCollection,
string text)
{
for (int i = 0; i < listItemCollection.Count; i++)
{
listItemCollection[i].Selected = listItemCollection[i].Text == text;
}
}
public static void SetSelectionByValue(System.Web.UI.WebControls.ListItemCollection listItemCollection,
string value)
{
for (int i = 0; i < listItemCollection.Count; i++)
{
listItemCollection[i].Selected = listItemCollection[i].Value == value;
}
}
public static void AddEnum <TEnum>(this System.Web.UI.WebControls.ListItemCollection items) where TEnum : struct
{
System.Type enumerationType = typeof(TEnum);
if (!enumerationType.IsEnum)
{
throw new Exception("Enumeration type is expected.");
}
string[] enumTypeNames = System.Enum.GetNames(enumerationType);
object[] enumTypeValues = (object[])System.Enum.GetValues(enumerationType); //While most enums are int types, it is safer to not assume, so we use object types instead.
for (int i = 0; i < enumTypeValues.Length; i++)
{
items.add(new System.Web.UI.WebControls.ListItem(enumTypeNames[i], enumTypeValues[i].ToString()));
}
}
public static void AddEnum <TEnum>(this System.Web.UI.WebControls.ListItemCollection items) where TEnum : struct
{
System.Type enumType = typeof(TEnum);
System.Type enumUnderType = System.Enum.GetUnderlyingType(enumType);
if (!enumType.IsEnum)
{
throw new Exception("Enumeration type is expected.");
}
string[] enumTypeNames = System.Enum.GetNames(enumType);
TEnum[] enumTypeValues = (TEnum[])System.Enum.GetValues(enumType);
for (int i = 0; i < enumTypeValues.Length; i++)
{
items.add(new System.Web.UI.WebControls.ListItem(enumTypeNames[i], Convert.ChangeType(enumTypeValues[i], enumUnderType).ToString())); //Sadly you cannot easily get the numeric value of the enumeration in C# using the .ToString overload or converting it to another type (like int). The problem is an enum can be any whole number base type including uint, long, and ulong. Since long and long would give different values for 0xFFFF0000, it is better to use the Convert.ChangeType method.
}
}
public static void AddEnum <TEnum>(this System.Web.UI.WebControls.ListItemCollection items) where TEnum : struct
{
System.Type enumType = typeof(TEnum);
System.Type enumUnderType = System.Enum.GetUnderlyingType(TEnum);
if (!enumType.IsEnum)
{
throw new Exception("Enumeration type is expected.");
}
string[] enumTypeNames = System.Enum.GetNames(enumType);
TEnum[] enumTypeValues = (TEnum[])System.Enum.GetValues(enumType);
for (int i = 0; i < enumTypeValues.Length; i++)
{
items.add(new System.Web.UI.WebControls.ListItem(enumTypeNames[i], Convert.ChangeType(enumTypeValues[i], enumUnderType).ToString()));
}
}
public static void SaveProductMap(int varCustomizedProductDisplayTypeId, System.Web.UI.WebControls.ListItemCollection itemList)
{
QueryCommandCollection coll = new SubSonic.QueryCommandCollection();
//delete out the existing
QueryCommand cmdDel = new QueryCommand("DELETE FROM dashCommerce_Store_CustomizedProductDisplayType_Product_Map WHERE CustomizedProductDisplayTypeId=@CustomizedProductDisplayTypeId", CustomizedProductDisplayType.Schema.Provider.Name);
cmdDel.AddParameter("@CustomizedProductDisplayTypeId", varCustomizedProductDisplayTypeId);
coll.Add(cmdDel);
DataService.ExecuteTransaction(coll);
foreach (System.Web.UI.WebControls.ListItem l in itemList)
{
if (l.Selected)
{
CustomizedProductDisplayTypeProductMap varCustomizedProductDisplayTypeProductMap = new CustomizedProductDisplayTypeProductMap();
varCustomizedProductDisplayTypeProductMap.SetColumnValue("CustomizedProductDisplayTypeId", varCustomizedProductDisplayTypeId);
varCustomizedProductDisplayTypeProductMap.SetColumnValue("ProductId", l.Value);
varCustomizedProductDisplayTypeProductMap.Save();
}
}
}
public static void SaveSysUserMap(long varIRole, System.Web.UI.WebControls.ListItemCollection itemList)
{
QueryCommandCollection coll = new SubSonic.QueryCommandCollection();
//delete out the existing
QueryCommand cmdDel = new QueryCommand("DELETE FROM [tbl_RolesForUsers] WHERE [tbl_RolesForUsers].[FP_sBranchID] = @FP_sBranchID", SysRole.Schema.Provider.Name);
cmdDel.AddParameter("@FP_sBranchID", varIRole, DbType.String);
coll.Add(cmdDel);
DataService.ExecuteTransaction(coll);
foreach (System.Web.UI.WebControls.ListItem l in itemList)
{
if (l.Selected)
{
TblRolesForUser varTblRolesForUser = new TblRolesForUser();
varTblRolesForUser.SetColumnValue("FP_sBranchID", varIRole);
varTblRolesForUser.SetColumnValue("FP_sBranchID", l.Value);
varTblRolesForUser.Save();
}
}
}
public static void SaveProductModelMap(string varCultureID, System.Web.UI.WebControls.ListItemCollection itemList)
{
QueryCommandCollection coll = new SubSonic.QueryCommandCollection();
//delete out the existing
QueryCommand cmdDel = new QueryCommand("DELETE FROM ProductModelProductDescriptionCulture WHERE CultureID=@CultureID", Culture.Schema.Provider.Name);
cmdDel.AddParameter("@CultureID", varCultureID);
coll.Add(cmdDel);
DataService.ExecuteTransaction(coll);
foreach (System.Web.UI.WebControls.ListItem l in itemList)
{
if (l.Selected)
{
ProductModelProductDescriptionCulture varProductModelProductDescriptionCulture = new ProductModelProductDescriptionCulture();
varProductModelProductDescriptionCulture.SetColumnValue("CultureID", varCultureID);
varProductModelProductDescriptionCulture.SetColumnValue("ProductModelID", l.Value);
varProductModelProductDescriptionCulture.Save();
}
}
}
public static void SaveProductMap(int varProductPhotoID, System.Web.UI.WebControls.ListItemCollection itemList)
{
QueryCommandCollection coll = new SubSonic.QueryCommandCollection();
//delete out the existing
QueryCommand cmdDel = new QueryCommand("DELETE FROM ProductProductPhoto WHERE ProductPhotoID=@ProductPhotoID", ProductPhoto.Schema.Provider.Name);
cmdDel.AddParameter("@ProductPhotoID", varProductPhotoID);
coll.Add(cmdDel);
DataService.ExecuteTransaction(coll);
foreach (System.Web.UI.WebControls.ListItem l in itemList)
{
if (l.Selected)
{
ProductProductPhoto varProductProductPhoto = new ProductProductPhoto();
varProductProductPhoto.SetColumnValue("ProductPhotoID", varProductPhotoID);
varProductProductPhoto.SetColumnValue("ProductID", l.Value);
varProductProductPhoto.Save();
}
}
}
public static void SaveProductMap(int varOrderID, System.Web.UI.WebControls.ListItemCollection itemList)
{
QueryCommandCollection coll = new SubSonic.QueryCommandCollection();
//delete out the existing
QueryCommand cmdDel = new QueryCommand("DELETE FROM [Order Details] WHERE [Order Details].[OrderID] = @OrderID", Order.Schema.Provider.Name);
cmdDel.AddParameter("@OrderID", varOrderID, DbType.Int32);
coll.Add(cmdDel);
DataService.ExecuteTransaction(coll);
foreach (System.Web.UI.WebControls.ListItem l in itemList)
{
if (l.Selected)
{
OrderDetail varOrderDetail = new OrderDetail();
varOrderDetail.SetColumnValue("OrderID", varOrderID);
varOrderDetail.SetColumnValue("ProductID", l.Value);
varOrderDetail.Save();
}
}
}
public static void SaveEmployeeMap(byte varShiftID, System.Web.UI.WebControls.ListItemCollection itemList)
{
QueryCommandCollection coll = new SubSonic.QueryCommandCollection();
//delete out the existing
QueryCommand cmdDel = new QueryCommand("DELETE FROM EmployeeDepartmentHistory WHERE ShiftID=@ShiftID", Shift.Schema.Provider.Name);
cmdDel.AddParameter("@ShiftID", varShiftID);
coll.Add(cmdDel);
DataService.ExecuteTransaction(coll);
foreach (System.Web.UI.WebControls.ListItem l in itemList)
{
if (l.Selected)
{
EmployeeDepartmentHistory varEmployeeDepartmentHistory = new EmployeeDepartmentHistory();
varEmployeeDepartmentHistory.SetColumnValue("ShiftID", varShiftID);
varEmployeeDepartmentHistory.SetColumnValue("EmployeeID", l.Value);
varEmployeeDepartmentHistory.Save();
}
}
}
public static void SaveContactTypeMap(int varVendorID, System.Web.UI.WebControls.ListItemCollection itemList)
{
QueryCommandCollection coll = new SubSonic.QueryCommandCollection();
//delete out the existing
QueryCommand cmdDel = new QueryCommand("DELETE FROM VendorContact WHERE VendorID=@VendorID", Vendor.Schema.Provider.Name);
cmdDel.AddParameter("@VendorID", varVendorID);
coll.Add(cmdDel);
DataService.ExecuteTransaction(coll);
foreach (System.Web.UI.WebControls.ListItem l in itemList)
{
if (l.Selected)
{
VendorContact varVendorContact = new VendorContact();
varVendorContact.SetColumnValue("VendorID", varVendorID);
varVendorContact.SetColumnValue("ContactTypeID", l.Value);
varVendorContact.Save();
}
}
}
public static void SaveSalesPersonMap(int varTerritoryID, System.Web.UI.WebControls.ListItemCollection itemList)
{
QueryCommandCollection coll = new SubSonic.QueryCommandCollection();
//delete out the existing
QueryCommand cmdDel = new QueryCommand("DELETE FROM SalesTerritoryHistory WHERE TerritoryID=@TerritoryID", SalesTerritory.Schema.Provider.Name);
cmdDel.AddParameter("@TerritoryID", varTerritoryID);
coll.Add(cmdDel);
DataService.ExecuteTransaction(coll);
foreach (System.Web.UI.WebControls.ListItem l in itemList)
{
if (l.Selected)
{
SalesTerritoryHistory varSalesTerritoryHistory = new SalesTerritoryHistory();
varSalesTerritoryHistory.SetColumnValue("TerritoryID", varTerritoryID);
varSalesTerritoryHistory.SetColumnValue("SalesPersonID", l.Value);
varSalesTerritoryHistory.Save();
}
}
}
public static void SaveKELENGKAPANMap(string varKODEPBJ, System.Web.UI.WebControls.ListItemCollection itemList)
{
QueryCommandCollection coll = new SubSonic.QueryCommandCollection();
//delete out the existing
QueryCommand cmdDel = new QueryCommand("DELETE FROM KELENGKAPANPBJ WHERE KODEBPJ=@KODEBPJ", PBJ.Schema.Provider.Name);
cmdDel.AddParameter("@KODEBPJ", varKODEPBJ);
coll.Add(cmdDel);
DataService.ExecuteTransaction(coll);
foreach (System.Web.UI.WebControls.ListItem l in itemList)
{
if (l.Selected)
{
KELENGKAPANPBJ varKELENGKAPANPBJ = new KELENGKAPANPBJ();
varKELENGKAPANPBJ.SetColumnValue("KODEBPJ", varKODEPBJ);
varKELENGKAPANPBJ.SetColumnValue("KODEKELENGKAPAN", l.Value);
varKELENGKAPANPBJ.Save();
}
}
}
public static void SaveAspnetRoleMap(Guid varUserId, System.Web.UI.WebControls.ListItemCollection itemList)
{
QueryCommandCollection coll = new SubSonic.QueryCommandCollection();
//delete out the existing
QueryCommand cmdDel = new QueryCommand("DELETE FROM [aspnet_UsersInRoles] WHERE [aspnet_UsersInRoles].[UserId] = @UserId", AspnetUser.Schema.Provider.Name);
cmdDel.AddParameter("@UserId", varUserId, DbType.Guid);
coll.Add(cmdDel);
DataService.ExecuteTransaction(coll);
foreach (System.Web.UI.WebControls.ListItem l in itemList)
{
if (l.Selected)
{
AspnetUsersInRole varAspnetUsersInRole = new AspnetUsersInRole();
varAspnetUsersInRole.SetColumnValue("UserId", varUserId);
varAspnetUsersInRole.SetColumnValue("RoleId", l.Value);
varAspnetUsersInRole.Save();
}
}
}
public static void SavePageMap(int varRegionId, System.Web.UI.WebControls.ListItemCollection itemList)
{
QueryCommandCollection coll = new SubSonic.QueryCommandCollection();
//delete out the existing
QueryCommand cmdDel = new QueryCommand("DELETE FROM dashCommerce_Content_Page_Region_Map WHERE RegionId=@RegionId", Region.Schema.Provider.Name);
cmdDel.AddParameter("@RegionId", varRegionId);
coll.Add(cmdDel);
DataService.ExecuteTransaction(coll);
foreach (System.Web.UI.WebControls.ListItem l in itemList)
{
if (l.Selected)
{
PageRegionMap varPageRegionMap = new PageRegionMap();
varPageRegionMap.SetColumnValue("RegionId", varRegionId);
varPageRegionMap.SetColumnValue("PageId", l.Value);
varPageRegionMap.Save();
}
}
}
public static void SaveUserMap(int varId, System.Web.UI.WebControls.ListItemCollection itemList)
{
QueryCommandCollection coll = new SubSonic.QueryCommandCollection();
//delete out the existing
QueryCommand cmdDel = new QueryCommand("DELETE FROM [ProjectAssignments] WHERE [ProjectAssignments].[ProjectID] = @ProjectID", Project.Schema.Provider.Name);
cmdDel.AddParameter("@ProjectID", varId, DbType.Int32);
coll.Add(cmdDel);
DataService.ExecuteTransaction(coll);
foreach (System.Web.UI.WebControls.ListItem l in itemList)
{
if (l.Selected)
{
ProjectAssignment varProjectAssignment = new ProjectAssignment();
varProjectAssignment.SetColumnValue("ProjectID", varId);
varProjectAssignment.SetColumnValue("UserID", l.Value);
varProjectAssignment.Save();
}
}
}
public static void SaveContactMap(int varCreditCardID, System.Web.UI.WebControls.ListItemCollection itemList)
{
QueryCommandCollection coll = new SubSonic.QueryCommandCollection();
//delete out the existing
QueryCommand cmdDel = new QueryCommand("DELETE FROM ContactCreditCard WHERE CreditCardID=@CreditCardID", CreditCard.Schema.Provider.Name);
cmdDel.AddParameter("@CreditCardID", varCreditCardID);
coll.Add(cmdDel);
DataService.ExecuteTransaction(coll);
foreach (System.Web.UI.WebControls.ListItem l in itemList)
{
if (l.Selected)
{
ContactCreditCard varContactCreditCard = new ContactCreditCard();
varContactCreditCard.SetColumnValue("CreditCardID", varCreditCardID);
varContactCreditCard.SetColumnValue("ContactID", l.Value);
varContactCreditCard.Save();
}
}
}
public static void SaveTerritoryMap(int varEmployeeID, System.Web.UI.WebControls.ListItemCollection itemList)
{
QueryCommandCollection coll = new SubSonic.QueryCommandCollection();
//delete out the existing
QueryCommand cmdDel = new QueryCommand("DELETE FROM [EmployeeTerritories] WHERE [EmployeeTerritories].[EmployeeID] = @EmployeeID", Employee.Schema.Provider.Name);
cmdDel.AddParameter("@EmployeeID", varEmployeeID, DbType.Int32);
coll.Add(cmdDel);
DataService.ExecuteTransaction(coll);
foreach (System.Web.UI.WebControls.ListItem l in itemList)
{
if (l.Selected)
{
EmployeeTerritory varEmployeeTerritory = new EmployeeTerritory();
varEmployeeTerritory.SetColumnValue("EmployeeID", varEmployeeID);
varEmployeeTerritory.SetColumnValue("TerritoryID", l.Value);
varEmployeeTerritory.Save();
}
}
}
public static void SaveCountryRegionMap(string varCurrencyCode, System.Web.UI.WebControls.ListItemCollection itemList)
{
QueryCommandCollection coll = new SubSonic.QueryCommandCollection();
//delete out the existing
QueryCommand cmdDel = new QueryCommand("DELETE FROM CountryRegionCurrency WHERE CurrencyCode=@CurrencyCode", Currency.Schema.Provider.Name);
cmdDel.AddParameter("@CurrencyCode", varCurrencyCode);
coll.Add(cmdDel);
DataService.ExecuteTransaction(coll);
foreach (System.Web.UI.WebControls.ListItem l in itemList)
{
if (l.Selected)
{
CountryRegionCurrency varCountryRegionCurrency = new CountryRegionCurrency();
varCountryRegionCurrency.SetColumnValue("CurrencyCode", varCurrencyCode);
varCountryRegionCurrency.SetColumnValue("CountryRegionCode", l.Value);
varCountryRegionCurrency.Save();
}
}
}
public static void SaveProductMap(int varCategoryID, System.Web.UI.WebControls.ListItemCollection itemList)
{
QueryCommandCollection coll = new SubSonic.QueryCommandCollection();
//delete out the existing
QueryCommand cmdDel = new QueryCommand("DELETE FROM [Product_Category_Map] WHERE [Product_Category_Map].[CategoryID] = @CategoryID", Category.Schema.Provider.Name);
cmdDel.AddParameter("@CategoryID", varCategoryID, DbType.Int32);
coll.Add(cmdDel);
DataService.ExecuteTransaction(coll);
foreach (System.Web.UI.WebControls.ListItem l in itemList)
{
if (l.Selected)
{
ProductCategoryMap varProductCategoryMap = new ProductCategoryMap();
varProductCategoryMap.SetColumnValue("CategoryID", varCategoryID);
varProductCategoryMap.SetColumnValue("ProductID", l.Value);
varProductCategoryMap.Save();
}
}
}
public static void SaveAddressMap(int varEmployeeID, System.Web.UI.WebControls.ListItemCollection itemList)
{
QueryCommandCollection coll = new SubSonic.QueryCommandCollection();
//delete out the existing
QueryCommand cmdDel = new QueryCommand("DELETE FROM EmployeeAddress WHERE EmployeeID=@EmployeeID", Employee.Schema.Provider.Name);
cmdDel.AddParameter("@EmployeeID", varEmployeeID);
coll.Add(cmdDel);
DataService.ExecuteTransaction(coll);
foreach (System.Web.UI.WebControls.ListItem l in itemList)
{
if (l.Selected)
{
EmployeeAddress varEmployeeAddress = new EmployeeAddress();
varEmployeeAddress.SetColumnValue("EmployeeID", varEmployeeID);
varEmployeeAddress.SetColumnValue("AddressID", l.Value);
varEmployeeAddress.Save();
}
}
}
public static void SaveCustomerMap(string varCustomerTypeID, System.Web.UI.WebControls.ListItemCollection itemList)
{
QueryCommandCollection coll = new SubSonic.QueryCommandCollection();
//delete out the existing
QueryCommand cmdDel = new QueryCommand("DELETE FROM [CustomerCustomerDemo] WHERE [CustomerCustomerDemo].[CustomerTypeID] = PARM__CustomerTypeID", CustomerDemographic.Schema.Provider.Name);
cmdDel.AddParameter("PARM__CustomerTypeID", varCustomerTypeID, DbType.String);
coll.Add(cmdDel);
DataService.ExecuteTransaction(coll);
foreach (System.Web.UI.WebControls.ListItem l in itemList)
{
if (l.Selected)
{
CustomerCustomerDemo varCustomerCustomerDemo = new CustomerCustomerDemo();
varCustomerCustomerDemo.SetColumnValue("CustomerTypeID", varCustomerTypeID);
varCustomerCustomerDemo.SetColumnValue("CustomerID", l.Value);
varCustomerCustomerDemo.Save();
}
}
}
public static void SaveVendorMap(string varUnitMeasureCode, System.Web.UI.WebControls.ListItemCollection itemList)
{
QueryCommandCollection coll = new SubSonic.QueryCommandCollection();
//delete out the existing
QueryCommand cmdDel = new QueryCommand("DELETE FROM ProductVendor WHERE UnitMeasureCode=@UnitMeasureCode", UnitMeasure.Schema.Provider.Name);
cmdDel.AddParameter("@UnitMeasureCode", varUnitMeasureCode);
coll.Add(cmdDel);
DataService.ExecuteTransaction(coll);
foreach (System.Web.UI.WebControls.ListItem l in itemList)
{
if (l.Selected)
{
ProductVendor varProductVendor = new ProductVendor();
varProductVendor.SetColumnValue("UnitMeasureCode", varUnitMeasureCode);
varProductVendor.SetColumnValue("VendorID", l.Value);
varProductVendor.Save();
}
}
}
