private void CalendarGames_Load(object sender, EventArgs e)
{
try
{
clGame = new CGame(connect);
clTeam = new CTeam(connect);
clDivision = new CDivision(connect);
clGroup = new CGroup(connect);
// init_combo();
this.WindowState = FormWindowState.Maximized;
gpos = 0;
bDivision = false;
bType = false;
iIdDivision = -1;
iIdType = -1;
init_combo();
init_data();
recom = null;
}
catch (Exception ex) { MessageBox.Show(ex.Message, ex.Source); }
}
/* »Ќ»÷»јЋ»«ј÷»я —ѕ»— ќ¬ */
/* +++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ */
/* инициализаци¤ списка дивизионов */
private void init_combo_division()
{
try
{
if (gType == 2)
{
comboBoxDivision.Enabled = false;
}
else
{
comboBoxDivision.Items.Clear();
comboBoxDivision.Text = null;
clDivision = new CDivision(connect);
List <STDivision> list = clDivision.GetListDivision(IS.idseason);
if (list.Count > 0)
{
comboBoxDivision.Items.Add("");
foreach (STDivision item in list)
{
comboBoxDivision.Items.Add(item.name);
}
}
else
{
comboBoxDivision.Enabled = false;
}
}
}
catch (Exception ex) { MessageBox.Show(ex.Message, ex.Source); }
}
private void buttonSearch_Click(object sender, EventArgs e)
{
CDivision cl;
string name = null;
try
{
if (comboBoxDivision.Text.Length > 0)
{
name = comboBoxDivision.Text.Trim();
cl = new CDivision(connect, IS.idseason, name);
bDivision = true;
iIdDivision = cl.stDiv.id;
}
else
{
bDivision = false;
iIdDivision = 0;
}
init_data();
}
catch (Exception ex) { MessageBox.Show(ex.Message, ex.Source); }
}
private void set_data()
{
if (gstGroup.idgroup > 0)
{
clDivision = new CDivision(connect, IS.idseason, gstGroup.iddivision);
comboBoxDivision.Text = clDivision.stDiv.name;
textBoxNameGroup.Text = gstGroup.namegroup;
CScheme scheme = new CScheme(connect, (int)IS.idseason, gstGroup.iddivision, gstGroup.idstage);
comboBoxStage.Text = scheme.stScheme.namestage;
textBoxCntTeam.Text = gstGroup.cntteam.ToString();
textBoxCntTeamNext.Text = gstGroup.cntteamnext.ToString();
}
else
{
comboBoxDivision.Text = null;
textBoxNameGroup.Text = null;
textBoxCntTeam.Text = null;
comboBoxStage.Text = null;
textBoxCntTeamNext.Text = null;
}
textBoxNameGroup.Focus();
}
private STVotePCA read_data()
{
STVotePCA ret = new STVotePCA();
try
{
ret.idseason = idseason;
ret.name = textBoxName.Text.Trim();
ret.ip = textBoxIP.Text.Trim();
ret.email = textBoxEmail.Text.Trim();
char[] del = { ' ', '(', ')' };
string s = comboBoxPlayer.Text.Trim();
string[] words = s.Split(del);
CDivision clDiv = new CDivision(connect, idseason, comboBoxDivision.Text.Trim());
ret.iddivision = clDiv.stDiv.id;
CPlayer clPlayer = new CPlayer(connect, words[0].Trim(), words[1].Trim(), words[3].Trim());
ret.idplayer = clPlayer.stPlayer.idplayer;
ret.ed = new DateTime(dateTimePickerDate.Value.Year, dateTimePickerDate.Value.Month,
dateTimePickerDate.Value.Day, dateTimePickerTime.Value.Hour, dateTimePickerTime.Value.Minute,
0, 0);
}
catch (Exception ex) { MessageBox.Show(ex.Message, ex.Source); }
return(ret);
}
public static string ObtenerDivisiones()
{
JObject Respuesta = new JObject();
CUtilerias.DelegarAccion(delegate(CConexion pConexion, int Error, string DescripcionError, CUsuario UsuarioSesion) {
if (Error == 0)
{
JObject Modelo = new JObject();
CDivision Divisiones = new CDivision();
Dictionary <string, object> pParametros = new Dictionary <string, object>();
pParametros.Add("Baja", 0);
JArray Opciones = new JArray();
foreach (CDivision Division in Divisiones.LlenaObjetosFiltros(pParametros, pConexion))
{
JObject Opcion = new JObject();
Opcion.Add("Valor", Division.IdDivision);
Opcion.Add("Descripcion", Division.Division);
Opciones.Add(Opcion);
}
Modelo.Add("Divisiones", Opciones);
Respuesta.Add("Modelo", Modelo);
}
Respuesta.Add("Error", Error);
Respuesta.Add("Descripcion", DescripcionError);
});
return(Respuesta.ToString());
}
private void PreViewGame_Load(object sender, EventArgs e)
{
try
{
clTeam = new CTeam(connect);
clGame = new CGame(connect);
clIS = new CInfoSeason(connect);
clDivision = new CDivision(connect);
team1 = new STTeam();
team2 = new STTeam();
init_combo_season();
init_combo_division();
init_combo_group();
init_combo_team();
cnt = 0;
}
catch (Exception ex) { MessageBox.Show(ex.Message, ex.Source); }
}
private void init_combo()
{
try
{
if (IS.cntdivision > 0)
{
CDivision div = new CDivision(connect);
List <STDivision> list_div = div.GetListDivision((int)IS.idseason);
foreach (STDivision item in list_div)
{
comboBoxNameDivision.Items.Add(item.name);
}
if (list_div.Count > 0)
{
comboBoxNameDivision.Text = comboBoxNameDivision.Items[0].ToString();
idCurrDiv = list_div[0].id;
}
init_data(idCurrDiv);
}
else
{
comboBoxNameDivision.Enabled = false;
}
}
catch (Exception ex) { MessageBox.Show(ex.Message); }
}
private void init_combo()
{
CDivision cld = new CDivision(connect, IS.idseason, idcdiv);
try
{
comboBoxTypes.Items.Clear();
STTypeGame[] arr = cl.types;
for (int i = 0; i < arr.Length; i++)
{
if (arr[i].code == 0 && cld.stDiv.flag_reg == 1)
{
comboBoxTypes.Items.Add(arr[i].name.ToString());
}
if (arr[i].code == 1 && cld.stDiv.flag_po == 1)
{
comboBoxTypes.Items.Add(arr[i].name.ToString());
}
if (arr[i].code == 2 && cld.stDiv.flag_styk == 1)
{
comboBoxTypes.Items.Add(arr[i].name.ToString());
}
}
}
catch (Exception ex) { MessageBox.Show(ex.Message, ex.Source); }
}
private void ReportBestPlayer_Load(object sender, EventArgs e)
{
try
{
clDiv = new CDivision(connect);
tp = new CTypeGames();
init_combo_type();
init_combo_division();
init_combo_date();
textBoxLimit2.Text = "3,1";
textBoxLimit3.Text = "1,2";
textBoxLimitFt.Text = "1,9";
textBoxPCG.Text = "51";
textBoxCntPlayer.Text = "30";
radioButtonOneDate.Checked = true;
dateTimePickerDateEnd.Enabled = false;
}
catch (Exception ex) { MessageBox.Show(ex.Message, ex.Source); }
}
private void RatingsTeam_Load(object sender, EventArgs e)
{
try
{
clDiv = new CDivision(connect);
clScheme = new CScheme(connect);
tp = new CTypeGames();
checkBoxStage.Checked = false;
checkBoxType.Checked = false;
comboBoxStage.Enabled = false;
comboBoxType.Enabled = false;
comboBoxType.Text = null;
comboBoxStage.Text = null;
init_combo_division();
init_combo_type();
iddivision = 0;
type = -1;
idstage = 0;
}
catch (Exception ex) { MessageBox.Show(ex.Message, ex.Source); }
}
public static string ObtenerNombreDivision(int pIdDivision, CConexion pConexion)
{
CDivision Division = new CDivision();
Division.LlenaObjeto(pIdDivision, pConexion);
return(Division.Division);
}
private STVotePCA?GetSelectionData()
{
STVotePCA?ret = null;
int iddivision = 0;
string email = null;
DateTime ed = new DateTime();
try
{
foreach (DataGridViewRow item in dataGridViewVotePCA.SelectedRows)
{
email = item.Cells[1].Value.ToString();
CDivision clDiv = new CDivision(connect, IS.idseason, item.Cells[3].Value.ToString());
iddivision = clDiv.stDiv.id;
ed = DateTime.Parse(item.Cells[5].Value.ToString());
ret = clWork.GetRecord(IS.idseason, iddivision, email, ed);
}
}
catch (Exception ex) { MessageBox.Show(ex.Message, ex.Source); }
return(ret);
}
public static string ObtenerDivisionOportunidad(int IdOportunidad)
{
CConexion ConexionBaseDatos = new CConexion();
string respuesta = ConexionBaseDatos.ConectarBaseDatosSqlServer();
JObject oRespuesta = new JObject();
JObject Modelo = new JObject();
if (respuesta == "Conexion Establecida")
{
Dictionary <string, object> Parametros = new Dictionary <string, object>();
COportunidad oportunidad = new COportunidad();
Parametros.Add("IdOportunidad", IdOportunidad);
oportunidad.LlenaObjetoFiltros(Parametros, ConexionBaseDatos);
Modelo.Add("ValorDefault", "0");
Modelo.Add("DescripcionDefault", "Elegir una opción...");
Modelo.Add("Opciones", CDivision.ObtenerJsonDivisionesActivas(oportunidad.IdDivision, ConexionBaseDatos));
oRespuesta.Add(new JProperty("Error", 0));
oRespuesta.Add(new JProperty("Modelo", Modelo));
}
else
{
oRespuesta.Add(new JProperty("Error", 1));
oRespuesta.Add(new JProperty("Descripcion", "No hay conexion a Base de Datos"));
}
ConexionBaseDatos.CerrarBaseDatosSqlServer();
return(oRespuesta.ToString());
}
private void init_data(STViewVotePCA param)
{
g_f = false;
gpos = -1;
CPlayer clPlayer;
string text;
try
{
dataGridViewVotePCA.Rows.Clear();
full_list = clWork.GetList(IS.idseason, param);
bool fl = false;
if (full_list.Count > 0)
{
g_f = true;
dataGridViewVotePCA.Rows.Add(full_list.Count);
for (int i = 0; i < full_list.Count; i++)
{
dataGridViewVotePCA.Rows[i].Cells[0].Value = full_list[i].name;
dataGridViewVotePCA.Rows[i].Cells[1].Value = full_list[i].email;
dataGridViewVotePCA.Rows[i].Cells[2].Value = full_list[i].ip;
CDivision clDiv = new CDivision(connect, IS.idseason, full_list[i].iddivision);
dataGridViewVotePCA.Rows[i].Cells[3].Value = clDiv.stDiv.name;
clPlayer = new CPlayer(connect, full_list[i].idplayer);
text = string.Format("{0} {1} {2}", clPlayer.stPlayer.family, clPlayer.stPlayer.name,
clPlayer.stPlayer.payname);
dataGridViewVotePCA.Rows[i].Cells[4].Value = text;
dataGridViewVotePCA.Rows[i].Cells[5].Value = full_list[i].ed.ToString();
if (flawour.Equals(full_list[i]))
{
gpos = i;
}
}
dataGridViewVotePCA.AllowUserToAddRows = false;
}
else
{
dataGridViewVotePCA.AllowUserToAddRows = false;
}
toolStripStatusLabel1.Text = string.Format("Количество записей: {0}", full_list.Count);
}
catch (Exception ex) { MessageBox.Show(ex.Message, ex.Source); }
}
/* вставка данных */
private void set_data()
{
CCoach clCoach;
CPlayer clPlayer;
string text;
try
{
team = new CTeam(connect, stTeamPart.idteam);
comboBoxNameTeam.Text = team.stTeam.name;
CCity city = new CCity(connect, team.stTeam.idcity);
labelDisl.Text = string.Format("{0}, {1}", city.stFullCity.name, city.stFullCity.nameregion);
dateTimePickerDateIn.Value = stTeamPart.datein;
div = new CDivision(connect, (int)IS.idseason, stTeamPart.iddivision);
comboBoxDivision.Text = div.stDiv.name;
clTeamComposition = new CEntryPlayers(connect);
team_composition = clTeamComposition.GetListEntryPlayers(IS.idseason, stTeamPart.idteam, "Number");
init_data(team_composition);
init_combo_captain();
if (stTeamPart.idcoach1 != null)
{
clCoach = new CCoach(connect, (int)stTeamPart.idcoach1);
text = string.Format("{0} {1}", clCoach.stCoach.family, clCoach.stCoach.name);
comboBoxCoach1.Text = text;
}
if (stTeamPart.idcoach2 != null)
{
clCoach = new CCoach(connect, (int)stTeamPart.idcoach2);
text = string.Format("{0} {1}", clCoach.stCoach.family, clCoach.stCoach.name);
comboBoxCoach2.Text = text;
}
if (stTeamPart.idcoach3 != null)
{
clCoach = new CCoach(connect, (int)stTeamPart.idcoach3);
text = string.Format("{0} {1}", clCoach.stCoach.family, clCoach.stCoach.name);
comboBoxCoach3.Text = text;
}
if (stTeamPart.idcaptain != null)
{
clPlayer = new CPlayer(connect, (int)stTeamPart.idcaptain);
string num = get_num_captain((int)stTeamPart.idcaptain);
text = string.Format("#{0} {1} {2}", num, clPlayer.stPlayer.family, clPlayer.stPlayer.name);
comboBoxCaptain.Text = text;
}
}
catch (Exception ex) { MessageBox.Show(ex.Message, ex.Source); }
}
static void Main(string[] args)
{
CDivision division = new CDivision();
division.ZeroDivisionEventHandler += (sender, e) => Console.WriteLine($"No se puede dividir {e.A}/{e.B}");
Console.WriteLine(division.Division(2, 0));
Console.ReadKey();
}
public Division(SqlConnection cn, STInfoSeason inf, ushort md)
{
InitializeComponent();
connect = cn;
IS = inf;
mode = md;
clDivision = new CDivision(connect);
}
private void DlgDivision_Load(object sender, EventArgs e)
{
this.Text = caption;
clDivision = new CDivision(connect);
//textBoxName.Focus();
set_data();
}
private void init_data()
{
try
{
g_f = false;
dataGridViewGroups.Rows.Clear();
list = clGroup.GetListGroup(IS.idseason);
if (list.Count > 0)
{
g_f = true;
dataGridViewGroups.Rows.Add(list.Count);
for (int i = 0; i < list.Count; i++)
{
dataGridViewGroups.Rows[i].Cells[0].Value = (i + 1).ToString();
dataGridViewGroups.Rows[i].Cells[1].Value = list[i].namegroup;
clDivision = new CDivision(connect, IS.idseason, list[i].iddivision);
dataGridViewGroups.Rows[i].Cells[2].Value = clDivision.stDiv.name;
clScheme = new CScheme(connect, IS.idseason, list[i].iddivision, list[i].idstage);
dataGridViewGroups.Rows[i].Cells[3].Value = clScheme.stScheme.namestage;
dataGridViewGroups.Rows[i].Cells[4].Value = list[i].cntteam.ToString();
dataGridViewGroups.Rows[i].Cells[5].Value = list[i].cntteamnext.ToString();
clCompgroup = new CCompositionGroup(connect, IS.idseason, list[i].iddivision,
list[i].idgroup);
dataGridViewGroups.Rows[i].Cells[6].Value =
clCompgroup.lstCompositionGroup.Count.ToString();
dataGridViewGroups.Rows[i].Cells[7].Value = list[i].idgroup.ToString();
if (flawour.Equals(list[i]))
{
gpos = i;
}
}
dataGridViewGroups.AllowUserToAddRows = false;
}
else
{
dataGridViewGroups.AllowUserToAddRows = false;
}
}
catch (Exception ex) { MessageBox.Show(ex.Message, ex.Source); }
}
public static string ObtenerFormaAgregarLevantamiento()
{
JObject Respuesta = new JObject();
CUtilerias.DelegarAccion(delegate(CConexion pConexion, int Error, string DescripcionError, CUsuario UsuarioSesion)
{
JObject Modelo = new JObject();
if (Error == 0)
{
CSucursal Sucursal = new CSucursal();
Sucursal.LlenaObjeto(Convert.ToInt32(UsuarioSesion.IdSucursalActual), pConexion);
DateTime Fecha = Convert.ToDateTime(DateTime.Now.ToShortDateString());
Modelo.Add("FechaAlta", DateTime.Now.ToShortDateString());
DateTime fechaValidoHasta = DateTime.Now.AddDays(3);
Modelo.Add("ValidoHasta", fechaValidoHasta.ToShortDateString());
Modelo.Add("Usuarios", CUsuario.ObtenerJsonUsuario(pConexion));
Modelo.Add("Sucursales", CSucursal.ObtenerSucursales(pConexion));
Modelo.Add("Divisiones", CDivision.ObtenerJsonDivisionesActivas(-1, pConexion));
//Energia UPS
Modelo.Add("EnergiaUPS", ObtenerJsonChecksActivas(1, pConexion));
//Comunicaciones Video Proyeccion
Modelo.Add("ComunicacionesVideoProyeccion", ObtenerJsonChecksActivas(2, pConexion));
//Comunicaciones Audio
Modelo.Add("ComunicacionesAudio", ObtenerJsonChecksActivas(3, pConexion));
//Comunicaciones Conmutador
Modelo.Add("ComunicacionesConmutador", ObtenerJsonChecksActivas(4, pConexion));
//Comunicaciones Enlaces de Mircoonda
Modelo.Add("ComunicacionesEnlacesMircoonda", ObtenerJsonChecksActivas(5, pConexion));
//Infraestructura Cableado Voz y Datos
Modelo.Add("InfraestructuraCableadoVozDatos", ObtenerJsonChecksActivas(6, pConexion));
//Infraestructura Canalizaciones
Modelo.Add("InfraestructuraCanalizaciones", ObtenerJsonChecksActivas(7, pConexion));
//Infraesructura Proteccion
Modelo.Add("InfraestructuraProteccion", ObtenerJsonChecksActivas(8, pConexion));
//Checks General
Modelo.Add("ChecksGeneral", ObtenerJsonChecksActivas(9, pConexion));
}
Respuesta.Add("Modelo", Modelo);
});
return(Respuesta.ToString());
}
//Constructores
//Metodos Especiales
public static JObject ObtenerDivision(JObject pModelo, int pIdDivision, CConexion pConexion)
{
CDivision Division = new CDivision();
Division.LlenaObjeto(pIdDivision, pConexion);
pModelo.Add(new JProperty("IdDivision", Division.IdDivision));
pModelo.Add(new JProperty("Division", Division.Division));
pModelo.Add(new JProperty("ClaveCuentaContable", Division.ClaveCuentaContable));
pModelo.Add(new JProperty("EsVenta", Division.EsVenta));
return(pModelo);
}
private void ReportStatsPlaer_Load(object sender, EventArgs e)
{
try
{
clDiv = new CDivision(connect);
clGroup = new CGroup(connect);
init_combo_division();
}
catch (Exception ex) { MessageBox.Show(ex.Message, ex.Source); }
}
private void comboBoxDivision_SelectedIndexChanged(object sender, EventArgs e)
{
if (comboBoxDivision.Text.Length > 0)
{
clDiv = new CDivision(connect, IS.idseason, comboBoxDivision.Text.Trim());
gDiv = clDiv.stDiv.id;
}
else
{
gDiv = 0;
}
}
public static string ObtenerDatos(int pIdSolLevantamiento)
{
JObject Respuesta = new JObject();
CUtilerias.DelegarAccion(delegate(CConexion pConexion, int Error, string DescripcionError, CUsuario UsuarioSesion)
{
if (Error == 0)
{
JObject Modelo = new JObject();
CSolicitudLevantamiento solicitudLevantamiento = new CSolicitudLevantamiento();
solicitudLevantamiento.LlenaObjeto(pIdSolLevantamiento, pConexion);
Modelo.Add("idSolLevantamiento", solicitudLevantamiento.IdSolicitudLevantamiento);
CCliente cliente = new CCliente();
cliente.LlenaObjeto(solicitudLevantamiento.IdCliente, pConexion);
Modelo.Add("IdCliente", cliente.IdCliente);
COrganizacion organizacion = new COrganizacion();
organizacion.LlenaObjeto(cliente.IdOrganizacion, pConexion);
Modelo.Add("RazonSocial", organizacion.RazonSocial);
//Combos
COportunidad oportunidad = new COportunidad();
oportunidad.LlenaObjeto(solicitudLevantamiento.IdOportunidad, pConexion);
Modelo.Add("IdOportunidad", oportunidad.IdOportunidad);
Modelo.Add("Oportunidades", COportunidad.ObtenerOportunidadProyecto(cliente.IdCliente, UsuarioSesion.IdUsuario, oportunidad.IdOportunidad, pConexion));
CDivision division = new CDivision();
division.LlenaObjeto(solicitudLevantamiento.IdDivision, pConexion);
Modelo.Add("IdDivision", division.IdDivision);
Modelo.Add("Divisiones", CDivision.ObtenerJsonDivisionesActivas(-1, pConexion));
Modelo.Add("FOLIO", solicitudLevantamiento.IdSolicitudLevantamiento);
Respuesta.Add("Modelo", Modelo);
}
Respuesta.Add("Error", Error);
Respuesta.Add("Descripcion", DescripcionError);
});
return(Respuesta.ToString());
}
private void comboBoxDivision_SelectedIndexChanged(object sender, EventArgs e)
{
try
{
if (comboBoxDivision.Text.Length > 0)
{
clDiv = new CDivision(connect, IS.idseason, comboBoxDivision.Text.Trim());
set_data(clDiv.stDiv.id);
}
}
catch (Exception ex) { MessageBox.Show(ex.Message, ex.Source); }
}
private void RecordsPerson_Load(object sender, EventArgs e)
{
try
{
clDiv = new CDivision(connect);
init_combo();
clear();
}
catch (Exception ex) { MessageBox.Show(ex.Message, ex.Source); }
}
private void AwardsResult_Load(object sender, EventArgs e)
{
try
{
clDiv = new CDivision(connect);
clWork = new CAwarsResult(connect);
clTeam = new CTeam(connect);
clAward = new CAward(connect);
init_combo();
}
catch (Exception ex) { MessageBox.Show(ex.Message, ex.Source); }
}
private void comboBoxDivision_SelectedIndexChanged(object sender, EventArgs e)
{
try
{
if (comboBoxDivision.Text.Length > 0)
{
string text = comboBoxDivision.Text.Trim();
clDiv = new CDivision(connect, idseason, text);
init_combo_team(clDiv.stDiv.id);
}
}
catch (Exception ex) { MessageBox.Show(ex.Message, ex.Source); }
}
private void ReportTeamStanding_Load(object sender, EventArgs e)
{
try
{
clDiv = new CDivision(connect);
clGroup = new CGroup(connect);
init_combo_division();
dateTimePickerDate.Enabled = false;
}
catch (Exception ex) { MessageBox.Show(ex.Message, ex.Source); }
}
