public static CascadingDropDownNameValue[] GetSegmentsPageMethod(string knownCategoryValues, string category)
{
StringDictionary kv = CascadingDropDown.ParseKnownCategoryValuesString(knownCategoryValues);
int workshopID;
if (kv.ContainsKey("WorkshopCode"))
{
List <CascadingDropDownNameValue> values =
new List <CascadingDropDownNameValue>();
if (Int32.TryParse(kv["WorkshopCode"], out workshopID))
{
List <Segment> segmentList = GlobalService.GetSegmentbyWorkshopID(workshopID);
values.Add(new CascadingDropDownNameValue(Consts.DROPDOWN_UNSELECTED_TEXT, string.Empty));
foreach (var item in segmentList)
{
values.Add(new CascadingDropDownNameValue(item.SegmentCode, item.SegmentID.ToString()));
}
}
return(values.ToArray());
}
else
{
return(null);
}
}
public CascadingDropDownNameValue[] GetModels(string knownCategoryValues, string category)
{
int BrandID;
CascadingDropDown.ParseKnownCategoryValuesString(knownCategoryValues);
StringDictionary kv = CascadingDropDown.ParseKnownCategoryValuesString(knownCategoryValues);
if (!kv.ContainsKey("Brands") || !Int32.TryParse(kv["Brands"], out BrandID))
{
throw new ArgumentException("Couldn't find brand.");
}
connection.Open();
SqlCommand comm = new SqlCommand("SELECT ID, Name FROM Models WHERE (Brands_ID = @brandID) AND Status=1 ORDER BY Name", connection);
comm.Parameters.AddWithValue("@brandID", BrandID);
SqlDataReader dr = comm.ExecuteReader();
List <CascadingDropDownNameValue> l = new List <CascadingDropDownNameValue>();
while (dr.Read())
{
l.Add(new CascadingDropDownNameValue(dr["Name"].ToString(), dr["ID"].ToString()));
}
connection.Close();
return(l.ToArray());
}
public CascadingDropDownNameValue[] CascDD2Call(string knownCategoryValues, string category)
{
StringDictionary DD1NameValue = CascadingDropDown.ParseKnownCategoryValuesString(knownCategoryValues);
string CascDD1Value = DD1NameValue["CascDD1"];
//Can write SQL query to pull data based on DD1
List <CascadingDropDownNameValue> CascDD2NV = new List <CascadingDropDownNameValue>();
if (CascDD1Value == "A")
{
CascDD2NV.Add(new CascadingDropDownNameValue("A1", "A1"));
CascDD2NV.Add(new CascadingDropDownNameValue("A2", "A2"));
}
else if (CascDD1Value == "B")
{
CascDD2NV.Add(new CascadingDropDownNameValue("B1", "B1"));
CascDD2NV.Add(new CascadingDropDownNameValue("B2", "B2"));
}
//string country = CascadingDropDown.ParseKnownCategoryValuesString(knownCategoryValues)["CountryId"];
//string query = string.Format("SELECT StateName, StateId FROM States WHERE CountryId = {0}", country);
//List<CascadingDropDownNameValue> states = GetData(query);
//return states.ToArray();
return(CascDD2NV.ToArray());
}
public static CascadingDropDownNameValue[] GetWorkshopsPageMethod(string knownCategoryValues, string category)
{
StringDictionary kv = CascadingDropDown.ParseKnownCategoryValuesString(knownCategoryValues);
int plantID;
if (kv.ContainsKey("PlantCode"))
{
List <CascadingDropDownNameValue> values =
new List <CascadingDropDownNameValue>();
if (Int32.TryParse(kv["PlantCode"], out plantID))
{
List <Workshop> workshopList = GlobalService.GetWorkshopbyPlantID(plantID);
values.Add(new CascadingDropDownNameValue(Consts.DROPDOWN_UNSELECTED_TEXT, string.Empty));
foreach (var item in workshopList)
{
values.Add(new CascadingDropDownNameValue(item.WorkshopCode, item.WorkshopID.ToString()));
}
}
return(values.ToArray());
}
else
{
return(null);
}
//StringDictionary knownCategoryValuesDictionary = AjaxControlToolkit.CascadingDropDown.ParseKnownCategoryValuesString(knownCategoryValues);
//// Perform a simple query against the data document
//return AjaxControlToolkit.CascadingDropDown.QuerySimpleCascadingDropDownDocument(doc, WorkshopHierarchy, knownCategoryValuesDictionary, category);
}
public CascadingDropDownNameValue[] GetSubSubProgramas(string knownCategoryValues, string category)
{
if (uow == null)
{
uow = new UnitOfWork();
}
if (ejercicioId == 0)
{
ejercicioId = Convert.ToInt32(Session["EjercicioId"]);
}
List <CascadingDropDownNameValue> list = new List <CascadingDropDownNameValue>();
int subprogramaId = Utilerias.StrToInt(CascadingDropDown.ParseKnownCategoryValuesString(knownCategoryValues)["subprogramaId"]);
var subsubprogramas = uow.AperturaProgramaticaBusinessLogic.Get(ap => ap.ParentId == subprogramaId, orderBy: ap => ap.OrderBy(r => r.Orden));
foreach (var item in subsubprogramas)
{
list.Add(new CascadingDropDownNameValue {
name = item.Nombre, value = item.Id.ToString()
});
}
return(list.ToArray());
}
public CascadingDropDownNameValue[] GetProductByProject(
string knownCategoryValues,
string category)
{
StringDictionary categoryValues = CascadingDropDown.ParseKnownCategoryValuesString(knownCategoryValues);
string project = categoryValues["Project"];
List <CascadingDropDownNameValue> result = new List <CascadingDropDownNameValue>();
if (string.Equals(project, "Mach", StringComparison.OrdinalIgnoreCase))
{
MachLookupDAL dal = new MachLookupDAL();
var machs = dal.GetAllMach();
foreach (var item in machs)
{
result.Add(new CascadingDropDownNameValue()
{
name = item.Name, value = item.Mach_Id.ToString()
});
}
}
else if (string.Equals(project, "Install", StringComparison.OrdinalIgnoreCase))
{
InstallLookupDAL dal = new InstallLookupDAL();
var installs = dal.GetAllLookup();
foreach (var item in installs)
{
result.Add(new CascadingDropDownNameValue()
{
name = item.Name, value = item.Install_Id.ToString()
});
}
}
else if (string.Equals(project, "Product", StringComparison.OrdinalIgnoreCase))
{
ProductDAL dal = new ProductDAL();
var products = dal.GetAllProducts();
foreach (var item in products)
{
result.Add(new CascadingDropDownNameValue()
{
name = item.Product_Name, value = item.Product_Id.ToString()
});
}
}
else if (string.Equals(project, "EndProduct", StringComparison.OrdinalIgnoreCase))
{
EndProductDAL dal = new EndProductDAL();
var endProducts = dal.GetAllEndProductList();
foreach (var item in endProducts)
{
result.Add(new CascadingDropDownNameValue()
{
name = item.Name, value = item.EP_Id.ToString()
});
}
}
return(result.ToArray());
}
public CascadingDropDownNameValue[] GetDistrictNames(string knownCategoryValues, string category)
{
StringDictionary kcv = CascadingDropDown.ParseKnownCategoryValuesString(knownCategoryValues);
if (!kcv.ContainsKey("city"))
{
return(null);
}
List <CascadingDropDownNameValue> values = new List <CascadingDropDownNameValue>();
SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString);
SqlCommand comm = conn.CreateCommand();
comm.CommandText = "select [Id],[DisName] from [T_District] where [CityID]=@CityID order by 1";
comm.Parameters.Add("@CityID", SqlDbType.Int).Value = kcv["city"];
conn.Open();
try
{
SqlDataReader dr = comm.ExecuteReader();
while (dr.Read())
{
values.Add(new CascadingDropDownNameValue(dr[1].ToString(), dr[0].ToString()));
}
return(values.ToArray());
}
finally
{
conn.Close();
}
}
public CascadingDropDownNameValue[] GetApplications(string knownCategoryValues, string category)
{
StringDictionary kv = CascadingDropDown.ParseKnownCategoryValuesString(knownCategoryValues);
List <CascadingDropDownNameValue> values = new List <CascadingDropDownNameValue>();
int PositionID;
//Verify that we have a parent position and parse it to the positionID variable
if (!kv.ContainsKey(STR_Positions) || !int.TryParse(kv[STR_Positions], out PositionID))
{
return(null);
}
List <Application> applicants = daoFactory.GetApplicationDao().GetApplicationsByPosition(daoFactory.GetPositionDao().GetById(PositionID, false));
//First sort by complete, then by name
applicants = applicants.OrderBy(app => !app.Submitted)
.ThenBy(app => string.IsNullOrEmpty(app.AssociatedProfile.FullName.Trim()) ? app.Email : app.AssociatedProfile.LastName).ToList();
foreach (Application app in applicants)
{
string name = string.IsNullOrEmpty(app.AssociatedProfile.FullName.Trim()) ? app.Email : app.AssociatedProfile.FullName;
string submitted = app.Submitted ? "Submitted" : "Not Submitted";
string displayName = string.Format("{0} ({1})", name, submitted);
values.Add(new CascadingDropDownNameValue(displayName, app.ID.ToString()));
}
return(values.ToArray());
}
public CascadingDropDownNameValue[] GetGradesByJobCode(string knownCategoryValues, string category)
{
StringDictionary kv = CascadingDropDown.ParseKnownCategoryValuesString(knownCategoryValues);
string jobCode;
if (!kv.ContainsKey("JobTitle"))
{
return(null);
}
jobCode = kv["JobTitle"];
List <CascadingDropDownNameValue> values = new List <CascadingDropDownNameValue>();
List <GradeEntity> list = new GradeMapper().ListByJobeCode(jobCode);
foreach (GradeEntity ent in list)
{
string text = ent.Id;
CascadingDropDownNameValue cdnv = new CascadingDropDownNameValue(text, ent.Id.ToString());
values.Add(cdnv);
}
return(values.ToArray());
}
public CascadingDropDownNameValue[] GetTeachersInSubj(string knownCategoryValues, string category)
{
int SubjectID;
StringDictionary kv = CascadingDropDown.ParseKnownCategoryValuesString(knownCategoryValues);
if (!kv.ContainsKey("Subj") || !Int32.TryParse(kv["Subj"], out SubjectID))
{
throw new ArgumentException("Couldn't find specialty choice.");
}
;
eRegisterData.DAL oDal = new eRegisterData.DAL();
SqlConnection conn = oDal.getSubject();
conn.Open();
SqlCommand comm = new SqlCommand(
@"Select ts.SubjectID, s.Name as [Subject] ,ts.TeacherID, a.FirstName + ' ' + a.LastName as Name
FROM Subjects s
Inner join TeacherSubject ts on s.SubjectID = ts.SubjectID
Inner join Actors a on a.ActorID = ts.TeacherID
WHERE ts.SubjectID=@SubjectID
ORDER BY Name", conn);
comm.Parameters.AddWithValue("@SubjectID", SubjectID);
SqlDataReader dr = comm.ExecuteReader();
List <CascadingDropDownNameValue> l = new List <CascadingDropDownNameValue>();
while (dr.Read())
{
l.Add(new CascadingDropDownNameValue(dr["Name"].ToString(), dr["TeacherID"].ToString()));
}
conn.Close();
return(l.ToArray());
}
public CascadingDropDownNameValue[] GetActiveTruckModels(string knownCategoryValues, string category)
{
try
{
string TruckTypeID = "";
StringDictionary kv;
kv = CascadingDropDown.ParseKnownCategoryValuesString(knownCategoryValues);
if (!kv.ContainsKey("TruckType") || kv["TruckType"].ToString() == "")
{
throw new ArgumentException("Couldn't find selected Truck Type.");
}
TruckTypeID = kv["TruckType"];
List <CascadingDropDownNameValue> l = new List <CascadingDropDownNameValue>();
TruckModelBLL objTm = new TruckModelBLL();
List <TruckModelBLL> listTM = new List <TruckModelBLL>();
listTM = objTm.GetActiveTrucksByTypeId(new Guid(TruckTypeID));
foreach (TruckModelBLL o in listTM)
{
l.Add(new CascadingDropDownNameValue(o.TruckModelName, o.Id.ToString()));
}
return(l.ToArray());
}
catch (Exception ex)
{
throw ex;
}
}
public CascadingDropDownNameValue[] GetModels(string knownCategoryValues)
{
string make = CascadingDropDown.ParseKnownCategoryValuesString(knownCategoryValues)["MakeId"];
string query = string.Format("exec spIBCInventorySearch_MODEL @VehicleMake = {0}, @IDCustomer = 253433 ", make);
List<CascadingDropDownNameValue> Models = GetData(query);
return Models.ToArray();
}
public CascadingDropDownNameValue[] GetYears(string knownCategoryValues, string category)
{
int ModelID;
CascadingDropDown.ParseKnownCategoryValuesString(knownCategoryValues);
StringDictionary kv = CascadingDropDown.ParseKnownCategoryValuesString(knownCategoryValues);
if (!kv.ContainsKey("Models") || !Int32.TryParse(kv["Models"], out ModelID))
{
throw new ArgumentException("Couldn't find model.");
}
connection.Open();
SqlCommand comm = new SqlCommand("SELECT DISTINCT CONCAT(ProduceFrom, ' - ', ProduceTo) AS TextColumns, CONCAT(ProduceFrom,NULL, ProduceTo) AS ValueColumns FROM Modifications WHERE Models_ID=@ModelID AND Status=1", connection);
comm.Parameters.AddWithValue("@ModelID", ModelID);
SqlDataReader dr = comm.ExecuteReader();
List <CascadingDropDownNameValue> l = new List <CascadingDropDownNameValue>();
while (dr.Read())
{
l.Add(new CascadingDropDownNameValue(dr["TextColumns"].ToString(), dr["ValueColumns"].ToString()));
}
connection.Close();
return(l.ToArray());
}
public CascadingDropDownNameValue[] Desa(string knownCategoryValues, string category)
{
string str = CascadingDropDown.ParseKnownCategoryValuesString(knownCategoryValues)["id_kec"];
string connectionString = ConfigurationManager.ConnectionStrings["MainDb"].ConnectionString;
SqlCommand sqlCommand = new SqlCommand("SELECT daerah_kecamatan.id_kec, daerah_desa.id_desa, daerah_desa.nama FROM daerah_desa INNER JOIN daerah_kecamatan ON daerah_desa.id_kec = daerah_kecamatan.id_kec where daerah_kecamatan.id_kec=@id_kec");
sqlCommand.Parameters.AddWithValue("@id_kec", (object)str);
using (SqlConnection sqlConnection = new SqlConnection(connectionString))
{
sqlConnection.Open();
sqlCommand.Connection = sqlConnection;
using (SqlDataReader sqlDataReader = sqlCommand.ExecuteReader())
{
List <CascadingDropDownNameValue> list = new List <CascadingDropDownNameValue>();
while (sqlDataReader.Read())
{
list.Add(new CascadingDropDownNameValue(sqlDataReader["nama"].ToString(), sqlDataReader["nama"].ToString()));
}
sqlDataReader.Close();
sqlDataReader.Dispose();
sqlConnection.Close();
return(list.ToArray());
}
}
}
public CascadingDropDownNameValue[] LoadAccountsHeadList(string knownCategoryValues, string category)
{
var kv = CascadingDropDown.ParseKnownCategoryValuesString(knownCategoryValues);
int expenseCategoryId;
var accountsHeadList = new List <AccountsHead>();
if (!kv.ContainsKey("ExpenseCategoryId") || !Int32.TryParse(kv["ExpenseCategoryId"], out expenseCategoryId))
{
return
(accountsHeadList.Select(
item =>
new CascadingDropDownNameValue(item.Title,
item.ExpenseCategoryId.ToString(CultureInfo.InvariantCulture))).
ToArray());
}
accountsHeadList =
ServiceProvider.Instance().GetAccountsHeadServices().GetAccountsHeadsByExpenseCategoryId(
expenseCategoryId).Where(m => m.Status == 1).ToList();
if (accountsHeadList.Count < 1)
{
return(new List <CascadingDropDownNameValue>().ToArray());
}
accountsHeadList = accountsHeadList.OrderBy(m => m.Title).ToList();
return
(accountsHeadList.Select(
item =>
new CascadingDropDownNameValue(item.Title,
item.AccountsHeadId.ToString(CultureInfo.InvariantCulture))).ToArray());
}
public CascadingDropDownNameValue[] GetModels(string knownCategoryValues, string category)
{
int BrandID;
CascadingDropDown.ParseKnownCategoryValuesString(knownCategoryValues);
StringDictionary kv = CascadingDropDown.ParseKnownCategoryValuesString(knownCategoryValues);
if (!kv.ContainsKey("Brands") || !Int32.TryParse(kv["Brands"], out BrandID))
{
throw new ArgumentException("Couldn't find brand.");
}
connection.Open();
SqlCommand comm = new SqlCommand("SELECT DISTINCT Models.ID, Models.Name FROM Models LEFT JOIN Modifications ON Models.ID=Modifications.Models_ID WHERE Brands_ID=@BrandID AND Modifications.Status=1 AND (Modifications.InsuranceValue IS NOT NULL)", connection);
comm.Parameters.AddWithValue("@BrandID", BrandID);
SqlDataReader dr = comm.ExecuteReader();
List <CascadingDropDownNameValue> l = new List <CascadingDropDownNameValue>();
while (dr.Read())
{
l.Add(new CascadingDropDownNameValue(dr["Name"].ToString(), dr["ID"].ToString()));
}
connection.Close();
return(l.ToArray());
}
public CascadingDropDownNameValue[] LoadExpenseItemList(string knownCategoryValues, string category)
{
var kv = CascadingDropDown.ParseKnownCategoryValuesString(knownCategoryValues);
int accountHeadId;
var expenseItemList = new List <ExpenseItem>();
if (!kv.ContainsKey("AccountHeadId") || !Int32.TryParse(kv["AccountHeadId"], out accountHeadId))
{
return
(expenseItemList.Select(
item =>
new CascadingDropDownNameValue(item.Title,
item.ExpenseItemId.ToString(CultureInfo.InvariantCulture))).ToArray());
}
expenseItemList =
ServiceProvider.Instance().GetExpenseItemServices().GetExpenseItemsByAccountsHeadId(accountHeadId);
if (expenseItemList.Count < 1)
{
return(new List <CascadingDropDownNameValue>().ToArray());
}
return
(expenseItemList.Select(
item =>
new CascadingDropDownNameValue(item.Title,
item.ExpenseItemId.ToString(CultureInfo.InvariantCulture))).ToArray());
}
public CascadingDropDownNameValue[] LoadBeneficiariesByBeneficiaryType(string knownCategoryValues,
string category)
{
var kv = CascadingDropDown.ParseKnownCategoryValuesString(knownCategoryValues);
int beneficiaryTypeId;
var beneficiaries = new List <Beneficiary>();
if (!kv.ContainsKey("BeneficiaryTypeId") || !Int32.TryParse(kv["BeneficiaryTypeId"], out beneficiaryTypeId))
{
return
(beneficiaries.Select(
item =>
new CascadingDropDownNameValue(item.FullName,
item.BeneficiaryId.ToString(CultureInfo.InvariantCulture))).ToArray());
}
beneficiaries =
ServiceProvider.Instance()
.GetBeneficiaryServices()
.GetActiveBeneficiariesByBeneficiaryType(beneficiaryTypeId);
if (beneficiaries.Count < 1)
{
return(new List <CascadingDropDownNameValue>().ToArray());
}
return
(beneficiaries.Select(
item =>
new CascadingDropDownNameValue(item.FullName,
item.BeneficiaryId.ToString(CultureInfo.InvariantCulture))).ToArray());
}
public CascadingDropDownNameValue[] LoadApprovedTransactionsByBeneficiary(string knownCategoryValues,
string category)
{
var kv = CascadingDropDown.ParseKnownCategoryValuesString(knownCategoryValues);
int beneficiaryId;
var beneficiaryApprovedUnpaidTransactionList = new List <ExpenseTransaction>();
if (!kv.ContainsKey("BeneficiaryId") || !Int32.TryParse(kv["BeneficiaryId"], out beneficiaryId))
{
return
(beneficiaryApprovedUnpaidTransactionList.Select(
item =>
new CascadingDropDownNameValue(item.ExpenseTitle,
item.ExpenseTransactionId.ToString(CultureInfo.InvariantCulture))).ToArray());
}
beneficiaryApprovedUnpaidTransactionList =
ServiceProvider.Instance()
.GetExpenseTransactionServices()
.GetBeneficiaryOnlyApprovedExpenseTransactions(beneficiaryId);
if (beneficiaryApprovedUnpaidTransactionList.Count < 1)
{
return(new List <CascadingDropDownNameValue>().ToArray());
}
return
(beneficiaryApprovedUnpaidTransactionList.Select(
item =>
new CascadingDropDownNameValue(item.ExpenseTitle,
item.ExpenseTransactionId.ToString(CultureInfo.InvariantCulture))).ToArray());
}
public CascadingDropDownNameValue[] LoadUnitList(string knownCategoryValues, string category)
{
var kv = CascadingDropDown.ParseKnownCategoryValuesString(knownCategoryValues);
int departmentId;
var unitList = new List <Unit>();
if (!kv.ContainsKey("DepartmentId") || !Int32.TryParse(kv["DepartmentId"], out departmentId))
{
return
(unitList.Select(
item =>
new CascadingDropDownNameValue(item.Name, item.UnitId.ToString(CultureInfo.InvariantCulture)))
.ToArray());
}
unitList = ServiceProvider.Instance().GetUnitServices().GetActiveOrderedUnitsByDepartment(departmentId);
if (unitList.Count < 1)
{
return(new List <CascadingDropDownNameValue>().ToArray());
}
return
(unitList.Select(
item =>
new CascadingDropDownNameValue(item.Name, item.UnitId.ToString(CultureInfo.InvariantCulture)))
.ToArray());
}
public CascadingDropDownNameValue[] GetStepsByGradeId(string knownCategoryValues, string category)
{
StringDictionary kv = CascadingDropDown.ParseKnownCategoryValuesString(knownCategoryValues);
string gradeId;
if (!kv.ContainsKey("Grade"))
{
return(null);
}
gradeId = kv["Grade"];
List <CascadingDropDownNameValue> values = new List <CascadingDropDownNameValue>();
List <StepEntity> list = new StepMapper().ListByGradeId(gradeId);
foreach (StepEntity ent in list)
{
string text = (ent.Id);
CascadingDropDownNameValue cdnv = new CascadingDropDownNameValue(text, ent.Id.ToString());
values.Add(cdnv);
}
return(values.ToArray());
}
public CascadingDropDownNameValue[] AclExpress_GetAuthRuleAreaGrant(string knownCategoryValues, string category, string contextKey)
{
//2016.06.20 新增
//拆解 CategoryValues
StringDictionary dicCategory = CascadingDropDown.ParseKnownCategoryValuesString(knownCategoryValues);
StringDictionary dicContext = CascadingDropDown.ParseKnownCategoryValuesString(contextKey);
DbHelper db = new DbHelper(AclExpress._AclDBName);
string strSQL;
DataTable dt = new DataTable();
//判斷要處理那一階選單
switch (category)
{
case "RuleID":
strSQL = "Select Distinct RuleID, RuleID + ' - ' + RuleName + '【' + RuleEnabled + '】' as 'RuleInfo' From viewAclAuthRuleAreaGrantList ";
dt = db.ExecuteDataSet(CommandType.Text, strSQL).Tables[0];
break;
case "AreaID":
strSQL = string.Format("Select Distinct AreaID, AreaID + ' - ' + AreaName + '【' + AreaEnabled + '】' as 'AreaInfo' From viewAclAuthRuleAreaGrantList Where RuleID = '{0}' ", dicCategory["RuleID"]);
dt = db.ExecuteDataSet(CommandType.Text, strSQL).Tables[0];
break;
case "GrantID":
strSQL = string.Format("Select Distinct GrantID, GrantID + ' - ' + GrantName + '【' + GrantEnabled + '】' as 'GrantInfo' From viewAclAuthRuleAreaGrantList Where RuleID= '{0}' and AreaID = '{1}' ", dicCategory["RuleID"], dicCategory["AreaID"]);
dt = db.ExecuteDataSet(CommandType.Text, strSQL).Tables[0];
break;
default:
break;
}
return(Util.getCascadingArray(dt));
}
public CascadingDropDownNameValue[] GetData3(string knownCategoryValues, string category)
{
string str = CascadingDropDown.ParseKnownCategoryValuesString(knownCategoryValues)["UserName"];
string connectionString = ConfigurationManager.ConnectionStrings["MainDb"].ConnectionString;
SqlCommand sqlCommand = new SqlCommand("SELECT [user].userid, [user].username, kota.kota FROM kota INNER JOIN [user] ON kota.id_kota = [user].id_kota where [USER].username=@0");
sqlCommand.Parameters.AddWithValue("@0", (object)str);
using (SqlConnection sqlConnection = new SqlConnection(connectionString))
{
sqlConnection.Open();
sqlCommand.Connection = sqlConnection;
using (SqlDataReader sqlDataReader = sqlCommand.ExecuteReader())
{
List <CascadingDropDownNameValue> list = new List <CascadingDropDownNameValue>();
while (sqlDataReader.Read())
{
list.Add(new CascadingDropDownNameValue(sqlDataReader["kota"].ToString(), sqlDataReader["kota"].ToString()));
}
sqlDataReader.Close();
sqlDataReader.Dispose();
sqlConnection.Close();
return(list.ToArray());
}
}
}
public CascadingDropDownNameValue[] GetEmployeesByOrganisationalUnit(string knownCategoryValues, string category)
{
StringDictionary kv = CascadingDropDown.ParseKnownCategoryValuesString(knownCategoryValues);
List <CascadingDropDownNameValue> values = new List <CascadingDropDownNameValue>();
int organisationalId;
if (!kv.ContainsKey("OrganizationalUnit") ||
!Int32.TryParse(kv["OrganizationalUnit"], out organisationalId))
{
#warning change this code to get ur organisation unit and also do not display yourself
//Get my organizational unit
int myorganizationUnit = 20;
List <EmployeeView> list = new EmployeeMapper().ListWithAdvancedFilter("", "", null, myorganizationUnit, null, StatusEnum.Active);
foreach (EmployeeView ent in list)
{
CascadingDropDownNameValue cdnv = new CascadingDropDownNameValue(ent.ToString(), ent.Id.ToString());
values.Add(cdnv);
}
}
else
{
List <EmployeeView> list = new EmployeeMapper().ListWithAdvancedFilter("", "", null, organisationalId, null, StatusEnum.Active);
foreach (EmployeeView ent in list)
{
CascadingDropDownNameValue cdnv = new CascadingDropDownNameValue(ent.ToString(), ent.Id.ToString());
values.Add(cdnv);
}
}
return(values.ToArray());
}
public CascadingDropDownNameValue[] GetCities(string knownCategoryValues)
{
string state = CascadingDropDown.ParseKnownCategoryValuesString(knownCategoryValues)["StateId"];
string query = string.Format("SELECT CityName, CityId FROM Cities WHERE StateId = {0}", state);
List <CascadingDropDownNameValue> cities = GetData(query);
return(cities.ToArray());
}
public CascadingDropDownNameValue[] GetStates(string knownCategoryValues)
{
string country = CascadingDropDown.ParseKnownCategoryValuesString(knownCategoryValues)["CountryId"];
string query = string.Format("SELECT StateName, StateId FROM States WHERE CountryId = {0}", country);
List <CascadingDropDownNameValue> states = GetData(query);
return(states.ToArray());
}
public static CascadingDropDownNameValue[] GetDropDownContents(string knownCategoryValues, string category)
{
// Get a dictionary of known category/value pairs
var knownCategoryValuesDictionary = CascadingDropDown.ParseKnownCategoryValuesString(knownCategoryValues);
// Perform a simple query against the data document
return(CascadingDropDown.QuerySimpleCascadingDropDownDocument(Document, Hierarchy, knownCategoryValuesDictionary, category, InputValidationRegex));
}
public CascadingDropDownNameValue[] GetDoors(string knownCategoryValues, string category)
{
CascadingDropDown.ParseKnownCategoryValuesString(knownCategoryValues);
StringDictionary kv = CascadingDropDown.ParseKnownCategoryValuesString(knownCategoryValues);
int Power;
if (!kv.ContainsKey("Power") || !Int32.TryParse(kv["Power"], out Power))
{
throw new ArgumentException("Couldn't find modification.");
}
int Volume;
if (!kv.ContainsKey("Volume") || !Int32.TryParse(kv["Volume"], out Volume))
{
throw new ArgumentException("Couldn't find modification.");
}
int Year;
if (!kv.ContainsKey("Years") || !Int32.TryParse(kv["Years"], out Year))
{
throw new ArgumentException("Couldn't find modification.");
}
int FuelID;
if (!kv.ContainsKey("Fuel") || !Int32.TryParse(kv["Fuel"], out FuelID))
{
throw new ArgumentException("Couldn't find model.");
}
int ModelID;
if (!kv.ContainsKey("Models") || !Int32.TryParse(kv["Models"], out ModelID))
{
throw new ArgumentException("Couldn't find model.");
}
connection.Open();
SqlCommand comm = new SqlCommand("SELECT DISTINCT Doors, Name FROM Modifications WHERE ProduceTo=@ProduceTo AND EngineFuel=@Fuel AND Models_ID=@ModelID AND EngineVolume=@Volume AND EnginePower=@Power AND Status=1", connection);
comm.Parameters.AddWithValue("@ProduceTo", Year % 10000);
comm.Parameters.AddWithValue("@Fuel", FuelID);
comm.Parameters.AddWithValue("@ModelID", ModelID);
comm.Parameters.AddWithValue("@Volume", Volume);
comm.Parameters.AddWithValue("@Power", Power);
SqlDataReader dr = comm.ExecuteReader();
List <CascadingDropDownNameValue> l = new List <CascadingDropDownNameValue>();
while (dr.Read())
{
l.Add(new CascadingDropDownNameValue(dr["Doors"].ToString(), dr["Name"].ToString()));
}
connection.Close();
return(l.ToArray());
}
void cddExtender_DataBinding(object sender, EventArgs e)
{
CascadingDropDown cddExtender = (CascadingDropDown)sender;
string childColumnName = cddExtender.TargetControlID.Substring("ddl".Length);
string fieldName = driver.Columns.Find(c => c.Name == childColumnName).Text;
object dataValue = DataSource.GetType().GetProperty(fieldName).GetValue(DataSource, null);
cddExtender.SelectedValue = dataValue.ToString();
}
public CascadingDropDownNameValue[] GetDropDownContents(string knownCategoryValues,
string category)
{
StringDictionary knownCategoryValuesDictionary =
CascadingDropDown.ParseKnownCategoryValuesString(knownCategoryValues);
return(CascadingDropDown.QuerySimpleCascadingDropDownDocument(
Document, Hierarchy, knownCategoryValuesDictionary, category));
}
