protected override void DropDownFilter(Durados.Web.Mvc.ParentField parentField, ref string sql)
{
Durados.View view = parentField.ParentView;
if ((new string[5] {
"Issue", "Project", "User", "TimeSheet", "MonthlyProjectHoursReport"
}).Contains(view.Name))
{
if (User.IsInRole("User"))
{
if (User == null || User.Identity == null || User.Identity.Name == null)
{
throw new AccessViolationException();
}
int?companyID = Durados.Web.Mvc.Specifics.DataAccess.User.GetCompanyID(User.Identity.Name);
if (!companyID.HasValue)
{
throw new AccessViolationException();
}
sql += " where CompanyID = " + companyID.Value;
}
}
}
protected override void DropDownFilter(Durados.Web.Mvc.ParentField parentField, ref string sql)
{
if (parentField.View.Name != "MemRequest_WaferSupply")
{
return;
}
if (parentField.ParentView.Name != "v_WaferSupply")
{
return;
}
int?memRequestID = GetMemRequestID();
if (memRequestID.HasValue)
{
int?mdeID = GetMdeID(memRequestID.Value);
if (mdeID.HasValue)
{
string filter = GetWaferSupplyFilter(mdeID.Value, sql);
if (!string.IsNullOrEmpty(filter))
{
sql += filter;
}
}
}
}
protected override void DropDownFilter(Durados.Web.Mvc.ParentField parentField, ref string sql)
{
Durados.View view = parentField.ParentView;
if (view.Name == CRMViews.CountryType.ToString())
{
sql += " where Active = 1";
}
}
protected override void DropDownFilter(Durados.Web.Mvc.ParentField parentField, ref string sql)
{
Durados.View view = parentField.ParentView;
if (Durados.Web.Mvc.UI.Helpers.SecurityHelper.IsInRole("User") && view.Name == "User")
{
if (User == null || User.Identity == null || User.Identity.Name == null)
{
throw new AccessViolationException();
}
sql += " where Username = N'" + User.Identity.Name + "'";
}
}
protected override void DropDownFilter(Durados.Web.Mvc.ParentField parentField, ref string sql)
{
Durados.View view = parentField.ParentView;
if (User.IsInRole("User") && view.Name == "User")
{
if (User == null || User.Identity == null || User.Identity.Name == null)
{
throw new AccessViolationException();
}
if (!sql.ToLower().Contains("where"))
{
sql += " where Username = N'" + User.Identity.Name + "'";
}
}
}
protected override void DropDownFilter(Durados.Web.Mvc.ParentField parentField, ref string sql)
{
base.DropDownFilter(parentField, ref sql);
Durados.View view = parentField.ParentView;
if (view.Name == "Issue")
{
if (sql.ToLower().Contains("where"))
{
sql += " and [Issue].[TimeEstimate] > 0";
}
else
{
sql += "where [Issue].[TimeEstimate] > 0";
}
}
}
protected override void DropDownFilter(Durados.Web.Mvc.ParentField parentField, ref string sql)
{
Durados.View view = parentField.ParentView;
if ((new string[1] {
"A_111"
}).Contains(view.Name))
{
if (User.IsInRole("User"))
{
if (User == null || User.Identity == null || User.Identity.Name == null)
{
throw new AccessViolationException();
}
sql += " where sochen_1 = N'" + User.Identity.Name + "'";
}
}
}
protected override void DropDownFilter(Durados.Web.Mvc.ParentField parentField, ref string sql)
{
Durados.View view = parentField.ParentView;
if ((new string[6] {
"Issue", "Project", "User", "TimeSheet", "MonthlyProjectHoursReport", "Company"
}).Contains(view.Name))
{
if (Durados.Web.Mvc.UI.Helpers.SecurityHelper.IsInRole("User"))
{
if (User == null || User.Identity == null || User.Identity.Name == null)
{
throw new AccessViolationException();
}
int?companyID = DataAccess.User.GetCompanyID(User.Identity.Name);
if (!companyID.HasValue)
{
throw new AccessViolationException();
}
if (view.Name == "Company")
{
sql += " where ID = " + companyID.Value;
}
else if (sql.IndexOf("CompanyID") < 0)
{
if (sql.ToLower().Contains("where"))
{
sql += " and CompanyID = " + companyID.Value;
}
else
{
sql += " where CompanyID = " + companyID.Value;
}
}
}
}
}
