public CascadingDropDownNameValue[] GetGenders(string knownCategoryValues, string category, string contextKey)
{
List <CascadingDropDownNameValue> values = new List <CascadingDropDownNameValue>();
string[] genderNames = Enum.GetNames(typeof(GenderEnum));
Array genderValues = Enum.GetValues(typeof(GenderEnum));
CascadingDropDownNameValue cdnv;
for (int i = 1; i <= genderNames.Length - 1; i++)
{
if (genderNames[i] == contextKey)
{
cdnv = new CascadingDropDownNameValue(genderNames[i], i.ToString(), true);
}
else
{
cdnv = new CascadingDropDownNameValue(genderNames[i], i.ToString());
}
values.Add(cdnv);
}
return(values.ToArray());
}
private static CascadingDropDownNameValue[] GetCascadingDropDownNameValue(string sql, bool valueEqName)
{
string connString = WebConfigurationManager.ConnectionStrings["InnovationTrainingProgramDBConnectionString"].ConnectionString;
SqlConnection conn = new SqlConnection(connString);
SqlDataAdapter da = new SqlDataAdapter(sql, conn);
DataTable dt = new DataTable();
da.Fill(dt);
CascadingDropDownNameValue[] result = new CascadingDropDownNameValue[dt.Rows.Count];
for (int i = 0; i < dt.Rows.Count; i++)
{
if (valueEqName)
{
result[i] = new CascadingDropDownNameValue(dt.Rows[i][0].ToString(), dt.Rows[i][0].ToString());
}
else
{
result[i] = new CascadingDropDownNameValue(dt.Rows[i][0].ToString(), dt.Rows[i][1].ToString());
}
}
return(result);
}
public CascadingDropDownNameValue[] GetPaymentTypes(string knownCategoryValues, string category, string contextKey)
{
List <CascadingDropDownNameValue> values = new List <CascadingDropDownNameValue>();
string[] paymentTypeNames = Enum.GetNames(typeof(LeaveNameType));
Array paymentTypeValues = Enum.GetValues(typeof(LeaveNameType));
CascadingDropDownNameValue cdnv;
for (int i = 1; i <= paymentTypeNames.Length - 1; i++)
{
if (paymentTypeNames[i] == contextKey)
{
cdnv = new CascadingDropDownNameValue(paymentTypeNames[i], i.ToString(), true);
}
else
{
cdnv = new CascadingDropDownNameValue(paymentTypeNames[i], i.ToString());
}
values.Add(cdnv);
}
return(values.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[] GetEducationTrainingLevels(string knownCategoryValues, string category, string contextKey)
{
List <CascadingDropDownNameValue> values = new List <CascadingDropDownNameValue>();
string[] organizationalLevelNames = Enum.GetNames(typeof(EducationTrainingLevelEnum));
Array organizationalLevelValues = Enum.GetValues(typeof(EducationTrainingLevelEnum));
CascadingDropDownNameValue cdnv;
for (int i = 1; i <= organizationalLevelNames.Length - 1; i++)
{
if (organizationalLevelNames[i] == contextKey)
{
cdnv = new CascadingDropDownNameValue(organizationalLevelNames[i], i.ToString(), true);
}
else
{
cdnv = new CascadingDropDownNameValue(organizationalLevelNames[i], i.ToString());
}
values.Add(cdnv);
}
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[] 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[] GetMaritalStatus(string knownCategoryValues, string category, string contextKey)
{
List <CascadingDropDownNameValue> values = new List <CascadingDropDownNameValue>();
string[] maritalStatusNames = Enum.GetNames(typeof(MaritalStatusEnum));
Array maritalStatusValues = Enum.GetValues(typeof(MaritalStatusEnum));
CascadingDropDownNameValue cdnv;
for (int i = 1; i <= maritalStatusNames.Length - 1; i++)
{
if (maritalStatusNames[i] == contextKey)
{
cdnv = new CascadingDropDownNameValue(maritalStatusNames[i], i.ToString(), true);
}
else
{
cdnv = new CascadingDropDownNameValue(maritalStatusNames[i], i.ToString());
}
values.Add(cdnv);
}
return(values.ToArray());
}
public AjaxControlToolkit.CascadingDropDownNameValue[] GetCategories(string knownCategoryValues, string category)
{
//System.Diagnostics.Debug.Print(knownCategoryValues + " --- " + category);
StringDictionary kv = CascadingDropDown.ParseKnownCategoryValuesString(knownCategoryValues);
List <AjaxControlToolkit.CascadingDropDownNameValue> values = new List <AjaxControlToolkit.CascadingDropDownNameValue>();
List <ProductCategories> lstcategory = (new ProductCategories()).GetPCategories();
foreach (ProductCategories objcategory in lstcategory)
{
CascadingDropDownNameValue item = new CascadingDropDownNameValue(objcategory.ProductCategoryName, objcategory.ProductCategoryID.ToString());
values.Add(item);
}
if (kv.Count == 1 && kv.ContainsKey("ProductCategoryID"))
//if (kv.Count == 1 && category=="StatesId")
{
string s = kv["ProductCategoryID"];
values.Clear();
List <Products> lstprdts = (new Products()).GetProducts(long.Parse(s));
foreach (Products objprdts in lstprdts)
{
CascadingDropDownNameValue item = new CascadingDropDownNameValue(objprdts.ProductName, objprdts.ProductID.ToString());
values.Add(item);
}
}
////else if (kv.Count == 2 && category == "StatesId")
//else if (kv.Count == 2 && kv.ContainsKey("ProductID"))
////else if (kv.Count == 2)
//{
// string s = kv["ProductID"];
// values.Clear();
// List<SpecificationCategory> banks = (new SpecificationCategory()).GetSCategories(long.Parse(s));
// foreach (SpecificationCategory objspctgy in banks)
// {
// CascadingDropDownNameValue item = new CascadingDropDownNameValue(objspctgy.SpecificationCategoryName, objspctgy.SpecificationCategoryID.ToString());
// values.Add(item);
// }
//}
return(values.ToArray());
}
public CascadingDropDownNameValue[] CascDD1Call(string knownCategoryValues, string category)
{
CascadingDropDownNameValue[] CascDD1NV = new CascadingDropDownNameValue[2];//Its better to set this array size exactly as refered from source/DB
//Can be from DB as ID,Val
CascDD1NV[0] = new CascadingDropDownNameValue("A", "A");
CascDD1NV[1] = new CascadingDropDownNameValue("B", "B");
//string query = "SELECT CountryName, CountryId FROM Countries";
//List<CascadingDropDownNameValue> countries = GetData(query);
//return countries.ToArray();
return(CascDD1NV);
}
public CascadingDropDownNameValue[] GetFunctionalLevels(string knownCategoryValues, string category)
{
List <CascadingDropDownNameValue> values = new List <CascadingDropDownNameValue>();
List <FunctionalLevelEntity> list = new FunctionalLevelMapper().List("");
foreach (FunctionalLevelEntity ent in list)
{
CascadingDropDownNameValue cdnv = new CascadingDropDownNameValue(ent.Title, ent.Id.ToString());
values.Add(cdnv);
}
return(values.ToArray());
}
public CascadingDropDownNameValue[] GetContractsTemplates(string knownCategoryValues, string category)
{
List <CascadingDropDownNameValue> values = new List <CascadingDropDownNameValue>();
List <ContractTemplateEntity> list = new ContractTemplateMapper().ListWithAdvancedFilter("", StatusEnum.Active);
foreach (ContractTemplateEntity ent in list)
{
CascadingDropDownNameValue cdnv = new CascadingDropDownNameValue(ent.Title, ent.Id.ToString());
values.Add(cdnv);
}
return(values.ToArray());
}
public CascadingDropDownNameValue[] GetLeaveTypes(string knownCategoryValues, string category, string contextKey)
{
List <CascadingDropDownNameValue> values = new List <CascadingDropDownNameValue>();
List <LeaveTypeEntity> list = new LeaveTypeMapper().List("");
foreach (LeaveTypeEntity entity in list)
{
CascadingDropDownNameValue cdnv;
cdnv = new CascadingDropDownNameValue(entity.Title, entity.Id.ToString());
values.Add(cdnv);
}
return(values.ToArray());
}
public CascadingDropDownNameValue[] GetAmandamentTemplates(string knownCategoryValues, string category, string contextKey)
{
List <CascadingDropDownNameValue> values = new List <CascadingDropDownNameValue>();
List <AmandamentTemplateEntity> list = new AmandamentTemplateMapper().ListWithAdvancedFilter("", StatusEnum.Active);
foreach (AmandamentTemplateEntity entity in list)
{
CascadingDropDownNameValue cdnv;
cdnv = new CascadingDropDownNameValue(entity.Title, entity.AmandamentTemplateId.ToString());
values.Add(cdnv);
}
return(values.ToArray());
}
public CascadingDropDownNameValue[] GetContractTemplatesFromCurrentJobDetails(string knownCategoryValues, string category, string contextKey)
{
List <CascadingDropDownNameValue> values = new List <CascadingDropDownNameValue>();
Dictionary <int, string> list = new ContractTemplateMapper().ListTemplateContractsFromCurrentJobDetails();
foreach (KeyValuePair <int, string> kvp in list)
{
CascadingDropDownNameValue cdnv;
cdnv = new CascadingDropDownNameValue(kvp.Value, kvp.Key.ToString());
values.Add(cdnv);
}
return(values.ToArray());
}
public CascadingDropDownNameValue[] GetJobTitlesByOrganisationalUnit(string knownCategoryValues, string category, string contextKey)
{
StringDictionary kv = CascadingDropDown.ParseKnownCategoryValuesString(knownCategoryValues);
List <CascadingDropDownNameValue> values = new List <CascadingDropDownNameValue>();
int organisationalId;
if (!kv.ContainsKey("OrganizationalUnit") ||
!Int32.TryParse(kv["OrganizationalUnit"], out organisationalId))
{
List <JobTitleView> list = new JobTitleMapper().ListByOrganisationalUnitId(null, "", StatusEnum.Active);
foreach (JobTitleView ent in list)
{
CascadingDropDownNameValue cdnv;
if (ent.Title == contextKey)
{
cdnv = new CascadingDropDownNameValue(ent.Title, ent.Code, true);
values.Add(cdnv);
}
else
{
cdnv = new CascadingDropDownNameValue(ent.Title, ent.Code);
values.Add(cdnv);
}
}
}
else
{
List <JobTitleView> list = new JobTitleMapper().ListByOrganisationalUnitId(organisationalId, "", StatusEnum.Active);
foreach (JobTitleView ent in list)
{
CascadingDropDownNameValue cdnv;
if (ent.Title == contextKey)
{
cdnv = new CascadingDropDownNameValue(ent.Title, ent.Code, true);
values.Add(cdnv);
}
else
{
cdnv = new CascadingDropDownNameValue(ent.Title, ent.Code);
values.Add(cdnv);
}
}
}
return(values.ToArray());
}
private static CascadingDropDownNameValue[] GetCascadingDropDownNameValueByCheck(string sql)
{
string connString = WebConfigurationManager.ConnectionStrings["CheckConnStr"].ConnectionString;
SqlConnection conn = new SqlConnection(connString);
SqlDataAdapter da = new SqlDataAdapter(sql, conn);
DataTable dt = new DataTable();
da.Fill(dt);
CascadingDropDownNameValue[] result = new CascadingDropDownNameValue[dt.Rows.Count];
for (int i = 0; i < dt.Rows.Count; i++)
{
result[i] = new CascadingDropDownNameValue(dt.Rows[i][0].ToString(), dt.Rows[i][0].ToString());
}
return(result);
}
public CascadingDropDownNameValue[] GetOrganizationalUnitGroups(string knownCategoryValues, string category, string contextKey)
{
List <CascadingDropDownNameValue> values = new List <CascadingDropDownNameValue>();
List <OrganizationalUnitGroupEntity> list = new OrganizationalUnitGroupMapper().List("");
foreach (OrganizationalUnitGroupEntity ent in list)
{
CascadingDropDownNameValue cdnv;
if (ent.Title == contextKey)
{
cdnv = new CascadingDropDownNameValue(ent.Title, ent.Id.ToString(), true);
}
else
{
cdnv = new CascadingDropDownNameValue(ent.Title, ent.Id.ToString());
}
values.Add(cdnv);
}
return(values.ToArray());
}
public CascadingDropDownNameValue[] GetBanks(string knownCategoryValues, string category, string contextKey)
{
List <CascadingDropDownNameValue> values = new List <CascadingDropDownNameValue>();
List <BankEntity> list = new BankMapper().ListWithAdvancedFilter("", StatusEnum.Active);
foreach (BankEntity ent in list)
{
CascadingDropDownNameValue cdnv;
if (ent.Title == contextKey)
{
cdnv = new CascadingDropDownNameValue(ent.Title, ent.Id.ToString(), true);
}
else
{
cdnv = new CascadingDropDownNameValue(ent.Title, ent.Id.ToString());
}
values.Add(cdnv);
}
return(values.ToArray());
}
public CascadingDropDownNameValue[] GetPaymentTypesByLeaveType(string knownCategoryValues, string category)
{
StringDictionary kv = CascadingDropDown.ParseKnownCategoryValuesString(knownCategoryValues);
int leaveTypelId;
if (!kv.ContainsKey("LeaveTypes") ||
!Int32.TryParse(kv["LeaveTypes"], out leaveTypelId))
{
return(null);
}
List <CascadingDropDownNameValue> values = new List <CascadingDropDownNameValue>();
List <LeaveTypeLevelEntity> list = new LeaveTypeLevelMapper().List(leaveTypelId);
foreach (LeaveTypeLevelEntity ent in list)
{
CascadingDropDownNameValue cdnv = new CascadingDropDownNameValue(ent.LeaveNameType.ToString(), ent.Id.ToString());
values.Add(cdnv);
}
return(values.ToArray());
}
