public CascadingDropDownNameValue[] getDivisiones(string knownCategoryValues) { clsDivision oCls = new clsDivision(); DataTable dt; StringBuilder strHTML = new StringBuilder(); List <CascadingDropDownNameValue> values = new List <CascadingDropDownNameValue>(); dt = oCls.GetAllDivision(); if (dt == null) { return(values.ToArray()); } else { if (dt.Rows.Count > 0) { foreach (DataRow row in dt.Rows) { values.Add(new CascadingDropDownNameValue { name = row[2].ToString(), value = row[0].ToString() }); } return(values.ToArray()); } else { return(values.ToArray()); } } }
protected void Page_Load(object sender, EventArgs e) { clsDivision clsBussinesDivision = new clsDivision(); try { if (Request["__EVENTTARGET"] == "MiFuncion" && Request["__EVENTARGUMENT"] == "") { //cmbZone.Items.Clear(); Select(); } if (!IsPostBack) { //cmbDivision.Items.Clear(); DataTable dtG; dtG = clsBussinesDivision.GetAllDivision(); //Session["dtG"] = dtG; dtG.Rows.Add(0, "0", "--TODOS--"); DataSet ds = new DataSet(); ds.Tables.Add(dtG.Copy()); ds.Tables[0].DefaultView.Sort = " Descripción"; cmbDivision.DataSource = ds; cmbDivision.DataTextField = "Descripción"; cmbDivision.DataValueField = "Id"; cmbDivision.DataBind(); cmbDivision.SelectedValue = "0"; ds = new DataSet(); ds.Tables.Add(dtG.Copy()); cmbNewDivision.DataSource = ds; cmbNewDivision.DataTextField = "Descripción"; cmbNewDivision.DataValueField = "Id"; cmbNewDivision.DataBind(); //cmbNewDivision.SelectedValue = ""; //cmbDivision.Items.Add(""); //cmbNewDivision.Items.Add(""); } this.Dispose(); } catch (Exception ex) { clsError.logMessage = ex.ToString(); clsError.logModule = "Page_Load"; clsError.LogWrite(); } }
public string NewDivision(string CveDivision, string Division) { clsDivision oclsDivision = new clsDivision(); string sResp = ""; if (string.IsNullOrEmpty(CveDivision)) { return("0-Falta agregar la clave de la División"); } if (string.IsNullOrEmpty(Division)) { return("0-Falta agregar la descripción de la División"); } sResp = oclsDivision.NewDivision(CveDivision, Division); return(sResp); }
protected void Page_Load(object sender, EventArgs e) { TabName.Value = Request.Form[TabName.UniqueID]; clsDivision clsBussinesDivision = new clsDivision(); try { if (!IsPostBack) { //cmbDivision.Items.Clear(); DataTable dtG; dtG = clsBussinesDivision.GetAllDivision(); DataSet ds = new DataSet(); ds.Tables.Add(dtG.Copy()); ds.Tables[0].DefaultView.Sort = " Descripción"; cmbNewDivision.DataSource = ds; cmbNewDivision.DataTextField = "Descripción"; cmbNewDivision.DataValueField = "Id"; cmbNewDivision.DataBind(); dtG.Rows.Add(0, "0", "-- TODOS --"); DataSet dss = new DataSet(); dss.Tables.Add(dtG.Copy()); cmbSearchDivision.DataSource = dss; cmbSearchDivision.DataTextField = "Descripción"; cmbSearchDivision.DataValueField = "Id"; cmbSearchDivision.DataBind(); cmbNewDivision.Items.Add(""); cmbNewDivision.SelectedValue = ""; cmbSearchDivision.Items.Add(""); cmbSearchDivision.SelectedValue = ""; Buscar(); } this.Dispose(); } catch (Exception ex) { clsError.logMessage = ex.ToString(); clsError.logModule = "Page_Load"; clsError.LogWrite(); } }
public String EditDivision(string CveDivision, string Division, int IdDivision) { //Boolean msg = true; string sResp = ""; clsDivision oclsDivision = new clsDivision(); String strIdDivision = Convert.ToString(IdDivision); //if (string.IsNullOrEmpty(CveDivision)) { return "Falta agregar la clave del la División"; } //if (string.IsNullOrEmpty(Division)) { return "Falta agregar la descripción"; } //if (string.IsNullOrEmpty(strIdDivision)) { return "Falta agregar el Id de la división"; } sResp = oclsDivision.UpdateDivision(IdDivision, Division, CveDivision); //if (msg) { return "La Division se ha actualizado en la base de datos"; } //else { return "Error al actualizar los datos"; } return(sResp); }
public String DeleteDivision(int intIdDivision_delete) { clsDivision oClsDivision = new clsDivision(); String strIdGrupo = Convert.ToString(intIdDivision_delete); Boolean msg = true; if (string.IsNullOrEmpty(strIdGrupo)) { return("Falta agregar la División"); } msg = oClsDivision.DeleteDivision(intIdDivision_delete); if (msg) { return("La división se ha eliminado de la base de datos"); } else { return("Error al eliminar la división de la base de datos"); } }
protected void Page_Load(object sender, EventArgs e) { clsDivision clsBussinesDivision = new clsDivision(); try { if (!IsPostBack) { DataTable dtG = clsBussinesDivision.GetAllDivision(); Session["dtG"] = dtG; strHTMLGroup = clsBussinesDivision.ReturnHTMLDivision(dtG); DBDataPlaceHolder.Controls.Add(new Literal { Text = strHTMLGroup.ToString() }); } this.Dispose(); } catch (Exception ex) { clsError.logMessage = ex.ToString(); clsError.logModule = "Page_Load"; clsError.LogWrite(); } }
public StringBuilder RPU() { ADO.ConnectionDB cn = new ConnectionDB(); String RPU = System.String.Empty; Boolean bRespostExistsRPU = false; strRPUrepeated = new StringBuilder(); clsDivision oclsDivision = new clsDivision(); clsZone oclsZone = new clsZone(); clsGrupo oclsGroup = new clsGrupo(); clsTarifa oclsTarifa = new clsTarifa(); clsGestores oclsGestor = new clsGestores(); Boolean bexistgroup = false; Boolean bExistZone = false; Boolean bExistDivision = false; Boolean bExistTarifa = false; Boolean bExistGestorComercial = false; Boolean bExistGestorMedicion = false; int iNewConvenio = 0; int newRup = 0; DataTable dtConvenio = new DataTable("Convenio"); dtConvenio = InsertConvenio(); if (dtConvenio.Rows.Count > 0) { iNewConvenio = int.Parse(dtConvenio.Rows[0][0].ToString()); intConvenio = iNewConvenio; foreach (DataRow drChargeShiping in dtResult.Rows) { try { //Select Query String strRPU = String.Empty; strRPU = Convert.ToString(drChargeShiping[2]); strRPU = strRPU.Replace(" ", ""); strServiceCFE = strRPU; RPU = GetRPU(); bExistTarifa = oclsTarifa.ExistTarifa(Convert.ToString(drChargeShiping[4])); bexistgroup = oclsGroup.ExistGroup(Convert.ToString(drChargeShiping[6])); bExistDivision = oclsDivision.ExistDivision(Convert.ToString(drChargeShiping[8])); bExistZone = oclsZone.ExistZonaCve(Convert.ToString(drChargeShiping[8]), Convert.ToString(drChargeShiping[7]), Convert.ToString(drChargeShiping[9])); bExistGestorMedicion = oclsGestor.ExistIniciales(Convert.ToString(drChargeShiping[11]), "2"); bExistGestorComercial = oclsGestor.ExistIniciales(Convert.ToString(drChargeShiping[12]), "1"); if (bExistTarifa) { if (bexistgroup) { if (bExistDivision) { //if (bExistZone){ if (bExistGestorMedicion) { if (bExistGestorComercial) { if (!string.IsNullOrEmpty(strServiceCFE)) { strDivision = Convert.ToString(drChargeShiping[8]); strZona = Convert.ToString(drChargeShiping[9]); if (!bExistZone) { // oclsZone.NewZoneByDiv(Convert.ToString(drChargeShiping[7]).Substring(0, 2), strZona, strDivision, strDivision); } strLoadPoint = Convert.ToString(drChargeShiping[1]); strAddressPoint = Convert.ToString(drChargeShiping[3]); strRate = Convert.ToString(drChargeShiping[4]); dblMaxShipping = Convert.ToDouble(drChargeShiping[5]); strGroup = Convert.ToString(drChargeShiping[6]); strCta = Convert.ToString(drChargeShiping[7]); dblDemanda = Convert.ToDouble("0" + drChargeShiping[10]); strGestorComercial = Convert.ToString(drChargeShiping[11]); strGestorMedicion = Convert.ToString(drChargeShiping[12]); //se asignan los campos nuevos if (Convert.ToString(drChargeShiping[13]) != "") { strIdEstatusOferta = Convert.ToString(drChargeShiping[13]); } else { strRPUrepeated.Append("El Estatus Oferta del RPU: " + strServiceCFE + " Contiene datos incorrectos!" + "<br>"); } if (Convert.ToString(drChargeShiping[14]) != "" && Convert.ToUInt32(drChargeShiping[14]) >= 0 && Convert.ToUInt32(drChargeShiping[14]) <= 1) { strConPrelacion = Convert.ToInt32(drChargeShiping[14]); } else { strRPUrepeated.Append("El campo Esta en prelacion del RPU: " + strServiceCFE + " Contiene datos incorrectos!" + "<br>"); } if (Convert.ToString(drChargeShiping[15]) != "" && Convert.ToUInt32(drChargeShiping[15]) >= 0 && Convert.ToUInt32(drChargeShiping[15]) <= 1) { strFirmado = Convert.ToInt32(drChargeShiping[15]); } else { strRPUrepeated.Append("El campo Firmado o prospecto del RPU: " + strServiceCFE + " Contiene datos incorrectos!" + "<br>"); } DataTable DtRup = new DataTable("Convenio"); DtRup = InsertRPU(); if (dtConvenio.Rows.Count > 0) { newRup = int.Parse(dtConvenio.Rows[0][0].ToString()); } } } else { strRPUrepeated.Append("No existe el Gestor Comercial: " + Convert.ToString(drChargeShiping[12]).ToUpper() + " del RPU: " + strServiceCFE + "<br>"); } } else { strRPUrepeated.Append("No existe el Gestor Medición: " + Convert.ToString(drChargeShiping[11]).ToUpper() + " del RPU: " + strServiceCFE + "<br>"); } //}else{strRPUrepeated.Append("No existe la Zona " + Convert.ToString(drChargeShiping[7]).ToUpper() + " del RPU: " + strServiceCFE + "<br>");} } else { strRPUrepeated.Append("No existe la División: " + Convert.ToString(drChargeShiping[8]).ToUpper() + " del RPU: " + strServiceCFE + "<br>"); } } else { strRPUrepeated.Append("No existe el Grupo: " + Convert.ToString(drChargeShiping[6]).ToUpper() + " del RPU: " + strServiceCFE + "<br>"); } } else { strRPUrepeated.Append("No existe la Tarifa: " + Convert.ToString(drChargeShiping[4]).ToUpper() + " del RPU: " + strServiceCFE + "<br>"); } } catch (Exception ex) { LogError.LogErrorMedicion clsError = new LogError.LogErrorMedicion(); clsError.logMessage = ex.ToString(); clsError.logModule = "RPU"; clsError.LogWrite(); } } } if (strRPUrepeated.Length > 0) { DataTable dtR = new DataTable("dtres"); dtR = EliminaCarga(); int iRes = 0; if (dtR.Rows.Count > 0) { iRes = int.Parse(dtR.Rows[0][0].ToString()); } } return(strRPUrepeated); }