private void dg_delete2(object source, System.Web.UI.WebControls.DataGridCommandEventArgs e)
{
int ItemID = int.Parse(e.Item.Cells[0].Text);
BusinessScore.Delete(ItemID);
dgScore.EditItemIndex = -1;
BindDG();
}
private void dg_update2(object source, System.Web.UI.WebControls.DataGridCommandEventArgs e)
{
int ItemID = int.Parse(e.Item.Cells[0].Text);
TextBox tbK = (TextBox)e.Item.FindControl("tbKey");
TextBox tbN = (TextBox)e.Item.FindControl("tbName2");
if (tbK != null && tbN != null)
{
if (ItemID > 0)
{
BusinessScore bs = BusinessScore.Load(ItemID);
bs.Key = tbK.Text;
bs.Name = tbN.Text;
BusinessScore.Update(bs);
}
else
{
BusinessScore.Create(tbK.Text, tbN.Text);
}
}
dgScore.EditItemIndex = -1;
BindDG();
}
} // SaveToDb
public override string ToString()
{
var sb = new StringBuilder();
sb.AppendFormat(
"Calculation Num 1 .........Medal Type {2} Medal: {0} " +
"NormalizedScore: {1}% Score: {3} Offered amount: {4}\n",
MedalClassification,
StringBuilderExtention.ToPercent(TotalScoreNormalized),
MedalType,
TotalScore,
OfferedLoanAmount
);
sb.AppendFormat(
"{0}| {1}| {2}| {3}| {4}| {5}| {6}| {7}| {8} \n",
"Parameter".PadRight(25),
"Weight".PadRight(10),
"MinScore".PadRight(10),
"MaxScore".PadRight(10),
"MinGrade".PadRight(10),
"MaxGrade".PadRight(10),
"Grade".PadRight(10),
"Score".PadRight(10),
"Value"
);
var summary = new Weight();
Weight weight;
if (MedalType != MedalType.SoleTrader)
{
weight = new Weight {
Value = BusinessScore.ToString(CultureInfo.InvariantCulture),
FinalWeight = BusinessScoreWeight,
Grade = (int)BusinessScoreGrade,
Score = BusinessScoreScore
};
sb.AddWeight(weight, "BusinessScore", ref summary);
} // if
if (MedalType == MedalType.Limited || MedalType == MedalType.OnlineLimited)
{
weight = new Weight {
Value = TangibleEquity.ToString(CultureInfo.InvariantCulture),
FinalWeight = TangibleEquityWeight,
Grade = (int)TangibleEquityGrade,
Score = TangibleEquityScore
};
sb.AddWeight(weight, "TangibleEquity", ref summary);
} // if
DateTime calcTime = CalculationTime;
int businessSeniorityYears = 0;
decimal ezbobSeniorityMonth = 0;
if (BusinessSeniority.HasValue)
{
businessSeniorityYears = (int)(calcTime - BusinessSeniority.Value).TotalDays / 365;
}
if (EzbobSeniority.HasValue)
{
ezbobSeniorityMonth = (decimal)(calcTime - EzbobSeniority.Value).TotalDays / (365.0M / 12.0M);
}
weight = new Weight {
Value = businessSeniorityYears.ToString(CultureInfo.InvariantCulture),
FinalWeight = BusinessSeniorityWeight,
Grade = (int)BusinessSeniorityGrade,
Score = BusinessSeniorityScore
};
sb.AddWeight(weight, "BusinessSeniority", ref summary);
weight = new Weight {
Value = ConsumerScore.ToString(CultureInfo.InvariantCulture),
FinalWeight = ConsumerScoreWeight,
Grade = (int)ConsumerScoreGrade,
Score = ConsumerScoreScore
};
sb.AddWeight(weight, "ConsumerScore", ref summary);
weight = new Weight {
Value = ezbobSeniorityMonth.ToString(CultureInfo.InvariantCulture),
FinalWeight = EzbobSeniorityWeight,
Grade = (int)EzbobSeniorityGrade,
Score = EzbobSeniorityScore
};
sb.AddWeight(weight, "EzbobSeniority", ref summary);
weight = new Weight {
Value = MaritalStatus.ToString(),
FinalWeight = MaritalStatusWeight,
Grade = (int)MaritalStatusGrade,
Score = MaritalStatusScore
};
sb.AddWeight(weight, "MaritalStatus", ref summary);
weight = new Weight {
Value = NumOfLoans.ToString(CultureInfo.InvariantCulture),
FinalWeight = NumOfLoansWeight,
Grade = (int)NumOfLoansGrade,
Score = NumOfLoansScore
};
sb.AddWeight(weight, "NumOfLoans", ref summary);
weight = new Weight {
Value = NumOfLateRepayments.ToString(CultureInfo.InvariantCulture),
FinalWeight = NumOfLateRepaymentsWeight,
Grade = (int)NumOfLateRepaymentsGrade,
Score = NumOfLateRepaymentsScore
};
sb.AddWeight(weight, "NumOfLateRepayments", ref summary);
weight = new Weight {
Value = NumOfEarlyRepayments.ToString(CultureInfo.InvariantCulture),
FinalWeight = NumOfEarlyRepaymentsWeight,
Grade = (int)NumOfEarlyRepaymentsGrade,
Score = NumOfEarlyRepaymentsScore
};
sb.AddWeight(weight, "NumOfEarlyRepayments", ref summary);
weight = new Weight {
Value = AnnualTurnover.ToString(CultureInfo.InvariantCulture),
FinalWeight = AnnualTurnoverWeight,
Grade = (int)AnnualTurnoverGrade,
Score = AnnualTurnoverScore
};
sb.AddWeight(weight, "AnnualTurnover", ref summary);
weight = new Weight {
Value = FreeCashFlow.ToString(CultureInfo.InvariantCulture),
FinalWeight = FreeCashFlowWeight,
Grade = (int)FreeCashFlowGrade,
Score = FreeCashFlowScore
};
sb.AddWeight(weight, "FreeCashFlow", ref summary);
weight = new Weight {
Value = NetWorth.ToString(CultureInfo.InvariantCulture),
FinalWeight = NetWorthWeight,
Grade = (int)NetWorthGrade,
Score = NetWorthScore
};
sb.AddWeight(weight, "NetWorth", ref summary);
bool isOnline =
MedalType == MedalType.OnlineLimited ||
MedalType == MedalType.OnlineNonLimitedNoBusinessScore ||
MedalType == MedalType.OnlineNonLimitedWithBusinessScore;
if (isOnline)
{
weight = new Weight {
Value = NumberOfStores.ToString(CultureInfo.InvariantCulture),
FinalWeight = NumberOfStoresWeight,
Grade = (int)NumberOfStoresGrade,
Score = NumberOfStoresScore
};
sb.AddWeight(weight, "NumOfStores", ref summary);
weight = new Weight {
Value = PositiveFeedbacks.ToString(CultureInfo.InvariantCulture),
FinalWeight = PositiveFeedbacksWeight,
Grade = (int)PositiveFeedbacksGrade,
Score = PositiveFeedbacksScore
};
sb.AddWeight(weight, "PositiveFeedbacks", ref summary);
} // if
sb.AppendLine("----------------------------------------------------------------------------------------------------------------------------------------");
sb.AppendFormat("{0}| {1}| {2}| {3}| {4}| {5}| {6}| {7}| {8}\n",
"Sum".PadRight(25),
StringBuilderExtention.ToShort(summary.FinalWeight)
.PadRight(10),
"-".PadRight(10),
"-".PadRight(10),
"-".PadRight(10),
"-".PadRight(10),
summary.Grade.ToString(CultureInfo.InvariantCulture)
.PadRight(10),
StringBuilderExtention.ToShort(summary.Score)
.PadRight(10), summary.Value);
return(sb.ToString());
} // ToString
protected void LoadScheme2()
{
OwnerTable = "PROJECTS";
this.Fields.Add(new QField("PrjId", LocRM.GetString("PrjId"), "ProjectId", DbType.Int32, QFieldUsingType.Field | QFieldUsingType.Grouping | QFieldUsingType.Filter | QFieldUsingType.Sort, true));
this.Fields.Add(new QField("PrjTitle", LocRM.GetString("PrjTitle"), "Title", DbType.String, QFieldUsingType.Field | QFieldUsingType.Grouping | QFieldUsingType.Filter | QFieldUsingType.Sort, false));
this.Fields.Add(new QField("PrjCreator", LocRM.GetString("PrjCreator"), "{0}.LastName + ' ' + {0}.FirstName", DbType.String, QFieldUsingType.Field | QFieldUsingType.Grouping | QFieldUsingType.Filter | QFieldUsingType.Sort,
new QFieldJoinRelation(this.OwnerTable, "USERS", "CreatorId", "PrincipalId")));
this.Fields.Add(new QField("PrjCreatorId", LocRM.GetString("PrjCreatorId"), "PrincipalId", DbType.Int32, QFieldUsingType.Abstract,
new QFieldJoinRelation(this.OwnerTable, "USERS", "CreatorId", "PrincipalId")));
this.Dictionary.Add(new QDictionary(this.Fields["PrjCreatorId"], this.Fields["PrjCreator"], "SELECT DISTINCT PrincipalId as Id, (LastName + ' ' + FirstName) as Value FROM USERS WHERE PrincipalId IN (SELECT CreatorId FROM PROJECTS) ORDER BY [Value]"));
this.Fields.Add(new QField("PrjManager", LocRM.GetString("PrjManager"), "{0}.LastName + ' ' + {0}.FirstName", DbType.String, QFieldUsingType.Field | QFieldUsingType.Grouping | QFieldUsingType.Filter | QFieldUsingType.Sort,
new QFieldJoinRelation(this.OwnerTable, "USERS", "ManagerId", "PrincipalId")));
this.Fields.Add(new QField("PrjManagerId", LocRM.GetString("PrjManagerId"), "PrincipalId", DbType.Int32, QFieldUsingType.Abstract,
new QFieldJoinRelation(this.OwnerTable, "USERS", "ManagerId", "PrincipalId")));
this.Dictionary.Add(new QDictionary(this.Fields["PrjManagerId"], this.Fields["PrjManager"], "SELECT DISTINCT PrincipalId as Id, (LastName + ' ' + FirstName) as Value FROM USERS WHERE PrincipalId IN (SELECT ManagerId FROM PROJECTS) ORDER BY [Value]"));
this.Fields.Add(new QField("PrjExecutiveManager", LocRM.GetString("PrjExecutiveManager"), "{0}.LastName + ' ' + {0}.FirstName", DbType.String, QFieldUsingType.Field | QFieldUsingType.Grouping | QFieldUsingType.Filter | QFieldUsingType.Sort,
new QFieldJoinRelation(this.OwnerTable, "USERS", "ExecutiveManagerId", "PrincipalId")));
this.Fields.Add(new QField("PrjExecutiveManagerId", LocRM.GetString("PrjExecutiveManagerId"), "PrincipalId", DbType.Int32, QFieldUsingType.Abstract,
new QFieldJoinRelation(this.OwnerTable, "USERS", "ManagerId", "PrincipalId")));
this.Dictionary.Add(new QDictionary(this.Fields["PrjExecutiveManagerId"], this.Fields["PrjExecutiveManager"], "SELECT DISTINCT PrincipalId as Id, (LastName + ' ' + FirstName) as Value FROM USERS WHERE PrincipalId IN (SELECT ExecutiveManagerId FROM PROJECTS) ORDER BY [Value]"));
this.Fields.Add(new QField("PrjCreationDate", LocRM.GetString("PrjCreationDate"), "CreationDate", DbType.DateTime, QFieldUsingType.Field | QFieldUsingType.Grouping | QFieldUsingType.Filter | QFieldUsingType.Sort, false));
this.Fields.Add(new QField("PrjStartDate", LocRM.GetString("PrjStartDate"), "StartDate", DbType.DateTime, QFieldUsingType.Field | QFieldUsingType.Grouping | QFieldUsingType.Filter | QFieldUsingType.Sort, false));
this.Fields.Add(new QField("PrjFinishDate", LocRM.GetString("PrjFinishDate"), "FinishDate", DbType.DateTime, QFieldUsingType.Field | QFieldUsingType.Grouping | QFieldUsingType.Filter | QFieldUsingType.Sort, false));
this.Fields.Add(new QField("PrjTargetFinishDate", LocRM.GetString("PrjTargetFinishDate"), "TargetFinishDate", DbType.DateTime, QFieldUsingType.Field | QFieldUsingType.Grouping | QFieldUsingType.Filter | QFieldUsingType.Sort, false));
this.Fields.Add(new QField("PrjActualFinishDate", LocRM.GetString("PrjActualFinishDate"), "ActualFinishDate", DbType.DateTime, QFieldUsingType.Field | QFieldUsingType.Grouping | QFieldUsingType.Filter | QFieldUsingType.Sort, false));
this.Fields.Add(new QField("PrjStatus", LocRM.GetString("PrjStatus"), "StatusName", DbType.String, QFieldUsingType.Field | QFieldUsingType.Grouping | QFieldUsingType.Filter | QFieldUsingType.Sort,
new QFieldJoinRelation(this.OwnerTable, "PROJECT_STATUS_LANGUAGE", "StatusId", "StatusId", "LanguageId")));
this.Fields.Add(new QField("PrjStatusId", "PrjStatusId", "StatusId", DbType.Int32, QFieldUsingType.Abstract,
new QFieldJoinRelation(this.OwnerTable, "PROJECT_STATUS_LANGUAGE", "StatusId", "StatusId", "LanguageId")));
this.Dictionary.Add(new QDictionary(this.Fields["PrjStatusId"], this.Fields["PrjStatus"], "SELECT StatusId as Id, StatusName as Value FROM PROJECT_STATUS_LANGUAGE WHERE LanguageId = {0}"));
// this.Fields.Add(new QField("PrjClient",LocRM.GetString("PrjClient"),"ClientName", DbType.String,QFieldUsingType.Field|QFieldUsingType.Grouping|QFieldUsingType.Filter|QFieldUsingType.Sort,
// new QFieldJoinRelation(this.OwnerTable,"CLIENTS","ClientId","ClientId")));
//
// this.Fields.Add(new QField("PrjClientId","PrjClientId","ClientId", DbType.Int32,QFieldUsingType.Abstract,
// new QFieldJoinRelation(this.OwnerTable,"CLIENTS","ClientId","ClientId")));
//
// this.Dictionary.Add(new QDictionary(this.Fields["PrjClientId"],this.Fields["PrjClient"],"SELECT ClientId as Id, ClientName as Value FROM CLIENTS"));
this.Fields.Add(new QField("PrjGeneralCategories", LocRM.GetString("PrjGeneralCategories"), "CategoryName", DbType.String, QFieldUsingType.Field | QFieldUsingType.Grouping | QFieldUsingType.Filter,
new QFieldJoinRelation[]
{
new QFieldJoinRelation(this.OwnerTable, "OBJECT_CATEGORY", "ProjectId", "ObjectId",
new SimpleFilterCondition(new QField("ObjectTypeId"), ((int)ObjectTypes.Project).ToString(), SimpleFilterType.Equal)),
new QFieldJoinRelation("OBJECT_CATEGORY", "CATEGORIES", "CategoryId", "CategoryId")
}));
this.Fields.Add(new QField("PrjGeneralCategoriesId", "PrjGeneralCategoriesId", "CategoryId", DbType.Int32, QFieldUsingType.Abstract,
new QFieldJoinRelation[]
{
new QFieldJoinRelation(this.OwnerTable, "OBJECT_CATEGORY", "ProjectId", "ObjectId",
new SimpleFilterCondition(new QField("ObjectTypeId"), ((int)ObjectTypes.Project).ToString(), SimpleFilterType.Equal)),
new QFieldJoinRelation("OBJECT_CATEGORY", "CATEGORIES", "CategoryId", "CategoryId")
}));
this.Dictionary.Add(new QDictionary(this.Fields["PrjGeneralCategoriesId"], this.Fields["PrjGeneralCategories"], "SELECT CategoryId As Id, CategoryName As Value FROM CATEGORIES"));
this.Fields.Add(new QField("PrjProjectCategories", LocRM.GetString("PrjProjectCategories"), "CategoryName", DbType.String, QFieldUsingType.Field | QFieldUsingType.Grouping | QFieldUsingType.Filter,
new QFieldJoinRelation[]
{
new QFieldJoinRelation(this.OwnerTable, "PROJECT_CATEGORY", "ProjectId", "ProjectId"),
new QFieldJoinRelation("PROJECT_CATEGORY", "PROJECT_CATEGORIES", "CategoryId", "CategoryId")
}));
this.Fields.Add(new QField("PrjProjectCategoriesId", "PrjProjectCategoriesId", "CategoryId", DbType.Int32, QFieldUsingType.Abstract,
new QFieldJoinRelation[]
{
new QFieldJoinRelation(this.OwnerTable, "PROJECT_CATEGORY", "ProjectId", "ProjectId"),
new QFieldJoinRelation("PROJECT_CATEGORY", "PROJECT_CATEGORIES", "CategoryId", "CategoryId")
}));
this.Dictionary.Add(new QDictionary(this.Fields["PrjProjectCategoriesId"], this.Fields["PrjProjectCategories"], "SELECT CategoryId As Id, CategoryName As Value FROM PROJECT_CATEGORIES"));
this.Fields.Add(new QField("PrjResources", LocRM.GetString("PrjResources"), "{0}.LastName + ' ' + {0}.FirstName", DbType.String, QFieldUsingType.Field | QFieldUsingType.Grouping | QFieldUsingType.Filter,
new QFieldJoinRelation[]
{
new QFieldJoinRelation(this.OwnerTable, "PROJECT_MEMBERS", "ProjectId", "ProjectId"),
new QFieldJoinRelation("PROJECT_MEMBERS", "USERS", "PrincipalId", "PrincipalId")
}));
this.Fields.Add(new QField("PrjResourcesId", "PrjResourcesId", "PrincipalId", DbType.Int32, QFieldUsingType.Abstract,
new QFieldJoinRelation[]
{
new QFieldJoinRelation(this.OwnerTable, "PROJECT_MEMBERS", "ProjectId", "ProjectId"),
new QFieldJoinRelation("PROJECT_MEMBERS", "USERS", "PrincipalId", "PrincipalId")
}));
this.Dictionary.Add(new QDictionary(this.Fields["PrjResourcesId"], this.Fields["PrjResources"], "SELECT DISTINCT PrincipalId as Id, (LastName + ' ' + FirstName) as Value FROM USERS WHERE PrincipalId IN (SELECT PrincipalId FROM PROJECT_MEMBERS) ORDER BY [Value]"));
// this.Fields.Add(new QField("PrjTargetBudget",LocRM.GetString("PrjTargetBudget"), "TargetBudget",DbType.Decimal,QFieldUsingType.Field|QFieldUsingType.Grouping|QFieldUsingType.Filter, false));
// this.Fields.Add(new QField("PrjEstimatedBudget",LocRM.GetString("PrjEstimatedBudget"), "EstimatedBudget",DbType.Decimal,QFieldUsingType.Field|QFieldUsingType.Grouping|QFieldUsingType.Filter, false));
// this.Fields.Add(new QField("PrjActualBudget",LocRM.GetString("PrjActualBudget"), "ActualBudget",DbType.Decimal,QFieldUsingType.Field|QFieldUsingType.Grouping|QFieldUsingType.Filter, false));
// Project Types [12/17/2004]
this.Fields.Add(new QField("PrjType", LocRM.GetString("PrjType"), "FormName", DbType.String, QFieldUsingType.Field | QFieldUsingType.Grouping | QFieldUsingType.Filter | QFieldUsingType.Sort,
new QFieldJoinRelation(this.OwnerTable, "OBJECT_FORMS", "FormId", "FormId", new SimpleFilterCondition(new QField("ObjectTypeId"), ((int)ObjectTypes.Project).ToString(), SimpleFilterType.Equal))));
this.Fields.Add(new QField("PrjTypeId", "PrjTypeId", "FormId", DbType.Int32, QFieldUsingType.Abstract,
new QFieldJoinRelation(this.OwnerTable, "OBJECT_FORMS", "FormId", "FormId", new SimpleFilterCondition(new QField("ObjectTypeId"), ((int)ObjectTypes.Project).ToString(), SimpleFilterType.Equal))));
this.Dictionary.Add(new QDictionary(this.Fields["PrjTypeId"], this.Fields["PrjType"], "SELECT FormId as Id, FormName as Value FROM OBJECT_FORMS WHERE ObjectTypeId = 3"));
// PercentCompleted [1/13/2005]
this.Fields.Add(new QField("PrjPercentCompleted", LocRM.GetString("PrjPercentCompleted"), "PercentCompleted", DbType.Int32, QFieldUsingType.Field | QFieldUsingType.Grouping | QFieldUsingType.Filter | QFieldUsingType.Sort));
// PriorityId [1/13/2005]
this.Fields.Add(new QField("PrjPriority", LocRM.GetString("PrjPriority"), "PriorityName", DbType.String, QFieldUsingType.Field | QFieldUsingType.Grouping | QFieldUsingType.Filter | QFieldUsingType.Sort,
new QFieldJoinRelation(this.OwnerTable, "PRIORITY_LANGUAGE", "PriorityId", "PriorityId", "LanguageId")));
this.Fields.Add(new QField("PrjPriorityId", "PrjPriorityId", "PriorityId", DbType.Int32, QFieldUsingType.Abstract,
new QFieldJoinRelation(this.OwnerTable, "PRIORITY_LANGUAGE", "PriorityId", "PriorityId", "LanguageId")));
this.Dictionary.Add(new QDictionary(this.Fields["PrjPriorityId"], this.Fields["PrjPriority"], "SELECT PriorityId as Id, PriorityName as Value FROM PRIORITY_LANGUAGE WHERE LanguageId = {0}"));
// Phase [3/35/2005]
this.Fields.Add(new QField("PrjPhase", LocRM.GetString("PrjPhase"), "PhaseName", DbType.String, QFieldUsingType.Field | QFieldUsingType.Grouping | QFieldUsingType.Filter | QFieldUsingType.Sort,
new QFieldJoinRelation(this.OwnerTable, "PROJECT_PHASES", "PhaseId", "PhaseId")));
this.Fields.Add(new QField("PrjPhaseId", "PrjPhaseId", "PhaseId", DbType.Int32, QFieldUsingType.Abstract,
new QFieldJoinRelation(this.OwnerTable, "PROJECT_PHASES", "PhaseId", "PhaseId")));
this.Dictionary.Add(new QDictionary(this.Fields["PrjPhaseId"], this.Fields["PrjPhase"], "SELECT PhaseId as Id, PhaseName as Value FROM PROJECT_PHASES"));
// Portfolio [3/35/2005]
this.Fields.Add(new QField("PrjPortfolio", LocRM.GetString("PrjPortfolio"), "Title", DbType.String, QFieldUsingType.Field | QFieldUsingType.Grouping | QFieldUsingType.Filter,
new QFieldJoinRelation[]
{
new QFieldJoinRelation(this.OwnerTable, "PROJECT_GROUP", "ProjectId", "ProjectId"),
new QFieldJoinRelation("PROJECT_GROUP", "PROJECT_GROUPS", "ProjectGroupId", "ProjectGroupId")
}));
this.Fields.Add(new QField("PrjPortfolioId", "PrjPortfolioId", "ProjectGroupId", DbType.Int32, QFieldUsingType.Abstract,
new QFieldJoinRelation[]
{
new QFieldJoinRelation(this.OwnerTable, "PROJECT_GROUP", "ProjectId", "ProjectId"),
new QFieldJoinRelation("PROJECT_GROUP", "PROJECT_GROUPS", "ProjectGroupId", "ProjectGroupId")
}));
this.Dictionary.Add(new QDictionary(this.Fields["PrjPortfolioId"], this.Fields["PrjPortfolio"], "SELECT ProjectGroupId as Id, Title as Value FROM PROJECT_GROUPS"));
// OZ: 2006-12-12 New Finance by business Score (Current plan)
foreach (BusinessScore bs in BusinessScore.List())
{
this.Fields.Add(new QField(string.Format("PrjBs{0}", bs.Key),
string.Format("{0} ({1})", bs.Name, LocRM.GetString("PrjCurrentPlan")),
"(SELECT CAST(SUM(Value) AS MONEY) FROM BusinessScoreData WHERE [Index] = 0 AND BusinessScoreId = " + bs.BusinessScoreId + " AND ProjectId = {0}.ProjectId)",
DbType.Decimal,
QFieldUsingType.Field | /*QFieldUsingType.Grouping|*/ QFieldUsingType.Filter | QFieldUsingType.Sort,
new QFieldJoinRelation(this.OwnerTable, "BusinessScoreData", "ProjectId", "ProjectId")));
}
// TODO: OZ: 2007-07-12 New Finance by business Score (Fact)
//foreach (BusinessScore bs in BusinessScore.List())
//{
// this.Fields.Add(new QField(string.Format("PrjBs{0}", bs.Key),
// string.Format("{0} ({1})", bs.Name, LocRM.GetString("PrjFact")),
// "(SELECT SUM(Value) FROM BusinessScoreData WHERE [Index] = 0 AND BusinessScoreId = " + bs.BusinessScoreId + " AND ProjectId = {0}.ProjectId)",
// DbType.Decimal,
// QFieldUsingType.Field |/*QFieldUsingType.Grouping|*/QFieldUsingType.Filter | QFieldUsingType.Sort,
// new QFieldJoinRelation(this.OwnerTable, "BusinessScoreData", "ProjectId", "ProjectId")));
//}
// 2006-12-13 OZ: Client
//this.Fields.Add(new QField("PrjClient", LocRM.GetString("PrjClient"),
// "(ISNULL((SELECT O.OrgName FROM Organizations O WHERE O.OrgId = {0}.OrgId),(SELECT V.FullName FROM VCard V WHERE V.VCardId = {0}.VCardId)))",
// DbType.String,
// QFieldUsingType.Field | QFieldUsingType.Grouping | QFieldUsingType.Filter | QFieldUsingType.Sort));
//this.Fields.Add(new QField("PrjClientId", "PrjClientId",
// "(ISNULL({0}.OrgId,-{0}.VCardId))",
// DbType.Int32,
// QFieldUsingType.Abstract));
//this.Dictionary.Add(new QDictionary(this.Fields["PrjClientId"], this.Fields["PrjClient"],
// "SELECT (O.OrgId) AS Id , O.OrgName as Value FROM Organizations O UNION SELECT (-V.VCardId) AS Id , V.FullName as Value FROM VCard V"));
// 2007-10-17 New Field is assigned with TimeTracking
this.Fields.Add(new QField("PrjTaskTime", LocRM.GetString("TaskTime"), "TaskTime", DbType.Time, QFieldUsingType.Field | QFieldUsingType.Grouping | QFieldUsingType.Filter | QFieldUsingType.Sort, false));
this.Fields.Add(new QField("PrjTotalMinutes", LocRM.GetString("TotalMinutes"), "TotalMinutes", DbType.Time, QFieldUsingType.Field | QFieldUsingType.Grouping | QFieldUsingType.Filter | QFieldUsingType.Sort, false));
this.Fields.Add(new QField("PrjTotalApproved", LocRM.GetString("TotalApproved"), "TotalApproved", DbType.Time, QFieldUsingType.Field | QFieldUsingType.Grouping | QFieldUsingType.Filter | QFieldUsingType.Sort, false));
///////////////////////////
// 2008-10-20 New Clients
// Organization OrgUid
this.Fields.Add(new QField("PrjOrg", LocRM.GetString("PrjOrganization"), "Name", DbType.String, QFieldUsingType.Field | QFieldUsingType.Grouping | QFieldUsingType.Filter | QFieldUsingType.Sort,
new QFieldJoinRelation(this.OwnerTable, "cls_Organization", "OrgUid", "OrganizationId")));
this.Fields.Add(new QField("PrjOrgUid", "PrjOrgUid", "OrganizationId", DbType.Guid, QFieldUsingType.Abstract,
new QFieldJoinRelation(this.OwnerTable, "cls_Organization", "OrgUid", "OrganizationId")));
this.Dictionary.Add(new QDictionary(this.Fields["PrjOrgUid"], this.Fields["PrjOrg"],
"SELECT DISTINCT OrganizationId as Id, Name as Value FROM cls_Organization ORDER BY Value"));
// Contact ContactUid
this.Fields.Add(new QField("PrjContact", LocRM.GetString("PrjContact"), "FullName", DbType.String, QFieldUsingType.Field | QFieldUsingType.Grouping | QFieldUsingType.Filter | QFieldUsingType.Sort,
new QFieldJoinRelation(this.OwnerTable, "cls_Contact", "ContactUid", "ContactId")));
this.Fields.Add(new QField("PrjContactUid", "PrjContactUid", "ContactId", DbType.Guid, QFieldUsingType.Abstract,
new QFieldJoinRelation(this.OwnerTable, "cls_Contact", "ContactUid", "ContactId")));
this.Dictionary.Add(new QDictionary(this.Fields["PrjContactUid"], this.Fields["PrjContact"],
"SELECT DISTINCT ContactId as Id, FullName as Value FROM cls_Contact ORDER BY Value"));
// Client
this.Fields.Add(new QField("PrjClient", LocRM.GetString("PrjClient"), "Name", DbType.String, QFieldUsingType.Field | QFieldUsingType.Grouping | QFieldUsingType.Filter,
new QFieldJoinRelation[]
{
new QFieldJoinRelation(this.OwnerTable, "ProjectClients", "ProjectId", "ProjectId"),
new QFieldJoinRelation(this.OwnerTable, "Clients", "ClientId", "ClientId")
}));
this.Fields.Add(new QField("PrjClientUid", "ClientId", "ClientId", DbType.Guid, QFieldUsingType.Abstract,
new QFieldJoinRelation[]
{
new QFieldJoinRelation(this.OwnerTable, "ProjectClients", "ProjectId", "ProjectId"),
new QFieldJoinRelation(this.OwnerTable, "Clients", "ClientId", "ClientId")
}));
this.Dictionary.Add(new QDictionary(this.Fields["PrjClientUid"], this.Fields["PrjClient"],
"SELECT DISTINCT ClientId as Id, Name as Value FROM Clients ORDER BY Value"));
///////////////////////////
// 2008-11-12
this.Fields.Add(new QField("PrjGoals", LocRM.GetString("PrjGoals"), "Goals", DbType.String, QFieldUsingType.Field | QFieldUsingType.Filter, false));
this.Fields.Add(new QField("PrjScope", LocRM.GetString("PrjScope"), "Scope", DbType.String, QFieldUsingType.Field | QFieldUsingType.Filter, false));
this.Fields.Add(new QField("PrjDeliverables", LocRM.GetString("PrjDeliverables"), "Deliverables", DbType.String, QFieldUsingType.Field | QFieldUsingType.Filter, false));
this.Fields.Add(new QField("PrjDescription", LocRM.GetString("PrjDescription"), "Description", DbType.String, QFieldUsingType.Field | QFieldUsingType.Filter, false));
// 2009-08-24
this.Fields.Add(new QField("PrjCode", LocRM.GetString("PrjCode"), "ProjectCode", DbType.String, QFieldUsingType.Field | QFieldUsingType.Filter | QFieldUsingType.Sort, false));
//Description
// Meta Fields
MetaClass mcProjects = MetaClass.Load("Projects");
if (mcProjects.ChildClasses.Count > 0)
{
QMetaLoader.LoadMetaField(this, mcProjects.ChildClasses[_ExtensionsId]);
for (int ExIndex = 0; ExIndex < mcProjects.ChildClasses.Count; ExIndex++)
{
if (ExIndex != _ExtensionsId && mcProjects.ChildClasses[ExIndex].UserMetaFields.Count > 0)
{
QMetaLoader.LoadMetaField(this, mcProjects.ChildClasses[ExIndex]);
}
}
if (_ExtensionsId == 0)
{
for (int ExIndex = 1; ExIndex < mcProjects.ChildClasses.Count; ExIndex++)
{
if (mcProjects.ChildClasses[ExIndex].UserMetaFields.Count > 0)
{
QProject newExtension = new QProject(ExIndex);
this._Extensions.Add(newExtension);
}
}
}
}
}
private void BindDG()
{
if (ddDictionaries.SelectedValue == "0") //Business Score
{
dgScore.Visible = true;
dgPlanSlot.Visible = false;
dgDic.Visible = false;
dgEnum.Visible = false;
dgScore.Columns[1].HeaderText = LocRM.GetString("tKey");
dgScore.Columns[2].HeaderText = LocRM.GetString("Name");
dgScore.DataSource = GetTable(BusinessScore.List()).DefaultView;
dgScore.DataBind();
foreach (DataGridItem dgi in dgScore.Items)
{
ImageButton ib = (ImageButton)dgi.FindControl("ibDelete2");
if (ib != null)
{
ib.Attributes.Add("onclick", "return confirm('" + LocRM.GetString("Warning") + "')");
}
RequiredFieldValidator rf = (RequiredFieldValidator)dgi.FindControl("rfKey");
if (rf != null)
{
rf.ErrorMessage = LocRM.GetString("Required");
}
RequiredFieldValidator rf2 = (RequiredFieldValidator)dgi.FindControl("rfName2");
if (rf2 != null)
{
rf2.ErrorMessage = LocRM.GetString("Required");
}
}
}
else if (ddDictionaries.SelectedValue == "-1") //Base Plan Slot
{
dgScore.Visible = false;
dgDic.Visible = false;
dgPlanSlot.Visible = true;
dgEnum.Visible = false;
dgPlanSlot.Columns[1].HeaderText = LocRM.GetString("Name");
dgPlanSlot.Columns[2].HeaderText = LocRM.GetString("tIsDefault");
dgPlanSlot.DataSource = GetTableSlot(BasePlanSlot.List()).DefaultView;
dgPlanSlot.DataBind();
foreach (DataGridItem dgi in dgPlanSlot.Items)
{
ImageButton ib = (ImageButton)dgi.FindControl("ibDelete3");
if (ib != null)
{
ib.Attributes.Add("onclick", "return confirm('" + LocRM.GetString("Warning") + "')");
}
RequiredFieldValidator rf3 = (RequiredFieldValidator)dgi.FindControl("rfName3");
if (rf3 != null)
{
rf3.ErrorMessage = LocRM.GetString("Required");
}
}
}
else if (ddDictionaries.SelectedValue == ListManager.ListTypeEnumName) //List Types
{
dgScore.Visible = false;
dgPlanSlot.Visible = false;
dgDic.Visible = false;
dgEnum.Visible = true;
dgEnum.DataSource = GetListTable().DefaultView;
dgEnum.DataBind();
foreach (DataGridItem row in dgEnum.Items)
{
ImageButton ib = (ImageButton)row.FindControl("ibDelete");
if (ib != null)
{
ib.Attributes.Add("onclick", "return confirm('" + GetGlobalResourceObject("IbnFramework.GlobalMetaInfo", "Delete").ToString() + "?')");
}
TextBox tb = (TextBox)row.FindControl("txtName");
HtmlImage im = (HtmlImage)row.FindControl("imResourceTemplate");
RequiredFieldValidator rfv = (RequiredFieldValidator)row.FindControl("rfName");
if (im != null && tb != null && rfv != null)
{
im.Attributes.Add("onclick", "SetText('" + tb.ClientID + "','{ResourceName:ResourceKey}','" + rfv.ClientID + "')");
}
}
if (dgEnum.EditItemIndex >= 0)
{
DropDownList ddl = (DropDownList)dgEnum.Items[dgEnum.EditItemIndex].FindControl("ddlOrder");
if (ddl != null)
{
for (int i = 1; i <= dgEnum.Items.Count; i++)
{
ddl.Items.Add(i.ToString());
}
ddl.SelectedIndex = dgEnum.EditItemIndex;
}
}
}
else
{
dgScore.Visible = false;
dgPlanSlot.Visible = false;
dgDic.Visible = true;
dgEnum.Visible = false;
dgDic.Columns[1].HeaderText = LocRM.GetString("Name");
dgDic.Columns[2].HeaderText = LocRM.GetString("tWeight");
//dgDic.Columns[3].HeaderText = LocRM.GetString("Options");
DictionaryTypes dic = (DictionaryTypes)Enum.Parse(typeof(DictionaryTypes), ddDictionaries.SelectedItem.Value);
DataView dv = Dictionaries.GetList(dic).DefaultView;
// dv.Sort = "ItemName";
dgDic.DataSource = dv;
dgDic.DataBind();
foreach (DataGridItem dgi in dgDic.Items)
{
ImageButton ib = (ImageButton)dgi.FindControl("ibDelete");
if (ib != null)
{
ib.Attributes.Add("onclick", "return confirm('" + LocRM.GetString("Warning") + "')");
}
RequiredFieldValidator rf = (RequiredFieldValidator)dgi.FindControl("rfName");
if (rf != null)
{
rf.ErrorMessage = LocRM.GetString("Required");
}
}
}
}
protected void btnAddNewItem_Click(object sender, System.EventArgs e)
{
if (ddDictionaries.SelectedValue == "0")
{
DataTable dt = GetTable(BusinessScore.List());
DataRow dr = dt.NewRow();
dr["BusinessScoreId"] = -1;
dr["Key"] = "";
dr["Name"] = "";
dt.Rows.Add(dr);
dgScore.EditItemIndex = dt.Rows.Count - 1;
dgScore.DataSource = dt.DefaultView;
dgScore.DataBind();
}
else if (ddDictionaries.SelectedValue == "-1")
{
DataTable dt = GetTableSlot(BasePlanSlot.List());
DataRow dr = dt.NewRow();
dr["BasePlanSlotId"] = -1;
dr["Name"] = "";
dr["IsDefault"] = false;
dt.Rows.Add(dr);
dgPlanSlot.EditItemIndex = dt.Rows.Count - 1;
dgPlanSlot.DataSource = dt.DefaultView;
dgPlanSlot.DataBind();
}
else if (ddDictionaries.SelectedValue == ListManager.ListTypeEnumName) //List Types
{
DataTable dt = GetListTable();
DataRow dr = dt.NewRow();
dr["Id"] = -1;
dr["OrderId"] = dt.Rows.Count + 1;
dr["Name"] = "";
dt.Rows.Add(dr);
dgEnum.EditItemIndex = dt.Rows.Count - 1;
dgEnum.DataSource = dt.DefaultView;
dgEnum.DataBind();
DropDownList ddl = (DropDownList)dgEnum.Items[dgEnum.EditItemIndex].FindControl("ddlOrder");
if (ddl != null)
{
for (int i = 1; i <= dgEnum.Items.Count; i++)
{
ddl.Items.Add(i.ToString());
}
ddl.SelectedIndex = dgEnum.EditItemIndex;
}
}
else
{
DictionaryTypes dic = (DictionaryTypes)Enum.Parse(typeof(DictionaryTypes), ddDictionaries.SelectedItem.Value);
DataTable dt = Dictionaries.GetList(dic);
DataRow dr = dt.NewRow();
dr["ItemId"] = -1;
dr["ItemName"] = "";
dr["Weight"] = 0;
dr["CanDelete"] = 0;
dt.Rows.Add(dr);
dgDic.EditItemIndex = dt.Rows.Count - 1;
dgDic.DataSource = dt.DefaultView;
dgDic.DataBind();
}
}
