private void BindGrid()
{
List <Training> tList = Training.Trainings.FindAll(
delegate(Training tg)
{
return(tg.IsPublished == true);
});
tList.Sort(delegate(Training t1, Training t2)
{
return(t2.ViewCount.CompareTo(t1.ViewCount));
});
List <Training> topTen = new List <Training>(9);
for (int i = 0; i < tList.Count; i++)
{
topTen.Add(tList[i]);
if (i == 8)
{
break;
}
}
GridFields.DataSource = topTen;
GridFields.DataBind();
}
private void BindGrid()
{
List <Training> tList = Training.Trainings.FindAll(
delegate(Training tg)
{
return(tg.IsPublished == true && tg.Teacher == Request["uid"]);
});
GridFields.DataSource = tList;
GridFields.DataBind();
}
private void BindGrid()
{
List <Training> tList = Training.Trainings.FindAll(
delegate(Training tg)
{
return(tg.IsPublished == true && tg.IsGold == true);
});
if (!isTopShow)
{
GridFields.Columns[1].Visible = false;
}
GridFields.DataSource = tList;
GridFields.DataBind();
}
public Dictionary <string, object> BindNextData(GridFields Data)
{
FAMSEntities context = new FAMSEntities();
try
{
//Data.PageCount = Data.PageCount - 1;
var UserId = Dbsecurity.Decrypt(Data.UserId);
var results = Common.Getdata(context.MultipleResults("[dbo].[Sp_Portfolio_Fact]").With <PageLoadData>()
.Execute("@Querytype", "@CustomerAccount", "@UserId", "@PageCount", "NextRecords", Data.CustomerAccountNo, UserId, Data.PageCount));
return(results);
}
catch (Exception ex)
{
throw ex;
}
}
private void BindGrid()
{
List <Res> cls = Res.Ress.FindAll(
delegate(Res c)
{
return(c.Description != "Update by Excellent" &&
c.Description != "Profile" &&
c.IsPublished == true &&
c.Author == strID); //only return Created by Owner
});
// sort in descending order
cls.Sort(delegate(Res c1, Res c2)
{ return(DateTime.Compare(c2.DateCreated, c1.DateCreated)); });
Ress = cls;
GridFields.DataSource = Ress;
GridFields.DataBind();
}
//public Dictionary<string, object> BindDefaultData(GridFields Data)
//{
// FAMSEntities context = new FAMSEntities();
// try
// {
// var UserId = Dbsecurity.Decrypt(Data.UserId);
// var results = Common.Getdata(context.MultipleResults("[dbo].[Sp_Portfolio_Fact]").With<PageLoadData>()
// .Execute("@Querytype", "@UserId", "GetDefault_StatemenetOfExpenses", UserId));
// return results;
// }
// catch (Exception ex)
// {
// throw ex;
// }
//}
public Dictionary <string, object> BindDefaultData(GridFields Data)
{
FAMSEntities context = new FAMSEntities();
try
{
var UserId = Dbsecurity.Decrypt(Data.UserId);
// var CustomerAccountNo = Dbsecurity.Decrypt(Data.CustomerAccountNo);
var CustomerAccountNo = (Data.CustomerAccountNo);
var results = Common.Getdata(context.MultipleResults("[dbo].[Sp_Portfolio_Fact]").With <PageLoadData>()
.Execute("@Querytype", "@UserId", "@CustomerAccount", "GetDefault_Factportfolio2", UserId, CustomerAccountNo));
return(results);
}
catch (Exception ex)
{
throw ex;
}
}
public Dictionary <string, object> BindGrid(GridFields Data)
{
try
{
//var UserId = Dbsecurity.Decypt(Data.UserId);
//var CustomerAccountNo = Dbsecurity.Decrypt(Data.CustomerAccountNo);
var CustomerAccountNo = (Data.CustomerAccountNo);
var results = Common.Getdata(context.MultipleResults("[dbo].[Sp_Portfolio_Fact]").With <SectorAllocation>().With <SUMSectorAllocation>().With <PortfolioHolding>().With <SUMPortfolioHolding>().With <portfolioSummary>().With <PortfolioPerformance>().With <HDATE>().Execute("@QueryType", "@PageCount", "@Fromdate", "@Todate", "@CustomerAccount", "BindMainGrid", Data.PageCount, Data.fromdate, Data.todate, CustomerAccountNo));
return(results); //
}
catch (Exception ex)
{
throw ex;
}
}
private void BindGrid()
{
List <Field> l1 = new List <Field>();
List <Field> l2 = new List <Field>();
int l1Count = getGridSourceCount();
for (int i = 0; i < Field.Fields.Count; i++)
{
if (l1Count > i)
{
l1.Add(Field.Fields[i]);
}
else
{
l2.Add(Field.Fields[i]);
}
}
GridFields.DataSource = l1;
GridView1.DataSource = l2;
GridFields.DataBind();
GridView1.DataBind();
}
private void InitGrid()
{
if (_gridFields != null)
{
// Reset Bindings to unused lists
GridFields.ResetBindings();
}
_gridFields = new BindingList <GridField>();
_gridFields.ListChanged += GridCollection_PropertyChanged;
_isGridInitialized = false;
Log(LogType.Info, "Initalize new sudoku grid");
_gridFields.Clear();
// initialize a new grid of fields (including predefined ones)
foreach (Field field in _gridService.GenerateInitialGrid())
{
if (field.Value != 0)
{
_gridFields.Add(new GridField(field, false));
}
else
{
_gridFields.Add(new GridField(field, true));
}
}
UpdateStats();
Notify(nameof(GridFields));
_isGridInitialized = true;
}
public Dictionary <string, object> BindGridView(GridFields Data)
{
return(ObjDAL.BindGridView(Data));
}
public Dictionary <string, object> BindDefaultData(GridFields Data)
{
return(ObjDAL.BindDefaultData(Data));
}
public Dictionary <string, object> BindNextDataApi(GridFields Data)
{
return(Obj.BindNextData(Data));
}
public Dictionary <string, object> BindEmployeesApi(GridFields Data)
{
return(Obj.BindEmployees(Data));
}
public Dictionary <string, object> BindGrid(GridFields Data)
{
return(Obj.BindGrid(Data));
}
public Dictionary <string, object> BindGridOncustomerChange(GridFields Data)
{
return(ObjDAL.BindGridOncustomerChange(Data));
}
public string PDFReport(GridFields Data)
{
//var reportDto = JsonConvert.DeserializeObject<User>("abhi");
//byte[] bytes;
//using (var reportViewer = new ReportViewer())
//{
// reportViewer.ProcessingMode = ProcessingMode.Local;
// reportViewer.LocalReport.ReportEmbeddedResource = reportDto.Location;
// if (reportDto.Accounts != null)
// {
// foreach (ParameterDTO parameter in reportDto.Accounts)
// {
// reportViewer.LocalReport.SetParameters(new ReportParameter(parameter.Name, parameter.Data));
// }
// }
// if (reportDto.Badges != null)
// {
// var dt = new DataTable();
// foreach (DataSourceDto dataSource in reportDto.Badges)
// {
// dt.Columns.Add(dataSource.Name, typeof(string));
// }
// DataRow dr = dt.NewRow();
// for (int index = 0; index < reportDto.Badges.Count; index++)
// {
// dr[index] = reportDto.DataSources[index].Data;
// }
// dt.Rows.Add(dr);
// reportViewer.LocalReport.DataSources.Add(new ReportDataSource(reportDto.ReportDataSourceName, dt));
// }
FAMSEntities context = new FAMSEntities();
FAMSEntities dbcontext = new FAMSEntities();
// var reportViewer = new ReportViewer();
// var results = Common.Getdata(context.MultipleResults("[dbo].[Sp_StatementDividend]").With<StatementDividentModel>().With<SDSum>().With<HDATE>().Execute("@QueryType", "@PageCount", "@Fromdate", "@Todate", "@CustomerAccount", "BindMainGrid", Data.PageCount, Data.fromdate, Data.todate, CustomerAccountNo));
var Result = dbcontext.MultipleResults("[dbo].[Sp_StatementDividend]").With <StatementDividentModel>().With <SDSum>().With <HDATE>().Execute("@QueryType", "@PageCount", "@Fromdate", "@Todate", "@CustomerAccount", "BindMainGrid", Data.PageCount, Data.fromdate, Data.todate, Data.CustomerAccountNo);
// ds = objManager.FillDatasetWithParam("sp_Report", "@QueryType", "@RestroId", "@FromDate", "@ToDate", "@ItemMenuGroupID"
//, "@UserId", "DailySalesReport", restroid, date, todate, itemgroupid, UserId);
//results[0].Cast<StatementDividentModel>().ToList();
DataTable dt = ToDataTable(Result[0].Cast <StatementDividentModel>().ToList());
DataTable dt1 = ToDataTable(Result[2].Cast <HDATE>().ToList());
DataTable dt2 = ToDataTable(Result[1].Cast <SDSum>().ToList());
byte[] bytes;
using (var reportViewer = new ReportViewer())
{
reportViewer.ProcessingMode = ProcessingMode.Local;
//reportViewer.LocalReport.ReportPath = Server.MapPath("~/Report/StatementDividend.rdlc");
reportViewer.LocalReport.ReportPath = System.Web.Hosting.HostingEnvironment.MapPath("~/Report/StatementDividend.rdlc");
//DateTime dat = DateTime.Parse(date);
//DateTime todat = DateTime.Parse(todate);
//ds.Tables[0].Columns.Add("Date", typeof(System.String));
//foreach (DataRow dr in ds.Tables[0].Rows)
//{
// //need to set value to MyRow column
// // dr["BranchName"] = "Daily Sales Report"; // or set it to some other value
// dr["Date"] = dat.ToString("yyyy-MM-dd HH:mm:ss") + " - " + todat.ToString("yyyy-MM-dd HH:mm:ss");
//}
ReportDataSource datasource = new ReportDataSource("DataSet1", dt);
ReportDataSource datasource1 = new ReportDataSource("DataSet2", dt1);
ReportDataSource datasource2 = new ReportDataSource("DataSet3", dt2);
//ReportViewer1.LocalReport.EnableExternalImages = true;
//var path = "~/RestroImage/" + restroid + ".jpg";
//string imagePath = new Uri(Server.MapPath(path)).AbsoluteUri;
//ReportParameter parameter = new ReportParameter("ImagePath", imagePath);//D:\Rproject\FRD_Web\FRDWeb\FRDWeb\RestroImage\1.jpg
//ReportViewer1.LocalReport.SetParameters(parameter);
//ReportViewer1.LocalReport.Refresh();
reportViewer.LocalReport.DataSources.Clear();
reportViewer.LocalReport.DataSources.Add(datasource);
reportViewer.LocalReport.DataSources.Add(datasource1);
reportViewer.LocalReport.DataSources.Add(datasource2);
Warning[] warnings;
string[] streamids;
string mimeType;
string encoding;
string extension;
bytes = reportViewer.LocalReport.Render("Pdf", null, out mimeType, out encoding, out extension, out streamids, out warnings);
}
//var cd = new System.Net.Mime.ContentDisposition
//{
// FileName = string.Format("SampleReport.pdf"),
// Inline = true,
//};
var result1 = new HttpResponseMessage(HttpStatusCode.OK);
//Stream stream = new MemoryStream(bytes);
MemoryStream stream = new MemoryStream(bytes);
//result.Content = new StreamContent(stream);
//result.Content.Headers.ContentType = new MediaTypeHeaderValue("application/pdf");
//return result;
return(Convert.ToBase64String(stream.ToArray()));
}
public Dictionary <string, object> ChangeAccountFunApi(GridFields Data)
{
return(Obj.ChangeAccountFun(Data));
}
protected override void Execute(NativeActivityContext context)
{
const string isnullerrorformat = "Свойство '{0}' должно быть задано.";
var gridFieldsStr = GridFields.Get(context);
if (string.IsNullOrEmpty(gridFieldsStr))
{
throw new DeveloperException(isnullerrorformat, GridFieldsDisplayName);
}
_objNameGrid = new List <string>(gridFieldsStr.Split(new [] { ' ', ',' }, StringSplitOptions.RemoveEmptyEntries));
var productList = ProductList.Get(context);
var operationCode = OperationCode.Get(context);
var needShowGreed = NeedShowSelectGrid.Get(context);
try
{
var productsList = new List <Tuple <string, Product> >();
var userGrpPrd = new List <Product>();
//получим настройки менеджера товара
using (var mgr = IoC.Instance.Resolve <IPMConfigManager>())
{
foreach (var prd in productList)
{
var groupKeys = new StringBuilder();
//обязательная группировка по skuid
groupKeys.AppendFormat("{0}={1}_", Product.SKUIDPropertyName, prd.SKUID);
var confs = mgr.GetPMConfigByParamListByProductId(prd.ProductId, operationCode, null).ToArray();
//формируем группы по товару и настройке менеджера товара
foreach (var pmConfig in confs.OrderBy(x => x.ObjectName_r))
{
var prdprop = prd.GetProperty(pmConfig.ObjectName_r) ?? string.Empty;
_objNameGrid.Add(pmConfig.ObjectName_r);
groupKeys.AppendFormat("{0}={1}_", pmConfig.ObjectName_r, prdprop);
}
productsList.Add(new Tuple <string, Product>(groupKeys.ToString(), prd));
}
}
//формируем коллекцию товара для отображения + сумма по группам
var grpPoductsList = productsList.GroupBy(p => p.Item1, v => v.Item2).ToArray();
foreach (var gr in grpPoductsList)
{
var product = (Product)gr.First().Clone();
product.ProductCountSKU = gr.Sum(p => p.ProductCountSKU);
userGrpPrd.Add(product);
}
//если всего 1 группа и needShowGreed == false, грид не показываем
if (grpPoductsList.Length == 1 && !needShowGreed)
{
OutGroupProductList.Set(context, userGrpPrd);
OutProductList.Set(context, grpPoductsList[0].ToList());
return;
}
var dialogRet = ShowMain(userGrpPrd);
//выбираем товар, в соответствии с выбором пользователя
var outGroupProductList = new List <Product>();
var outProductList = new List <Product>();
if (dialogRet && _selectedPrd != null)
{
outGroupProductList = userGrpPrd.Where(p => p.GetKey <decimal>() == _selectedPrd).ToList();
var grkey = (from gr in grpPoductsList where gr.Any(p => p.GetKey <decimal>() == _selectedPrd) select gr.Key).FirstOrDefault();
outProductList = grpPoductsList.Where(g => g.Key == grkey).SelectMany(p => p).ToList();
}
OutGroupProductList.Set(context, outGroupProductList);
OutProductList.Set(context, outProductList);
DialogResult.Set(context, dialogRet);
}
catch (Exception ex)
{
var message = "Ошибка при получении настроек менеджера товара. " +
ExceptionHelper.GetErrorMessage(ex, false);
ShowWarning(message);
}
}
