protected override void ClearData()
{
if (CompaniesList != null)
{
CompaniesList.Clear();
}
}
/// <summary>
/// ResponseHandlerSymbolSamples
/// </summary>
/// <param name="obj"></param>
private void ResponseHandlerSymbolSamples(IBSampleApp.messages.SymbolSamplesMessage obj)
{
BackgroundLog = Brushes.White;
var message = string.Empty;
LogCurrent.Add($"{obj.ContractDescriptions.Count()} symbols found for company {CurrentCompany}. {CompaniesList.Count()} companies more.");
CompaniesList.Remove(CurrentCompany);
var contracts = SymbolManager.FilterSymbols(CurrentCompany, obj, ExchangeIbSelected);
LogCurrent.Add($"{contracts.Count()} symbols filtered out for company {CurrentCompany}");
try
{
if (!contracts.Any())
{
ProcessNotResolved();
ProcessDatabaseBatch();
return;
}
ProcessResolved(contracts);
ProcessDatabaseBatch();
}
catch (Exception exception)
{
LogCurrent.Add(exception.ToString());
}
}
public void RemoveOldOrders()
{
int i;
for (i = 0; i < BuyList.List.Count; i++)
{
BuyList.List[i].Age = BuyList.List[i].Age + 1;
if ((BuyList.List[i].Owner == null) && (BuyList.List[i].Age >= 30))
{
BuyList.List.RemoveAt(i);
i--;
}
}
for (i = 0; i < SellList.List.Count; i++)
{
SellList.List[i].Age = SellList.List[i].Age + 1;
if ((SellList.List[i].Owner == null) && (SellList.List[i].Age >= 30))
{
int number = CompaniesList.FindNumber(SellList.List[i].CompanyName);
CompaniesList.List[number].CurrentQuantity = CompaniesList.List[number].CurrentQuantity + SellList.List[i].CurrentQuantity;
SellList.List.RemoveAt(i);
i--;
}
}
}
// ////////////////////////////////////////////////////////////////////////
// EVENTS
//
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
// ... Access to this page
if (!Convert.ToBoolean(Session["sgLFS_CWP_FULLLENGTHLINING_VIEW"]))
{
Response.Redirect("./../../error_page.aspx?error=" + "You are not authorized to view this page. Contact your system administrator.");
}
// Prepare initial data
hdfCompanyId.Value = Session["companyID"].ToString();
hdfCurrentClientId.Value = Request.QueryString["client_id"].ToString();
hdfCurrentProjectId.Value = Request.QueryString["project_id"].ToString();
int companyId = Int32.Parse(hdfCompanyId.Value);
CompaniesList companiesList = new CompaniesList();
companiesList.LoadAndAddItem(-1, "(All)", companyId);
ddlClient.DataSource = companiesList.Table;
ddlClient.DataValueField = "COMPANIES_ID";
ddlClient.DataTextField = "Name";
ddlClient.DataBind();
if (Request.QueryString["client_id"] != null)
{
ddlClient.SelectedValue = Request.QueryString["client_id"];
// ... for project
ProjectList projectList = new ProjectList();
projectList.LoadProjectsAndAddItem(-1, "(All)", int.Parse(ddlClient.SelectedValue));
ddlProject.DataSource = projectList.Table;
ddlProject.DataValueField = "ProjectID";
ddlProject.DataTextField = "Name";
ddlProject.DataBind();
ddlProject.SelectedValue = Request.QueryString["project_id"];
}
else
{
ddlClient.SelectedValue = "-1";
// ... for project
ProjectList projectList = new ProjectList();
projectList.LoadProjectsAndAddItem(-1, "(All)", -1);
ddlProject.DataSource = projectList.Table;
ddlProject.DataValueField = "ProjectID";
ddlProject.DataTextField = "Name";
ddlProject.DataBind();
ddlProject.SelectedValue = Request.QueryString["project_id"];
}
// Register delegates
this.RegisterDelegates();
}
else
{
// Register delegates
this.RegisterDelegates();
}
}
public void CreateCompaniesList()
{
using (CompaniesList list = (CompaniesList)ModulesManager.Current.OpenModuleObjectDetail(new CompaniesListObject(Session), false)) {
CompaniesListView companiesListView = CompaniesListView.LastCreatedView;
Assert.IsNotNull(companiesListView);
Assert.IsNotNull(companiesListView.Module);
Assert.AreEqual(list, companiesListView.Module);
}
}
// На редактирование
public AddEditUserViewModel(User user) : this()
{
id = user.Id;
Login = user.Login;
Password = user.Password;
SelectedCompany = CompaniesList.FirstOrDefault(x => x.Id == user.CompanyId);
Header = "Редактирование сотрудника";
}
/// <summary>
/// ProcessDatabaseBatch
/// </summary>
private void ProcessDatabaseBatch()
{
if (CompaniesProcessed.Count() > 0 && CompaniesProcessed.Count() % Convert.ToInt32(Configuration.Instance["BatchSizeDatabase"]) == 0 ||
CompaniesList.Count() == 0)
{
DataContext.Instance.SaveChanges();
LogCurrent.Add("OK! Current batch saved in database.");
}
}
public void MakeDeals(List <SharePacket> buy, List <SharePacket> sell)// DODELAT
{
int i = 0;
int j = 0;
while (i < buy.Count && j < sell.Count)
{
if (buy[i].Owner != null && buy[i].Owner == sell[j].Owner)
{
i++;
continue;
}
if (buy[i].Price < sell[j].Price)
{
break;
}
var qty = Math.Min(buy[i].CurrentQuantity, sell[j].CurrentQuantity);
buy[i].CurrentQuantity -= qty;
sell[j].CurrentQuantity -= qty;
if (buy[i].Owner == Player.Current.Name)
{
var price = Math.Min(buy[i].Price, sell[j].Price);
OnBuy(buy[i], qty, price);
}
else if (sell[j].Owner == Player.Current.Name)
{
var price = Math.Min(buy[i].Price, sell[j].Price);
OnSell(sell[j], qty, price);
}
else
{
CompaniesList.List[CompaniesList.FindNumber(sell[j].CompanyName)].CurrentQuantity += qty;
}
if (buy[i].CurrentQuantity == 0)
{
i++;
continue;
}
if (sell[j].CurrentQuantity == 0)
{
j++;
continue;
}
}
foreach (var packet in buy)
{
BuyList.List.Add(packet);
}
BuyList.RemoveEmptyEntries();
foreach (var packet in sell)
{
SellList.List.Add(packet);
}
SellList.RemoveEmptyEntries();
}
private void GetUIDataFromDB()
{
FlightsViewModel.GetAllCities().ForEach(c => CitiesList.Add(c));
CitiesList.Insert(0, "Not selected");
SelectedCity = CitiesList[0];
FlightsViewModel.GetAllCompanies().ForEach(c => CompaniesList.Add(c.name));
CompaniesList.Insert(0, "Not selected");
SelectedCompany = CompaniesList[0];
SelectTrips();
}
public void ChangeCompanyByList_OpenDetail_CheckChanges()
{
using (CompaniesList list = (CompaniesList)ModulesManager.Current.OpenModuleObjectDetail(new CompaniesListObject(Session), false)) {
Company company = SessionHelper.GetObject <Company>(FoxCompany, list.CompaniesEdit.VRObjectsEditObject.VideoRentObjects.Session);
company.Tag = "changed tag";
using (CompanyDetail detail = (CompanyDetail)list.OpenDetail(company.Oid)) {
Assert.AreEqual("changed tag", detail.CompanyEdit.VRObjectEditObject.VideoRentObject.Tag);
}
}
}
/// <summary>
/// Accepts Companies object, batch delete row(s) from Companies table
///
/// return compID of deleted row(s)
/// </summary>
/// <param name="Companies">Companies object</param>
/// <param name="sqlCmd">SqlCommand object</param>
/// <returns>compID of deleted row(s)</returns>
public static Int32 Delete(CompaniesList objCompaniesList, SqlCommand sqlCmd)
{
try
{
foreach (Companies item in objCompaniesList)
{
Delete(item, sqlCmd);
}
return(objCompaniesList.Count);
}
catch (Exception ex) { throw ex; }
}
/// <summary>
/// Accepts Companies object, batch delete row(s) from Companies table
///
/// return compID of deleted row(s)
/// </summary>
/// <param name="Companies">Companies object</param>
/// <returns>compID of deleted row(s)</returns>
public static Int32 Delete(CompaniesList objCompaniesList)
{
SqlCommand sqlCmd = new SqlCommand(Companies_Delete, SqlHelper.DefaultSqlConnection);
try
{
sqlCmd.Connection.Open();
sqlCmd.Transaction = sqlCmd.Connection.BeginTransaction();
Delete(objCompaniesList, sqlCmd);
sqlCmd.Transaction.Commit();
return(objCompaniesList.Count);
}
catch (Exception ex)
{
sqlCmd.Transaction.Rollback();
throw ex;
}
finally { sqlCmd.Connection.Close(); }
}
public async Task <IViewComponentResult> InvokeAsync(ClaimsPrincipal User)
{
using (var con = new SqlConnection(configuration.GetConnectionString("DefaultConnection")))
{
var UserId = User.Identity.Name;
con.Open();
SqlCommand CompaniesQuery = new SqlCommand("SELECT Name,CreateDate,CreatorName,Companies.id,former From Companies INNER JOIN Worker ON Companies.id=Worker.CompanyID WHERE CreatorName = '" + UserId + "';", con);
var Read = CompaniesQuery.ExecuteReader();
CompaniesList CompanyL = new CompaniesList();
List <string> employees = new List <string>();
while (Read.Read())
{
CompanyL.CompanyList.Add(new Models.Companies((int)Read.GetInt32(Read.GetOrdinal("Id")), Read[0].ToString(), employees, Read[1].ToString(), Read[2].ToString(), Read.GetInt32(4)));
}
return(View(CompanyL));
}
}
/// ////////////////////////////////////////////////////////////////////////
/// EVENTS
///
protected void Page_Load(object sender, System.EventArgs e)
{
if (!IsPostBack)
{
// Security check
// ... Access to this page
if (!Convert.ToBoolean(Session["sgLFS_APP_VIEW"]))
{
Response.Redirect("./../../error_page.aspx?error=" + "You are not authorized to view this page. Contact your system administrator.");
}
// Prepare initial data
int companyId = Int32.Parse(Session["companyID"].ToString());
CompaniesList companiesList = new CompaniesList();
companiesList.LoadAndAddItem(-1, "(All)", companyId);
ddlSelectAClient.DataSource = companiesList.Table;
ddlSelectAClient.DataValueField = "COMPANIES_ID";
ddlSelectAClient.DataTextField = "Name";
if (Request.QueryString["client"] != null)
{
ddlSelectAClient.SelectedValue = Request.QueryString["client"];
}
else
{
ddlSelectAClient.SelectedValue = "-1";
}
// Databind
ddlSelectAClient.DataBind();
// Register delegates
this.RegisterDelegates();
}
else
{
// Register delegates
this.RegisterDelegates();
}
}
// ////////////////////////////////////////////////////////////////////////
// EVENTS
//
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
// Security check
if (!(Convert.ToBoolean(Session["sgLFS_PROJECTS_VIEW"]) && Convert.ToBoolean(Session["sgLFS_PROJECTS_ADMIN"])))
{
Response.Redirect("./../../error_page.aspx?error=" + "You are not authorized to view this page. Contact your system administrator.");
}
// Prepare initial data
// ... for client
int companyId = Int32.Parse(Session["companyID"].ToString());
CompaniesList companiesList = new CompaniesList();
companiesList.LoadAndAddItem(-1, "(All)", companyId);
ddlClient.DataSource = companiesList.Table;
ddlClient.DataTextField = "Name";
ddlClient.DataValueField = "COMPANIES_ID";
// ... for salesman
SalesmanList salesmanList = new SalesmanList();
salesmanList.LoadAndAddItem(-1, "(All)");
ddlSalesman.DataSource = salesmanList.Table;
ddlSalesman.DataValueField = "SalesmanID";
ddlSalesman.DataTextField = "FullName";
ddlSalesman.DataBind();
// DataBind
this.DataBind();
// Register delegates
this.RegisterDelegates();
}
else
{
// Register delegates
this.RegisterDelegates();
}
}
protected void FetchCompaniesList()
{
//MySqlConnection connection = new MySqlConnection
//{
//ConnectionString = ConfigurationManager.ConnectionStrings["MySQLTest"].ToString()
//};
//MySqlCommand command = new MySqlCommand("SELECT Name FROM `shobingg_P2M_Operations`.`Clients Invoices` group by Company", connection)
//{
//CommandType = System.Data.CommandType.Text
//};
//MySqlDataAdapter dataAdapter = new MySqlDataAdapter("SELECT ID,Name FROM `shobingg_P2M_Operations`.`Company` ", connection);
//DataTable dataTable = new DataTable();
//dataAdapter.Fill(dataTable);
//connection.Open();
//CompaniesList.DataSource = dataTable;
//CompaniesList.DataTextField = "Name";
//CompaniesList.DataValueField = "ID";
//CompaniesList.DataBind();
//connection.Close();
CompanyDAL companies = new CompanyDAL
{
ConnectionString = ConfigurationManager.ConnectionStrings["MySQLTest"].ToString()
};
CompaniesList.DataSource = companies.GetCompany(null);
CompaniesList.DataTextField = "Name";
CompaniesList.DataValueField = "ID";
CompaniesList.DataBind();
CompaniesList.Items.Insert(0, new ListItem("--Select Company--", "0"));
}
/// <summary>
/// Accepts CompaniesList object, batch updated row(s) into Companies table
///
/// return compID of updated row(s)
/// </summary>
/// <param name="Companies">Companies object</param>
/// <param name="sqlCmd">SqlCommand object</param>
/// <returns>compID of updated row(s)</returns>
public static Int32 Update(CompaniesList objCompaniesList, SqlCommand sqlCmd)
{
try
{
foreach (Companies item in objCompaniesList)
{
if (item.compID == 0)
{
item.compID = Insert(item, sqlCmd);
}
else if (item.compID > 0)
{
Update(item, sqlCmd);
}
else
{
throw new InvalidOperationException("Companies object was not in specified format");
}
}
return(objCompaniesList.Count);
}
catch (Exception ex) { throw ex; }
}
public CompaniesListView(CompaniesList moviesList)
: base(moviesList)
{
LastCreatedView = this;
}
public static List <CompaniesList> GetList()
{
List <CompaniesList> objlist = new List <CompaniesList>();
CompaniesList obj = new CompaniesList();
obj.Code = "INDUSINDBK";
obj.MainLink = "http://www.moneycontrol.com/india/stockpricequote/banks-private-sector/indusindbank/IIB";
obj.Category = "BN";
obj.CommentsLink = "http://mmb.moneycontrol.com/stock-message-forum/indusindbank/comments/666";
objlist.Add(obj);
obj = new CompaniesList();
obj.Code = "FEDERALBNK";
obj.MainLink = "http://www.moneycontrol.com/india/stockpricequote/banks-private-sector/federalbank/FB";
obj.Category = "BN";
obj.CommentsLink = "http://mmb.moneycontrol.com/stock-message-forum/federalbank/comments/6423";
objlist.Add(obj);
obj = new CompaniesList();
obj.Code = "KOTAKBANK";
obj.MainLink = "http://www.moneycontrol.com/india/stockpricequote/banks-private-sector/kotakmahindrabank/KMB";
obj.Category = "BN";
obj.CommentsLink = "http://mmb.moneycontrol.com/stock-message-forum/kotakmahindrabank/comments/3441";
objlist.Add(obj);
obj = new CompaniesList();
obj.Code = "HDFCBANK";
obj.MainLink = "http://www.moneycontrol.com/india/stockpricequote/banks-private-sector/hdfcbank/HDF01";
obj.Category = "BN";
obj.CommentsLink = "http://mmb.moneycontrol.com/stock-message-forum/hdfcbank/comments/4962";
objlist.Add(obj);
obj = new CompaniesList();
obj.Code = "BANKBARODA";
obj.MainLink = "http://www.moneycontrol.com/india/stockpricequote/banks-public-sector/bankofbaroda/BOB";
obj.Category = "BN";
obj.CommentsLink = "http://mmb.moneycontrol.com/stock-message-forum/bankofbaroda/comments/261";
objlist.Add(obj);
obj = new CompaniesList();
obj.Code = "SBIN";
obj.MainLink = "http://www.moneycontrol.com/india/stockpricequote/banks-public-sector/statebankindia/SBI";
obj.Category = "BN";
obj.CommentsLink = "";
objlist.Add(obj);
obj = new CompaniesList();
obj.Code = "IDFCBANK";
obj.MainLink = "http://www.moneycontrol.com/india/stockpricequote/banks-private-sector/idfcbank/IDF01";
obj.Category = "BN";
obj.CommentsLink = "";
objlist.Add(obj);
obj = new CompaniesList();
obj.Code = "ICICIBANK";
obj.MainLink = "http://www.moneycontrol.com/india/stockpricequote/banks-private-sector/icicibank/ICI02";
obj.Category = "BN";
obj.CommentsLink = "";
objlist.Add(obj);
obj = new CompaniesList();
obj.Code = "CANBK";
obj.MainLink = "http://www.moneycontrol.com/india/stockpricequote/banks-public-sector/canarabank/CB06";
obj.Category = "BN";
obj.CommentsLink = "";
objlist.Add(obj);
obj = new CompaniesList();
obj.Code = "PNB";
obj.MainLink = "http://www.moneycontrol.com/india/stockpricequote/banks-public-sector/punjabnationalbank/PNB05";
obj.Category = "BN";
obj.CommentsLink = "";
objlist.Add(obj);
obj = new CompaniesList();
obj.Code = "AXISBANK";
obj.MainLink = "http://www.moneycontrol.com/india/stockpricequote/banks-private-sector/axisbank/AB16";
obj.Category = "BN";
obj.CommentsLink = "";
objlist.Add(obj);
obj = new CompaniesList();
obj.Code = "YESBANK";
obj.MainLink = "http://www.moneycontrol.com/india/stockpricequote/banks-private-sector/yesbank/YB";
obj.Category = "BN";
obj.CommentsLink = "";
objlist.Add(obj);
return(objlist);
}
public ActionResult StudentHomeDetails()
{
CompaniesList complist = new CompaniesList();
return(View(complist));
}
public void ListIsSorted()
{
using (CompaniesList companieslist = (CompaniesList)ModulesManager.Current.OpenModuleObjectDetail(new CompaniesListObject(Session), false)) {
Assert.AreNotEqual(0, companieslist.VRObjectsListObject.CompaniesEditObject.VideoRentObjects.Sorting.Count);
}
}
