public void SaveServiceItem(AspxCommonInfo aspxCommonObj, int categoryId, List <ServiceItemInfo> serviceInfo)
{
OracleHandler sqlH = new OracleHandler();
OracleTransaction tran;
tran = (OracleTransaction)sqlH.GetTransaction();
try
{
AspxServiceProvider.SaveServiceItem(aspxCommonObj, categoryId, serviceInfo, tran);
tran.Commit();
}
catch (Exception e)
{
tran.Rollback();
throw e;
}
}
public static void AddMenuPermission(List<MenuPermissionInfo> lstMenuPermissions, int MenuID, int PortalID)
{
OracleHandler sagesql = new OracleHandler();
OracleTransaction tran = (OracleTransaction)sagesql.GetTransaction();
try
{
string sp = "usp_MenuMgrMenuPermissionDelete";
List<KeyValuePair<string, object>> ParaMeterColl = new List<KeyValuePair<string, object>>
{
new KeyValuePair<string, object>("MenuID",
MenuID),
new KeyValuePair<string, object>("PortalID",
PortalID)
};
sagesql.ExecuteNonQuery(tran, CommandType.StoredProcedure, sp,
ParaMeterColl);
foreach (MenuPermissionInfo menu in lstMenuPermissions)
{
List<KeyValuePair<string, object>> ParamCollInput = new List<KeyValuePair<string, object>>();
ParamCollInput.Add(new KeyValuePair<string, object>("MenuID", MenuID));
ParamCollInput.Add(new KeyValuePair<string, object>("PermissionID", menu.PermissionID));
ParamCollInput.Add(new KeyValuePair<string, object>("AllowAccess", menu.AllowAccess));
ParamCollInput.Add(new KeyValuePair<string, object>("RoleId", menu.RoleID == null ? Guid.Empty : new Guid(menu.RoleID)));
ParamCollInput.Add(new KeyValuePair<string, object>("UserName", menu.Username));
ParamCollInput.Add(new KeyValuePair<string, object>("PortalID", PortalID));
sagesql.ExecuteNonQuery(tran, CommandType.StoredProcedure, "usp_MenuMgrAddMenuPermission", ParamCollInput);
}
tran.Commit();
}
catch (Exception)
{
tran.Rollback();
throw;
}
}
public static void AddNewMenu(List<MenuPermissionInfo> lstMenuPermissions, string MenuName, string MenuType, bool IsDefault, int PortalID)
{
string sp = "usp_MenuMgrAddNewMenu";
OracleHandler sagesql = new OracleHandler();
int MenuID = 0;
//SqlTransaction tran = (SqlTransaction)sagesql.GetTransaction();
OracleTransaction tran = (OracleTransaction)sagesql.GetTransaction();
try
{
List<KeyValuePair<string, object>> ParamCollInput = new List<KeyValuePair<string, object>>();
ParamCollInput.Add(new KeyValuePair<string, object>("MenuName", MenuName));
ParamCollInput.Add(new KeyValuePair<string, object>("MenuType", MenuType));
ParamCollInput.Add(new KeyValuePair<string, object>("IsDefault", IsDefault));
ParamCollInput.Add(new KeyValuePair<string, object>("PortalID", PortalID));
MenuID = sagesql.ExecuteNonQuery(sp, ParamCollInput, "MenuID");
foreach (MenuPermissionInfo menu in lstMenuPermissions)
{
List<KeyValuePair<string, object>> ParamColl = new List<KeyValuePair<string, object>>();
ParamColl.Add(new KeyValuePair<string, object>("MenuID", MenuID));
ParamColl.Add(new KeyValuePair<string, object>("PermissionID", menu.PermissionID));
ParamColl.Add(new KeyValuePair<string, object>("AllowAccess", menu.AllowAccess));
ParamColl.Add(new KeyValuePair<string, object>("RoleId", menu.RoleID == null ? Guid.Empty : new Guid(menu.RoleID)));
ParamColl.Add(new KeyValuePair<string, object>("UserName", menu.Username));
ParamColl.Add(new KeyValuePair<string, object>("PortalID", PortalID));
sagesql.ExecuteNonQuery(tran, CommandType.StoredProcedure, "usp_MenuMgrAddMenuPermission", ParamColl);
}
tran.Commit();
}
catch (Exception)
{
throw;
}
}
public static int SaveCartPricingRule(CartPricingRuleInfo objCartPriceRule, AspxCommonInfo aspxCommonObj, List<int> parentID)
{
OracleHandler sqlH = new OracleHandler();
OracleTransaction tran;
tran = (OracleTransaction)sqlH.GetTransaction();
try
{
int cartPriceRuleID = -1;
cartPriceRuleID = AspxCartPriceRuleProvider.CartPriceRuleAdd(objCartPriceRule.CartPriceRule, tran, aspxCommonObj);
AspxCartPriceRuleProvider.RuleConditionAdd(objCartPriceRule.LstRuleCondition, cartPriceRuleID, parentID, tran, aspxCommonObj);
foreach (CartPriceRuleRole cartPriceRuleRole in objCartPriceRule.LstCartPriceRuleRoles)
{
cartPriceRuleRole.CartPriceRuleID = cartPriceRuleID;
AspxCartPriceRuleProvider.CartPriceRuleRoleAdd(cartPriceRuleRole, tran, aspxCommonObj);
}
//foreach (CartPriceRuleStore cartPriceRuleStore in objCartPriceRule.LstCartPriceRuleStores)
//{
// cartPriceRuleStore.CartPriceRuleID = cartPriceRuleID;
// AspxCartPriceRuleProvider.CartPriceRuleStoreAdd(cartPriceRuleStore, tran, aspxCommonObj);
//}
tran.Commit();
return cartPriceRuleID;
}
catch (OracleException sqlEX)
{
tran.Rollback();
throw new ArgumentException(sqlEX.Message);
}
catch (Exception ex)
{
tran.Rollback();
throw ex;
}
}
public static void UpdateUserModule(UserModuleInfo module)
{
//SQLHandler sqlH = new SQLHandler();
OracleHandler sqlH = new OracleHandler();
OracleTransaction tran = (OracleTransaction)sqlH.GetTransaction();
try
{
List <KeyValuePair <string, object> > ParaMeterCollection = new List <KeyValuePair <string, object> >
{
new KeyValuePair <string, object>(
"UserModuleID", module.UserModuleID),
new KeyValuePair <string, object>(
"ModuleDefID", module.ModuleDefID),
new KeyValuePair <string, object>(
"UserModuleTitle", module.UserModuleTitle),
new KeyValuePair <string, object>(
"AllPages", module.AllPages),
new KeyValuePair <string, object>(
"ShowInPages", module.ShowInPages),
new KeyValuePair <string, object>(
"InheritViewPermissions", module.InheritViewPermissions),
new KeyValuePair <string, object>(
"IsActive", module.IsActive),
new KeyValuePair <string, object>(
"AddedOn", DateTime.Now),
new KeyValuePair <string, object>(
"PortalID", module.PortalID),
new KeyValuePair <string, object>(
"AddedBy", module.PortalID),
new KeyValuePair <string, object>(
"SEOName", module.SEOName),
new KeyValuePair <string, object>(
"IsHandheld", module.IsHandheld),
new KeyValuePair <string, object>(
"SuffixClass", module.SuffixClass),
new KeyValuePair <string, object>(
"HeaderText", module.HeaderText),
new KeyValuePair <string, object>(
"ShowHeaderText", module.ShowHeaderText)
};
sqlH.ExecuteNonQuery(tran, CommandType.StoredProcedure, "usp_UserModulesUpdate", ParaMeterCollection);
if (module.InheritViewPermissions)
{
UpdateUserModuleInheritedPermission(module.PageID, tran, module.UserModuleID, module.PortalID, module.AddedBy, module.ModuleDefID);
}
else
{
UpdateUserModulePermission(module.LSTUserModulePermission, tran, module.UserModuleID, module.PortalID, module.AddedBy, module.ModuleDefID);
}
tran.Commit();
}
catch (OracleException sqlEx)
{
tran.Rollback();
throw sqlEx;
}
catch (Exception ex)
{
throw ex;
}
}