private void FatchTest()
{
try
{
EWA_UploadResult objEWA = new EWA_UploadResult();
BL_UploadResult objBL = new BL_UploadResult();
objEWA.OrgId = Session["OrgId"].ToString();
objEWA.CourseId = CourseId.ToString();
objEWA.BranchId = BranchId.ToString();
objEWA.ClassId = ClassId.ToString();
objEWA.SemesterId = ddlSemester.SelectedValue.ToString();
DataSet ds = objBL.FatchTest_BL(objEWA);
ddlTest.DataSource = ds;
if (ds.Tables[0].Rows.Count != 0)
{
ddlTest.DataTextField = "TestName";
ddlTest.DataValueField = "TestId";
ddlTest.DataBind();
}
else
{
ddlTest.Items.Clear();
}
ddlTest.Items.Insert(0, new System.Web.UI.WebControls.ListItem("Select", "0"));
}
catch (Exception exp)
{
GeneralErr(exp.Message.ToString());
}
}
public virtual void WriteYaml(YamlWriter writer)
{
writer.WriteMap("ID", Id.ToString("D"));
writer.WriteMap("Parent", ParentId.ToString("D"));
writer.WriteMap("Template", TemplateId.ToString("D"));
writer.WriteMap("Path", Path);
writer.WriteMap("DB", DatabaseName);
if (BranchId != default(Guid))
{
writer.WriteMap("BranchID", BranchId.ToString());
}
if (SharedFields.Any())
{
writer.WriteMap("SharedFields");
writer.IncreaseIndent();
foreach (var field in SharedFields)
{
field.WriteYaml(writer);
}
writer.DecreaseIndent();
}
if (Languages.Any())
{
writer.WriteMap("Languages");
writer.IncreaseIndent();
foreach (var language in Languages)
{
language.WriteYaml(writer);
}
writer.DecreaseIndent();
}
}
public Dictionary <string, string> GetByName()
{
var result = new Dictionary <string, string>
{
{ "Id", Id },
{ "UserId", UserId.ToString() },
{ "UserName", UserName },
{ "Name", Name },
{ "Phone", Phone },
{ "Email", Email },
{ "Expired", Expired.ToString() },
{ "ActiveBranchId", ActiveBranchId.ToString() },
{ "ParentBranchId", ParentBranchId.ToString() },
{ "ActiveRoleName", ActiveRoleName },
{ "RoleNames", RoleNames },
{ "ActiveRoleId", ActiveRoleId.ToString() },
{ "RoleIds", RoleIds },
{ "PermittedBranchs", PermittedBranchs },
{ "UniqueName", UniqueName },
{ "BranchId", BranchId.ToString() },
};
return(result);
}
string GetCmdText(int Step) //fold00
{
AccCode = AccCode.Trim();
ClientCode = ClientCode.Trim();
CurrencyTag = CurrencyTag.Trim().ToUpper();
string Result = " exec dbo.Mega_Extract";
switch (Step)
{
case 1: {
Result += ";1 "
+ " @DateFrom=" + DateFrom.ToString()
+ " , @DateInto=" + DateInto.ToString()
+ " , @OverMode=" + (OverMode & 3).ToString()
+ " , @OverDate=" + DateInto.ToString()
+ " , @FlgTag=" + ((CurrencyTag == "") ? "0" : "1")
+ " , @CbMode=" + ((CbMode) ? "2" : "1")
+ " , @UserId=" + UserId.ToString()
+ " , @ClientCode='" + ClientCode + "'"
+ " , @BranchId=" + BranchId.ToString()
+ " , @GroupId=" + GroupId.ToString()
+ " , @AmountCode='" + __.GetCodeByMoniker(AccCode) + "%'"
+ " , @CurrencyTag='" + ((CurrencyTag == "UAH") ? "" : CurrencyTag) + "'"
+ " , @AllAmounts=" + ((AllAmounts) ? "1" : "0")
+ " , @AmountMode= 0 , @IsExpected=0 "
;
break;
}
case 2: {
Result += ";4 "
+ " @DateFrom=" + DateFrom.ToString()
+ " , @DateInto=" + DateInto.ToString()
+ " , @OverMode=" + (OverMode & 3).ToString()
+ " , @OverDate=" + DateInto.ToString()
+ " , @AmountId=" + Accounts_ExtId.ToString()
+ " , @ShowSubRate=1 , @Mode=1 , @Depth=1 "
;
break;
}
case 3: {
int Date = Amounts_LastDate;
if (__.Month(Date) < __.Month(DateFrom))
{
Date = __.GetDate(__.Year(DateFrom) + "/" + __.Month(DateFrom).ToString("00") + "/01") - 1;
}
Result += ";5 "
+ " @DateFrom=" + (Date + 1).ToString()
+ " , @DateInto=" + Amounts_DateInto.ToString()
+ " , @AmountId=" + Accounts_RootId.ToString()
+ " , @SortMode=" + (SortMode & 7).ToString()
+ " , @IsRight=0 , @IsExpected=0 "
;
break;
}
case 4: {
Result += (((DateFrom == DateInto) && (DateFrom == TODAY)) ? ";6 " : ";5 ")
+ " @DateFrom=" + DateFrom.ToString()
+ " , @DateInto=" + DateInto.ToString()
+ " , @AmountId=" + Accounts_ExtId.ToString()
+ " , @SortMode=" + (SortMode & 7).ToString()
+ " , @IsRight=0 , @IsExpected=0 "
;
break;
}
}
return(Result);
} //FOLD00