/// <summary>
/// Public Method user to get User security code
/// </summary>
/// <param name="userName">Parameter:username</param>
/// <returns>User security code</returns>
public string GetSecurityCode(string userName, MaintenaceTable moduleType)
{
try
{
#region Create where clause based on module type
string whereClause = string.Empty;
switch (moduleType)
{
case MaintenaceTable.OrganisationComments:
whereClause = "' AND (SG.groupname='MAINTENANCE (W)' OR SG.groupname='OrgComm (W)')";
break;
default:
whereClause = "' AND SG.groupname='MAINTENANCE (W)' ";
break;
}
#endregion
object objSecurityCode = (object)SqlHelper.ExecuteScalar(connectionString, "pSOESelect",
new SqlParameter("@tableName", securityTable),
new SqlParameter("@columnNames", "SG.groupname as GroupName"),
new SqlParameter("@whereClause", "SM.SecGroupID = SG.pSecGroupID and SM.SecUserID= SU.pSecUserID and SU.UserName='" + userName + whereClause));
if (objSecurityCode != null)
{
return(objSecurityCode.ToString().Trim());
}
else
{
return("");
}
}
catch (Exception Ex) { return(""); }
}
public bool CheckDataExist(string code, MaintenaceTable maintenaceTable)
{
string whereClause = "StdCommentsCd='" + code + "'";
DataSet dsCarrierCode = SqlHelper.ExecuteDataset(connectionString, "pSOESelect",
new SqlParameter("@tableName", "[StandardComments]"),
new SqlParameter("@columnNames", "StdCommentsCd"),
new SqlParameter("@whereClause", whereClause));
if (dsCarrierCode.Tables[0].Rows.Count > 0)
{
return(false);
}
else
{
return(true);
}
}
/// <summary>
/// Public Method user to get User security code
/// </summary>
/// <param name="userName">Parameter:username</param>
/// <returns>User security code</returns>
public string GetSecurityCode(string userName, MaintenaceTable moduleType)
{
try
{
#region Create where clause based on module type
string whereClause = string.Empty;
switch (moduleType)
{
case MaintenaceTable.AppPref:
whereClause = "' AND (SG.groupname='MAINTENANCE (W)' OR SG.groupname='AppPref (W)')";
break;
case MaintenaceTable.BillOfMaterials:
whereClause = "' AND (SG.groupname='ADMIN (W)' OR SG.groupname='MAINTENANCE (W)' OR SG.groupname='BOM (W)')";
break;
case MaintenaceTable.CarrierCodes:
whereClause = "' AND (SG.groupname='MAINTENANCE (W)' OR SG.groupname='CarrierCd (W)')";
break;
case MaintenaceTable.CategoryBuyGroups:
whereClause = "' AND (SG.groupname='MAINTENANCE (W)' OR SG.groupname='CatBuyGrpMaint (W)')";
break;
case MaintenaceTable.ClassofTrade:
whereClause = "' AND (SG.groupname='MAINTENANCE (W)' OR SG.groupname='Trd (W)')";
break;
case MaintenaceTable.CustomerActivity:
whereClause = "' AND (SG.groupname='MAINTENANCE (W)')";
break;
case MaintenaceTable.CustomerContract:
whereClause = "' AND (SG.groupname='MAINTENANCE (W)' OR SG.groupname='CustContMaint (W)')";
break;
case MaintenaceTable.CustomerType:
whereClause = "' AND (SG.groupname='MAINTENANCE (W)' OR SG.groupname='Ctyp (W)')";
break;
case MaintenaceTable.CustPriceSchedMaint:
whereClause = "' AND (SG.groupname='ADMIN (W)' OR SG.groupname='MAINTENANCE (W)' OR SG.groupname='CustPriceMaint (W)')";
break;
case MaintenaceTable.ExpediteCodes:
whereClause = "' AND (SG.groupname='MAINTENANCE (W)' OR SG.groupname='Expd (W)')";
break;
case MaintenaceTable.ExpenseCodes:
whereClause = "' AND (SG.groupname='MAINTENANCE (W)' OR SG.groupname='Expense(W)')";
break;
case MaintenaceTable.FiscalPeriod:
whereClause = "' AND (SG.groupname='MAINTENANCE (W)' OR SG.groupname='Fiscal(W)')";
break;
case MaintenaceTable.FormMessage:
whereClause = "' AND (SG.groupname='MAINTENANCE (W)' OR SG.groupname='FormMsg (W)')";
break;
case MaintenaceTable.FreightAddr:
whereClause = "' AND (SG.groupname='ADMIN (W)' OR SG.groupname='MAINTENANCE (W)' OR SG.groupname='FghtAdd')";
break;
case MaintenaceTable.FreightTerms:
whereClause = "' AND (SG.groupname='MAINTENANCE (W)' OR SG.groupname='Fght (W)')";
break;
case MaintenaceTable.GLAccount:
whereClause = "' AND (SG.groupname='MAINTENANCE (W)' OR SG.groupname='GLAcct (W)')";
break;
case MaintenaceTable.GLPosting:
whereClause = "' AND (SG.groupname='MAINTENANCE (W)' OR SG.groupname='GLPost (W)')";
break;
case MaintenaceTable.ItemAlias:
whereClause = "' AND (SG.groupname='ItemAliasXref (W)')";
break;
case MaintenaceTable.OrganisationComments:
whereClause = "' AND (SG.groupname='MAINTENANCE (W)' OR SG.groupname='OrgComm (W)')";
break;
case MaintenaceTable.PriorityCodes:
whereClause = "' AND (SG.groupname='MAINTENANCE (W)' OR SG.groupname='Pri (W)')";
break;
case MaintenaceTable.ReasonCodes:
whereClause = "' AND (SG.groupname='MAINTENANCE (W)' OR SG.groupname='Reas (W)')";
break;
case MaintenaceTable.RepClass:
whereClause = "' AND (SG.groupname='MAINTENANCE (W)' OR SG.groupname='Rpcl (W)')";
break;
case MaintenaceTable.RepMaster:
whereClause = "' AND (SG.groupname='MAINTENANCE (W)' OR SG.groupname='ADMIN (W)' OR SG.groupname='RepMasterMaint (W)' )";
break;
case MaintenaceTable.SecurityGroups:
whereClause = "' AND (SG.groupname='MAINTENANCE (W)' OR SG.groupname='Security (W)')";
break;
case MaintenaceTable.ShipMethod:
whereClause = "' AND (SG.groupname='MAINTENANCE (W)' OR SG.groupname='Ship (W)')";
break;
case MaintenaceTable.StandardComments:
whereClause = "' AND (SG.groupname='MAINTENANCE (W)' OR SG.groupname='StdComm (W)')";
break;
case MaintenaceTable.SubItemAlias:
whereClause = "' AND (SG.groupname='SubItem (W)')";
break;
case MaintenaceTable.TermsCodes:
whereClause = "' AND (SG.groupname='MAINTENANCE (W)' OR SG.groupname='Term (W)')";
break;
case MaintenaceTable.WarningMessages:
whereClause = "' AND (SG.groupname='MAINTENANCE (W)' OR SG.groupname='WarnMsg (W)')";
break;
case MaintenaceTable.WebCatDisc:
whereClause = "' AND (SG.groupname='MAINTENANCE (W)' OR SG.groupname='WebCat (W)')";
break;
case MaintenaceTable.CatPriceSchedMaintAccess:
whereClause = "' AND (SG.groupname='CustCatPriceMaint (W)')";
break;
case MaintenaceTable.CatPriceSchedMaintApproval:
whereClause = "' AND (SG.groupname='CustCatPriceApprove (W)')";
break;
default:
whereClause = "' AND SG.groupname='MAINTENANCE (W)' ";
break;
}
#endregion
object objSecurityCode = (object)SqlHelper.ExecuteScalar(connectionString, "pSOESelect",
new SqlParameter("@tableName", securityTable),
new SqlParameter("@columnNames", "SG.groupname as GroupName"),
new SqlParameter("@whereClause", "SM.SecGroupID = SG.pSecGroupID and SM.SecUserID = SU.pSecUserID and (SU.DeleteDt is null or SU.DeleteDt = '') and (SM.DeleteDt is null or SM.DeleteDt = '') and (SG.DeleteDt is null or SG.DeleteDt = '') and SU.UserName='" + userName + whereClause));
if (objSecurityCode != null)
{
return(objSecurityCode.ToString().Trim());
}
else
{
return("");
}
}
catch (Exception Ex) { return(""); }
}
public bool CheckDataExist(string code, MaintenaceTable maintenaceTable)
{
#region Create where clause based on module type
string whereClause = "TableCd='" + code + "'";
switch (maintenaceTable)
{
case MaintenaceTable.AppPref:
whereClause = whereClause;
break;
case MaintenaceTable.CarrierCodes:
whereClause += " AND TableType='CAR'";
break;
case MaintenaceTable.ClassofTrade:
whereClause += " AND TableType='TRD'";
break;
//case MaintenaceTable.CustomerType:
// whereClause += " AND TableType='CTYP'";
// break;
case MaintenaceTable.ExpediteCodes:
whereClause += " AND TableType='EXPD'";
break;
//case MaintenaceTable.FreightAddr:
// whereClause += " AND TableType='FGHTADD'";
// break;
case MaintenaceTable.FreightTerms:
whereClause += " AND TableType='FGHT'";
break;
case MaintenaceTable.PriorityCodes:
whereClause += " AND TableType='PRI'";
break;
case MaintenaceTable.ReasonCodes:
whereClause += " AND TableType='REAS'";
break;
case MaintenaceTable.RepClass:
whereClause += " AND TableType='RPCL'";
break;
//case MaintenaceTable.SecurityGroups:
// whereClause += " AND TableType='SEC'";
// break;
//case MaintenaceTable.ShipMethod:
// whereClause += " AND TableType='SHIP'";
// break;
case MaintenaceTable.WarningMessages:
whereClause += " AND TableType='WM'";
break;
//case MaintenaceTable.WebCatDisc:
// whereClause += " AND TableType='WebCat'";
// break;
default:
whereClause = whereClause;
break;
}
#endregion
DataSet dsCarrierCode = SqlHelper.ExecuteDataset(connectionString, "pSOESelect",
new SqlParameter("@tableName", "[Tables]"),
new SqlParameter("@columnNames", "TableCd"),
new SqlParameter("@whereClause", whereClause));
if (dsCarrierCode.Tables[0].Rows.Count > 0)
{
return(false);
}
else
{
return(true);
}
}
/// <summary>
/// Public Method user to get User security code
/// </summary>
/// <param name="userName">Parameter:username</param>
/// <returns>User security code</returns>
public string GetSecurityCode(string userName, MaintenaceTable moduleType)
{
try
{
#region Create where clause based on module type
string whereClause = string.Empty;
switch (moduleType)
{
case MaintenaceTable.AppPref:
whereClause = "' AND (SG.groupname='MAINTENANCE (W)' OR SG.groupname='AppPref (W)')";
break;
case MaintenaceTable.BillOfMaterials:
whereClause = "' AND (SG.groupname='ADMIN (W)' OR SG.groupname='MAINTENANCE (W)' OR SG.groupname='BOM (W)')";
break;
case MaintenaceTable.CarrierCodes:
whereClause = "' AND (SG.groupname='MAINTENANCE (W)' OR SG.groupname='CarrierCd (W)')";
break;
case MaintenaceTable.CategoryBuyGroups:
whereClause = "' AND (SG.groupname='MAINTENANCE (W)' OR SG.groupname='CatBuyGrpMaint (W)')";
break;
case MaintenaceTable.ClassofTrade:
whereClause = "' AND (SG.groupname='MAINTENANCE (W)' OR SG.groupname='Trd (W)')";
break;
case MaintenaceTable.CustomerActivity:
whereClause = "' AND (SG.groupname='MAINTENANCE (W)')";
break;
case MaintenaceTable.CustomerContract:
whereClause = "' AND (SG.groupname='MAINTENANCE (W)' OR SG.groupname='CustContMaint (W)')";
break;
case MaintenaceTable.CustomerType:
whereClause = "' AND (SG.groupname='MAINTENANCE (W)' OR SG.groupname='Ctyp (W)')";
break;
case MaintenaceTable.CustPriceSchedMaint:
whereClause = "' AND (SG.groupname='ADMIN (W)' OR SG.groupname='MAINTENANCE (W)' OR SG.groupname='CustPriceMaint (W)')";
break;
case MaintenaceTable.ExpediteCodes:
whereClause = "' AND (SG.groupname='MAINTENANCE (W)' OR SG.groupname='Expd (W)')";
break;
case MaintenaceTable.ExpenseCodes:
whereClause = "' AND (SG.groupname='MAINTENANCE (W)' OR SG.groupname='Expense(W)')";
break;
case MaintenaceTable.FiscalPeriod:
whereClause = "' AND (SG.groupname='MAINTENANCE (W)' OR SG.groupname='Fiscal(W)')";
break;
case MaintenaceTable.FormMessage:
whereClause = "' AND (SG.groupname='MAINTENANCE (W)' OR SG.groupname='FormMsg (W)')";
break;
case MaintenaceTable.FreightAddr:
whereClause = "' AND (SG.groupname='ADMIN (W)' OR SG.groupname='MAINTENANCE (W)' OR SG.groupname='FghtAdd')";
break;
case MaintenaceTable.FreightTerms:
whereClause = "' AND (SG.groupname='MAINTENANCE (W)' OR SG.groupname='Fght (W)')";
break;
case MaintenaceTable.GLAccount:
whereClause = "' AND (SG.groupname='MAINTENANCE (W)' OR SG.groupname='GLAcct (W)')";
break;
case MaintenaceTable.GLPosting:
whereClause = "' AND (SG.groupname='MAINTENANCE (W)' OR SG.groupname='GLPost (W)')";
break;
case MaintenaceTable.ItemAlias:
whereClause = "' AND (SG.groupname='ItemAliasXref (W)')";
break;
case MaintenaceTable.IMFastMaint: //Item Fast Maintenance
whereClause = "' AND (SG.groupname='ADMIN (W)' OR SG.groupname='IMFM (W)')";
break;
case MaintenaceTable.ItemMaintenance3: //ItemMaintenance Level 3: Query, Change & Copy
whereClause = "' AND (SG.groupname='ADMIN (W)' OR SG.groupname='MAINTENANCE (W)' OR SG.groupname='IMMC (W)')";
break;
case MaintenaceTable.ItemMaintenance2: //ItemMaintenance Level 2: Query & Change - No Copy
whereClause = "' AND (SG.groupname='IMM (W)')";
break;
case MaintenaceTable.ItemMaintenance1: //ItemMaintenance Level 1: Query Only - No Change or Copy
whereClause = "' AND (SG.groupname='IMM (Q)')";
break;
case MaintenaceTable.ItemNotes: //ItemNotes Maintenance
whereClause = "' AND (SG.groupname='ADMIN (W)' OR SG.groupname='MAINTENANCE (W)' OR SG.groupname='IMN (W)')";
break;
case MaintenaceTable.OrganisationComments:
whereClause = "' AND (SG.groupname='MAINTENANCE (W)' OR SG.groupname='OrgComm (W)')";
break;
case MaintenaceTable.PriorityCodes:
whereClause = "' AND (SG.groupname='MAINTENANCE (W)' OR SG.groupname='Pri (W)')";
break;
case MaintenaceTable.ReasonCodes:
whereClause = "' AND (SG.groupname='MAINTENANCE (W)' OR SG.groupname='Reas (W)')";
break;
case MaintenaceTable.RepClass:
whereClause = "' AND (SG.groupname='MAINTENANCE (W)' OR SG.groupname='Rpcl (W)')";
break;
case MaintenaceTable.RepMaster:
whereClause = "' AND (SG.groupname='MAINTENANCE (W)' OR SG.groupname='ADMIN (W)' OR SG.groupname='RepMasterMaint (W)' )";
break;
case MaintenaceTable.SecurityGroups:
whereClause = "' AND (SG.groupname='MAINTENANCE (W)' OR SG.groupname='Security (W)' OR SG.groupname='USEC (W)')";
break;
case MaintenaceTable.ShipMethod:
whereClause = "' AND (SG.groupname='MAINTENANCE (W)' OR SG.groupname='Ship (W)')";
break;
case MaintenaceTable.StandardComments:
whereClause = "' AND (SG.groupname='MAINTENANCE (W)' OR SG.groupname='StdComm (W)')";
break;
case MaintenaceTable.SubItemAlias:
whereClause = "' AND (SG.groupname='SubItem (W)')";
break;
case MaintenaceTable.TermsCodes:
whereClause = "' AND (SG.groupname='MAINTENANCE (W)' OR SG.groupname='Term (W)')";
break;
case MaintenaceTable.WarningMessages:
whereClause = "' AND (SG.groupname='MAINTENANCE (W)' OR SG.groupname='WarnMsg (W)')";
break;
case MaintenaceTable.WebCatDisc:
whereClause = "' AND (SG.groupname='MAINTENANCE (W)' OR SG.groupname='WebCat (W)')";
break;
case MaintenaceTable.CatPriceSchedMaintAccess:
whereClause = "' AND (SG.groupname='CustCatPriceMaint (W)')";
break;
case MaintenaceTable.CatPriceSchedMaintApproval:
whereClause = "' AND (SG.groupname='CustCatPriceApprove (W)')";
break;
case MaintenaceTable.CatPriceSchedMaintSetCost:
whereClause = "' AND (SG.groupname='CustPrCst (W)')";
break;
case MaintenaceTable.CatPriceSchedulePKGOption:
whereClause = "' AND (SG.groupname='CCMPK')";
break;
case MaintenaceTable.ShipListMaintAccess:
whereClause = "' AND (SG.groupname='SHPLM (W)')";
break;
case MaintenaceTable.PriceAnalysisReportAccess:
whereClause = "' AND (SG.groupname='CPSMA (Q)')";
break;
case MaintenaceTable.PriceCostOverlayAccess:
whereClause = "' AND (SG.groupname='PCOMA (W)')";
break;
case MaintenaceTable.PriceAnalysisShowAvgCost:
whereClause = "' AND (SG.groupname='PAAVG (Q)')";
break;
case MaintenaceTable.UserMaster1: //UserMaster level 1: ADMIN only - access page no security groups
whereClause = "' AND (SG.groupname='ADMIN (W)')";
break;
case MaintenaceTable.UserMaster2: //UserMaster level 2: ADMIN & USEC - access page & security groups
whereClause = "' AND (SG.groupname='USEC (W)')";
break;
case MaintenaceTable.CustomerContractLoader:
whereClause = "' AND (SG.groupname='CustCont (Q)')";
break;
case MaintenaceTable.CustomerPriceRanking:
whereClause = "' AND (SG.groupname='CPR (W)')";
break;
default:
whereClause = "' AND SG.groupname='MAINTENANCE (W)' ";
break;
}
#endregion
object objSecurityCode = (object)SqlHelper.ExecuteScalar(connectionString, "pSOESelect",
new SqlParameter("@tableName", securityTable),
new SqlParameter("@columnNames", "SG.groupname as GroupName"),
new SqlParameter("@whereClause", "SM.SecGroupID = SG.pSecGroupID and SM.SecUserID = SU.pSecUserID and (SU.DeleteDt is null or SU.DeleteDt = '') and (SM.DeleteDt is null or SM.DeleteDt = '') and (SG.DeleteDt is null or SG.DeleteDt = '') and SU.UserName='" + userName + whereClause));
if (objSecurityCode != null)
{
return(objSecurityCode.ToString().Trim());
}
else
{
return("");
}
}
catch (Exception Ex) { return(""); }
}
