// public void cmbCustomerProducts_OnLoad(object sender, EventArgs e)
public void cmbCustomerProducts_OnLoad(RadComboBox Box)
{
using (DataClasses1DataContext dbContext = new DataClasses1DataContext())
{
try
{
if (Session["editableProductId"] != null && !String.IsNullOrEmpty(Session["editableProductId"].ToString()))
{
string myProductId = Session["editableProductId"].ToString();
Box.Visible = true;
var myCustomers = from cust in dbContext.Customer
join lCust in dbContext.LargeCustomer on cust.Id equals lCust.CustomerId
orderby cust.Name ascending
select new
{
CustomerId = cust.Id,
CustomerName = String.IsNullOrEmpty(cust.MatchCode) ? cust.Name : cust.Name + "(" + cust.MatchCode + ")",
IsChecked = dbContext.CustomerProduct.SingleOrDefault(q => q.ProductId == Int32.Parse(myProductId) && q.CustomerId == cust.Id) != null ? true : false
};
Box.DataSource = myCustomers;
Box.DataBind();
}
}
catch (Exception ex)
{
dbContext.WriteLogItem("Product Error " + ex.Message, LogTypes.ERROR, "Product");
throw new Exception(ex.Message);
}
}
}
void cargarcentros()
{
List<capascccmex.metadatos.centro> oCamposCat = new List<capascccmex.metadatos.centro>();
capascccmex.biz.centro obj = new capascccmex.biz.centro();
Dictionary<Int64?, string> dcat = new Dictionary<Int64?, string>();
RadComboBox cmbcat = (RadComboBox)RadPanelBar1.FindItemByValue("info").FindControl("cmbcentro");
try
{
oCamposCat = obj.GetBizCentro(null, 0, 0);
//----------------------------------------
foreach (var item in oCamposCat)
{
dcat.Add(convertir.toNInt64(item.IdCentro), (string)item.Centro);
}
cmbcat.DataSource = dcat;
cmbcat.DataTextField = "Value";
cmbcat.DataValueField = "Key";
cmbcat.DataBind();
}
catch (SqlException ex)
{
windowManager1.RadAlert("Error: " + ex.Message.ToString(), 300, 100, "Cargando información de centros", null);
}
}
protected void RadGrid2_ItemDataBound(object sender, Telerik.Web.UI.GridItemEventArgs e)
{
if (e.Item is GridEditableItem && (e.Item as GridEditableItem).IsInEditMode)
{
GridEditableItem editedItem = e.Item as GridEditableItem;
RadComboBox ddlmarkets = editedItem.FindControl("ddlmarket") as RadComboBox;
ddlmarkets.DataSource = Bitcoin_Notify_DB.SPs.ViewMarketsAll().GetDataSet().Tables[0];
ddlmarkets.DataTextField = "market_shortname";
ddlmarkets.DataValueField = "market_key";
ddlmarkets.DataBind();
//assign the card group
if (editedItem is GridEditFormInsertItem) //is edit, and not insert
{
}
else
{
string strgroupkey = editedItem.GetDataKeyValue("market_key").ToString();
if (strgroupkey.Length > 0)
{
ddlmarkets.SelectedValue = strgroupkey;
}
}
}
}
private void Despacho_Cargar(string idAgenda, RadComboBox cboBox)
{
DireccionWCFClient objDireccionWCF;
try
{
objDireccionWCF = new DireccionWCFClient();
var datasource = from x in objDireccionWCF.Direccion_ListarCliente(((Usuario_LoginResult)Session["Usuario"]).idEmpresa,
((Usuario_LoginResult)Session["Usuario"]).codigoUsuario, idAgenda)
select new
{
x.ID,
DisplayField = String.Format("{0} {1} {2} {3}", x.Abreviatura, x.Direccion, x.Numero, x.Distrito)
};
cboBox.DataSource = datasource;
cboBox.DataValueField = "ID";
cboBox.DataTextField = "DisplayField";
cboBox.DataBind();
//if (cboDespacho.Items.Count > 0)
// cboDespacho.SelectedIndex = 0;
}
catch (Exception ex)
{
throw ex;
}
}
void loadcmbsEstatus(RadComboBox telerik, int tipo)
{
try
{
Dictionary <char, string> dcat = new Dictionary <char, string>();
if (tipo == 1)
{
dcat.Add('N', "Sin Revisar");
dcat.Add('S', "Revisado - No se puede modificar");
dcat.Add('T', "En trámite");
dcat.Add('C', "Cancelado");
}
else
{
dcat.Add('A', "Aceptado");
dcat.Add('P', "Pendiente");
}
telerik.DataSource = dcat;
telerik.DataTextField = "Value";
telerik.DataValueField = "Key";
telerik.DataBind();
}
catch (Exception ex)
{
RadWindowManager1.RadAlert("Error: " + ex.Message.ToString(), 300, 100, "Cargando instalaciones", null);
}
}
private void llenar_Periodos()
{
RadComboBox cmb_año = RadPanelBar_menu.FindChildByValue <RadPanelItem>("filtro").FindControl("cmb_año") as RadComboBox;
RadComboBox cmb_periodo = RadPanelBar_menu.FindChildByValue <RadPanelItem>("filtro").FindControl("cmb_periodo") as RadComboBox;
RadComboBox cmb_mes = RadPanelBar_menu.FindChildByValue <RadPanelItem>("filtro").FindControl("cmb_mes") as RadComboBox;
Conexion oCoon = new Conexion();
DataTable dtp = null;
int Report = Convert.ToInt32(this.Session["Reporte"]);
string canal = this.Session["Canal"].ToString().Trim();
int icompany = Convert.ToInt32(this.Session["companyid"]);
dtp = oCoon.ejecutarDataTable("UP_WEBXPLORA_CLIE_V2_OBTENERPERIODOS_2", canal, icompany, Report, cmb_mes.SelectedValue, cmb_año.SelectedValue);
if (dtp.Rows.Count > 0)
{
cmb_periodo.DataSource = dtp;
cmb_periodo.DataValueField = "id_periodo";
cmb_periodo.DataTextField = "Periodo";
cmb_periodo.DataBind();
cmb_periodo.Items.Insert(0, new RadComboBoxItem("--Todos--", "0"));
}
else
{
dtp = null;
cmb_periodo.Items.Insert(0, new RadComboBoxItem("--Todos--", "0"));
}
}
private void BindCombo(DataTable theDT, string theTextField, string theValueField, DropDownList theDropDown = null, RadComboBox theComboBox = null)
{
DataRow[] DR = theDT.Select("" + theValueField + " = 0");
if (DR.Length < 1)
{
DataRow theDR = theDT.NewRow();
theDR["" + theTextField + ""] = "Select";
theDR["" + theValueField + ""] = 0;
theDT.Rows.InsertAt(theDR, 0);
}
if (theDropDown != null)
{
theDropDown.DataSource = theDT;
theDropDown.DataTextField = theTextField;
theDropDown.DataValueField = theValueField;
theDropDown.DataBind();
//john start
//if (theDropDown.Items.Count == 2)
//{
// if (theDropDown.Items[0].Text == "Select")
// theDropDown.SelectedIndex = 1;
//}
//end
}
else
{
theComboBox.DataSource = theDT;
theComboBox.DataTextField = theTextField;
theComboBox.DataValueField = theValueField;
theComboBox.DataBind();
}
}
protected void trolleyclass_type_RadComboBox_SelectedIndexChanged(object sender, RadComboBoxSelectedIndexChangedEventArgs e)
{
RadComboBox combobox = (RadComboBox)sender;
GridEditFormItem edititem = (GridEditFormItem)combobox.NamingContainer;
if (combobox.SelectedValue == "3")
{
// trolley type drop down
TrolleyDAO trolleydao = new TrolleyDAO();
DataSet trolleyCodes = new DataSet();
trolleyCodes = trolleydao.GetCodesByType();
RadComboBox trolleytype = (RadComboBox)edititem
.FindControl("trolleytype_RadComboBox");
trolleytype.DataSource = trolleyCodes.Tables["TT"];
trolleytype.DataTextField = "type_short_name";
trolleytype.DataValueField = "type_id";
trolleytype.DataBind();
trolleytype.Items.Insert(0, new RadComboBoxItem("", "0"));
trolleytype.Visible = true;
RequiredFieldValidator RequiredFieldValidator2 = (RequiredFieldValidator)edititem
.FindControl("RequiredFieldValidator2");
RequiredFieldValidator2.Enabled = true;
}
else
{
RadComboBox trolleytype = (RadComboBox)edititem
.FindControl("trolleytype_RadComboBox");
trolleytype.Visible = false;
}
}
protected void RadGridPatients_ItemDataBound(object sender, Telerik.Web.UI.GridItemEventArgs e)
{
// form template is in insert mode
if (e.Item is GridEditFormInsertItem && RadGridPatients.MasterTableView.IsItemInserted)
{
RadComboBox cmbCities = e.Item.FindControl("cmbCities") as RadComboBox;
cmbCities.DataSource = getCities();
cmbCities.DataBind();
RadComboBox cmbNationalities = e.Item.FindControl("cmbNationalities") as RadComboBox;
cmbNationalities.DataSource = getNationalities();
cmbNationalities.DataBind();
Panel patientPasswordPanel = e.Item.FindControl("patientPasswordPanel") as Panel;
patientPasswordPanel.Visible = false;
}
else
if (e.Item is GridEditFormItem && e.Item.IsInEditMode)
{
RadComboBox cmbCities = e.Item.FindControl("cmbCities") as RadComboBox;
cmbCities.DataSource = getCities();
cmbCities.DataBind();
RadComboBox cmbNationalities = e.Item.FindControl("cmbNationalities") as RadComboBox;
cmbNationalities.DataSource = getNationalities();
cmbNationalities.DataBind();
CheckBox chkActive = e.Item.FindControl("chkActive") as CheckBox;
GridEditableItem dataItem = e.Item as GridEditableItem;
int PatientId = Convert.ToInt32(dataItem.GetDataKeyValue("patientId"));
chkActive.Checked = db.Patients.Where(p => p.id == PatientId).Any(p => p.Sec_Users.IsActive == true);
GridEditableItem editItem = e.Item as GridEditableItem;
string patientCityID = editItem.GetDataKeyValue("patientCityID").ToString();
cmbCities.SelectedValue = editItem.GetDataKeyValue("patientCityID").ToString();
cmbNationalities.SelectedValue = editItem.GetDataKeyValue("patientnatid").ToString();
}
}
protected void rgCoordinacion_ItemDataBound(object sender, GridItemEventArgs e)
{
if (e.Item is GridEditableItem && e.Item.IsInEditMode)
{
if (!e.Item.GetType().Name.Equals("GridEditFormInsertItem"))
{
BE_COORDINACION editableItem = ((BE_COORDINACION)e.Item.DataItem);
RadComboBox rcbTempEmpresa = (RadComboBox)e.Item.FindControl("rcbEmpresa");
if (rcbTempEmpresa != null)
{
rcbTempEmpresa.SelectedValue = editableItem.oBE_EMPRESA.ID.ToString();
}
RadComboBox rcbTempGerencia = (RadComboBox)e.Item.FindControl("rcbGerencia");
if (rcbTempGerencia != null)
{
this.odsGerencia.SelectParameters.Clear();
this.odsGerencia.SelectParameters.Add("empresa_id", System.Data.DbType.Guid, rcbTempEmpresa.SelectedValue);
rcbTempGerencia.DataBind();
rcbTempGerencia.SelectedValue = editableItem.oBE_GERENCIA.ID.ToString();
}
RadComboBox rcbTempArea = (RadComboBox)e.Item.FindControl("rcbArea");
if (rcbTempArea != null)
{
this.odsArea.SelectParameters.Clear();
this.odsArea.SelectParameters.Add("gerencia_id", System.Data.DbType.Guid, rcbTempGerencia.SelectedValue);
rcbTempArea.DataBind();
rcbTempArea.SelectedValue = editableItem.AREA_ID.ToString();
}
}
}
}
protected void PopulateStatusList(object sender, string publicationTypeId)
{
RadComboBox rcbPublicationStatus = (RadComboBox)sender;
rcbPublicationStatus.Items.Clear();
rcbPublicationStatus.Items.Insert(0, new RadComboBoxItem("Выберите значение", Guid.Empty.ToString()));
Guid gTypeId;
if (Guid.TryParse(publicationTypeId, out gTypeId))
{
var publicationStatuses = DataManager.PublicationStatus.SelectByPublicationTypeID(gTypeId);
foreach (var publicationStatus in publicationStatuses)
{
rcbPublicationStatus.Items.Add(new RadComboBoxItem(publicationStatus.Title, publicationStatus.ID.ToString()));
if (publicationStatus.isFirst != null && (bool)publicationStatus.isFirst)
{
rcbPublicationStatus.SelectedIndex =
rcbPublicationStatus.FindItemIndexByValue(publicationStatus.ID.ToString());
rcbPublicationStatus.SelectedValue = publicationStatus.ID.ToString();
rcbPublicationStatus.Text = publicationStatus.Title;
}
}
rcbPublicationStatus.DataBind();
}
}
private void BindCombo(DataTable theDT, string theTextField, string theValueField, DropDownList theDropDown = null, RadComboBox theComboBox = null)
{
theDropDown.Items.Clear();
DataRow[] DR = theDT.Select("" + theValueField + " = 0");
if (DR.Length < 1)
{
DataRow theDR = theDT.NewRow();
theDR["" + theTextField + ""] = "Select";
theDR["" + theValueField + ""] = 0;
theDT.Rows.InsertAt(theDR, 0);
}
if (theDropDown != null)
{
theDropDown.DataSource = theDT;
theDropDown.DataTextField = theTextField;
theDropDown.DataValueField = theValueField;
theDropDown.DataBind();
}
else
{
theComboBox.DataSource = theDT;
theComboBox.DataTextField = theTextField;
theComboBox.DataValueField = theValueField;
theComboBox.DataBind();
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
try
{
RadComboBox cmb_periodo = RadPanelBar_menu.FindChildByValue <RadPanelItem>("filtro").FindControl("cmb_periodo") as RadComboBox;
RadComboBox cmb_año = RadPanelBar_menu.FindChildByValue <RadPanelItem>("filtro").FindControl("cmb_año") as RadComboBox;
RadComboBox cmb_mes = RadPanelBar_menu.FindChildByValue <RadPanelItem>("filtro").FindControl("cmb_mes") as RadComboBox;
cmb_año.DataBind();
cmb_año.Items.Insert(0, new RadComboBoxItem("--Todos--", "0"));
cmb_mes.DataBind();
cmb_mes.Items.Insert(0, new RadComboBoxItem("--Todos--", "0"));
cmb_periodo.DataBind();
cmb_periodo.Items.Insert(0, new RadComboBoxItem("--Todos--", "0"));
cargarMenu();
llenar_Años();
llenar_Meses();
llenargrilla1("", "");
}
catch (Exception ex)
{
Exception mensaje = ex;
this.Session.Abandon();
//Response.Redirect("~/err_mensaje_seccion.aspx", true);
}
}
}
/****************************************/
/*********** LOAD DATASOURCE *****************/
public void Load_DataSource_RadComboBox(RadComboBox _cbb)
{
_cbb.DataSource = this.All.ToList();
_cbb.DataTextField = "DTTen";
_cbb.DataValueField = "DTID";
_cbb.DataBind();
}
private void BindCountryDropDown(List <CountryElement> countries, RadComboBox countryRadComboBox)
{
countryRadComboBox.DataSource = countries;
countryRadComboBox.DataTextField = "Name";
countryRadComboBox.DataValueField = "IsoCode";
countryRadComboBox.DataBind();
}
private void AssignvaluesToUserControl(DataTable dt)
{
try
{
RadComboBox RadBusinessUnit = (RadComboBox)BU1.FindControl("RadBusinessUnit");
RadBusinessUnit.DataSource = dt;
RadBusinessUnit.DataTextField = "BUSINESSUNIT_CODE";
RadBusinessUnit.DataValueField = "BUSINESSUNIT_ID";
RadBusinessUnit.DataBind();
RadComboBox RadDirectorate = (RadComboBox)BU1.FindControl("RadDirectorate");
RadDirectorate.DataSource = dt;
RadDirectorate.DataTextField = "DIRECTORATE_CODE";
RadDirectorate.DataValueField = "DIRECTORATE_ID";
RadDirectorate.DataBind();
RadComboBox RadDepartment = (RadComboBox)BU1.FindControl("RadDepartment");
RadDepartment.DataSource = dt;
RadDepartment.DataTextField = "DEPARTMENT_NAME";
RadDepartment.DataValueField = "DEPARTMENT_ID";
RadDepartment.DataBind();
RadComboBox RadEmployee = (RadComboBox)BU1.FindControl("RadEmployee");
RadEmployee.DataSource = dt;
RadEmployee.DataTextField = "EMPLOYEENAME";
RadEmployee.DataValueField = "AVC_EMPID";
RadEmployee.DataBind();
}
catch (Exception ex)
{
SMHR.BLL.Error_Log(Session["USER_ID"].ToString(), ex.TargetSite.ToString(), ex.Message.Replace("'", "''"), "frm_AVC", ex.StackTrace, DateTime.Now);
Response.Redirect("~/Frm_ErrorPage.aspx");
}
}
// LOAD DATASOURCE
public void Load_AllChucVu_RadComboBox(RadComboBox _cbb)
{
_cbb.DataSource = this.All.ToList();
_cbb.DataTextField = "CVTen";
_cbb.DataValueField = "CVID";
_cbb.DataBind();
}
public void CargaDropTodos(object nombreDrop, string value, string text, DataTable dt)
{
if (nombreDrop.GetType() == typeof(DropDownList))
{
DropDownList drop = (DropDownList)nombreDrop;
drop.DataSource = dt;
drop.DataValueField = value;
drop.DataTextField = text;
drop.DataBind();
ListItem li = new ListItem("Todos...", "0");
drop.Items.Insert(0, li);
drop.ClearSelection();
}
if (nombreDrop.GetType() == typeof(RadComboBox))
{
RadComboBox drop = (RadComboBox)nombreDrop;
drop.DataSource = dt;
drop.DataValueField = value;
drop.DataTextField = text;
drop.DataBind();
RadComboBoxItem li = new RadComboBoxItem("Todos...", "0");
drop.Items.Insert(0, li);
drop.ClearSelection();
drop.SelectedIndex = 0;
}
}
public void Load_AllAccount_ToRadComboBox(RadComboBox _cbb)
{
_cbb.DataSource = this.All.ToList();
_cbb.DataTextField = "ACCEmail";
_cbb.DataValueField = "ACCID";
_cbb.DataBind();
}
protected void rcbGerencia_SelectedIndexChanged(object sender, EventArgs e)
{
RadComboBox rcbTempGerencia = (RadComboBox)sender;
String selected = rcbTempGerencia.SelectedValue;
RadComboBox rcbTempArea = (RadComboBox)rcbTempGerencia.NamingContainer.FindControl("rcbArea");
RadComboBox rcbTempCoordinacion = (RadComboBox)rcbTempGerencia.NamingContainer.FindControl("rcbCoordinacion");
RadComboBox rcbTempPuesto = (RadComboBox)rcbTempGerencia.NamingContainer.FindControl("rcbPuesto");
rcbTempArea.ClearSelection();
rcbTempPuesto.ClearSelection();
rcbTempCoordinacion.ClearSelection();
this.odsArea.SelectParameters.Clear();
this.odsArea.SelectParameters.Add("gerencia_id", System.Data.DbType.Guid, selected);
rcbTempArea.DataBind();
this.odsCoordinacion.SelectParameters.Clear();
this.odsCoordinacion.SelectParameters.Add("area_id", System.Data.DbType.Guid, rcbTempArea.SelectedValue);
rcbTempCoordinacion.DataBind();
this.odsPuesto.SelectParameters.Clear();
this.odsPuesto.SelectParameters.Add("empresa_id", System.Data.DbType.Guid, Guid.Empty.ToString());
this.odsPuesto.SelectParameters.Add("gerencia_id", System.Data.DbType.Guid, rcbTempGerencia.SelectedValue);
rcbTempPuesto.DataBind();
}
// LOAD DATASOURCE
public void Load_DataSource_ComboBox(RadComboBox _comboBox)
{
_comboBox.DataSource = this.All.ToList();
_comboBox.DataValueField = "HSLID";
_comboBox.DataTextField = "HSLHeSo";
_comboBox.DataBind();
}
public static void FillCurrencyDDL(RadComboBox ddl, string defaultCode, bool displayLong)
{
// fill dropdown list with standard currency codes
if (displayLong)
{
ddl.DataSource = SessionManager.CurrencyList.OrderBy(l => l.CURRENCY_NAME);
ddl.DataTextField = "CURRENCY_NAME";
ddl.DataValueField = "CURRENCY_CODE";
ddl.DataBind();
}
else
{
foreach (CURRENCY cur in SessionManager.CurrencyList.OrderBy(l => l.CURRENCY_CODE))
{
RadComboBoxItem item = new RadComboBoxItem(cur.CURRENCY_CODE, cur.CURRENCY_CODE);
item.ToolTip = cur.CURRENCY_NAME;
ddl.Items.Add(item);
}
}
if (!string.IsNullOrEmpty(defaultCode))
{
ddl.SelectedValue = defaultCode;
}
}
protected void gvWERPFI_ItemDataBound(object sender, GridItemEventArgs e)
{
if (e.Item is GridFilteringItem && e.Item.ItemIndex == -1)
{
DataTable dtgvWERPFI = new DataTable();
GridFilteringItem filterItem = (GridFilteringItem)e.Item;
RadComboBox RadComboBoxRR = (RadComboBox)filterItem.FindControl("RadComboBoxRR");
dsRejectedRecords = (DataSet)Cache["RejectedFixedIncomeDetails" + adviserVo.advisorId.ToString()];
DataTable dtcustMIS = new DataTable();
dtgvWERPFI = dsRejectedRecords.Tables[0];
dtcustMIS.Columns.Add("WRR_RejectReasonDescription");
dtcustMIS.Columns.Add("RejectReasonCode");
DataRow drcustMIS;
foreach (DataRow dr in dtgvWERPFI.Rows)
{
drcustMIS = dtcustMIS.NewRow();
drcustMIS["WRR_RejectReasonDescription"] = dr["WRR_RejectReasonDescription"].ToString();
drcustMIS["RejectReasonCode"] = dr["RejectReasonCode"].ToString();
dtcustMIS.Rows.Add(drcustMIS);
}
DataView view = new DataView(dtgvWERPFI);
DataTable distinctValues = view.ToTable(true, "WRR_RejectReasonDescription", "RejectReasonCode");
RadComboBoxRR.DataSource = distinctValues;
RadComboBoxRR.DataValueField = dtcustMIS.Columns["RejectReasonCode"].ToString();
RadComboBoxRR.DataTextField = dtcustMIS.Columns["WRR_RejectReasonDescription"].ToString();
RadComboBoxRR.DataBind();
}
}
//private gsGuiaVenta_ListarxOPResult GuiaVenta_ObtenerCambios()
//{
// gsGuiaVenta_ListarxOPResult objGuiaVentasFlujo;
// try
// {
// objGuiaVentasFlujo = new gsGuiaVenta_ListarxOPResult();
// objGuiaVentasFlujo.id_agenda = lblCodigoCliente.Value;
// objGuiaVentasFlujo.ID_AgendaDireccion = int.Parse(cboFacturacionCliente.SelectedValue);
// objGuiaVentasFlujo.ID_AgendaDireccion2 = int.Parse(cboDespacho.SelectedValue);
// objGuiaVentasFlujo.DireccionOrigenAgenda = lblCodigoOrigen.Value;
// objGuiaVentasFlujo.DireccionOrigenSucursal = int.Parse(cboSucursalOrigen.SelectedValue);
// objGuiaVentasFlujo.DireccionOrigenReferencia = int.Parse(cboReferenciaOrigen.SelectedValue);
// objGuiaVentasFlujo.DireccionOrigenDireccion = int.Parse(cboFacturacionOrigen.SelectedValue);
// objGuiaVentasFlujo.DireccionDestinoAgenda = lblCodigoDestino.Value;
// objGuiaVentasFlujo.DireccionDestinoSucursal = int.Parse(cboSucursalDestino.SelectedValue);
// objGuiaVentasFlujo.DireccionDestinoReferencia = int.Parse(cboReferenciaDestino.SelectedValue);
// objGuiaVentasFlujo.DireccionDestinoDireccion = int.Parse(cboFacturacionDestino.SelectedValue);
// objGuiaVentasFlujo.ID_Transportista = lblCodigoTransportista.Value;
// objGuiaVentasFlujo.ID_Chofer = txtIDChofer.Text;
// objGuiaVentasFlujo.TransportistaChofer = txtChofer.Text;
// objGuiaVentasFlujo.TransportistaCertInscripcion = txtCertificado.Text;
// objGuiaVentasFlujo.TransportistaLicencia = txtLicencia.Text;
// objGuiaVentasFlujo.TransportistaMarca = txtVehiculoMarca.Text;
// objGuiaVentasFlujo.ID_Vehiculo = txtVehiculoPlaca.Text;
// objGuiaVentasFlujo.TransportistaModelo = txtVehiculoModelo.Text;
// objGuiaVentasFlujo.TransportistaPlaca = txtVehiculoPlaca.Text;
// objGuiaVentasFlujo.TransportistaRUC = txtRUCTransporte.Text;
// objGuiaVentasFlujo.FechaDespacho = dpFechaDespacho.SelectedDate.Value;
// objGuiaVentasFlujo.FechaTraslado = dpFechaTraslado.SelectedDate.Value;
// objGuiaVentasFlujo.FechaEmision = dpFechaEmision.SelectedDate.Value;
// return objGuiaVentasFlujo;
// }
// catch (Exception ex)
// {
// throw ex;
// }
//}
private void Referencia_Cargar(string idAgenda, int idSucursal, RadComboBox cbobox)
{
AgendaWCFClient objAgendaWCF;
VBG02699Result objReferencia;
List <VBG02699Result> lstReferencias;
try
{
objAgendaWCF = new AgendaWCFClient();
objReferencia = new VBG02699Result();
objReferencia.ID = -1;
objReferencia.Nombre = "Ninguno";
lstReferencias = objAgendaWCF.AgendaAnexoReferencia_ListarPorSucursal(((Usuario_LoginResult)Session["Usuario"]).idEmpresa,
((Usuario_LoginResult)Session["Usuario"]).codigoUsuario, idSucursal, idAgenda).ToList();
lstReferencias.Insert(0, objReferencia);
cbobox.DataSource = lstReferencias;
cbobox.DataTextField = "Nombre";
cbobox.DataValueField = "ID";
cbobox.DataBind();
if (cbobox.Items.Count > 0)
{
cbobox.SelectedIndex = 0;
}
}
catch (Exception ex)
{
throw ex;
}
}
//private void Despacho_CargarTipo()
//{
// DespachoWCFClient objDespachoWVF;
// try
// {
// objDespachoWVF = new DespachoWCFClient();
// cboOpDespacho.DataSource = objDespachoWVF.Despacho_ListarTipo(((Usuario_LoginResult)Session["Usuario"]).idEmpresa,
// ((Usuario_LoginResult)Session["Usuario"]).codigoUsuario);
// cboOpDespacho.DataTextField = "Nombre";
// cboOpDespacho.DataValueField = "ID";
// cboOpDespacho.DataBind();
// if (cboOpDespacho.Items.Count > 0)
// cboOpDespacho.SelectedIndex = 0;
// }
// catch (Exception ex)
// {
// throw ex;
// }
//}
//private void GuiaVentasFlujo_CargarTipo()
//{
// GuiaVentasFlujoWCFClient objGuiaVentasFlujoWCF;
// try
// {
// objGuiaVentasFlujoWCF = new GuiaVentasFlujoWCFClient();
// cboOpTipoGuiaVentasFlujo.DataSource = objGuiaVentasFlujoWCF.GuiaVentasFlujo_ListarTipo(((Usuario_LoginResult)Session["Usuario"]).idEmpresa,
// ((Usuario_LoginResult)Session["Usuario"]).codigoUsuario);
// cboOpTipoGuiaVentasFlujo.DataTextField = "Nombre";
// cboOpTipoGuiaVentasFlujo.DataValueField = "ID";
// cboOpTipoGuiaVentasFlujo.DataBind();
// if (cboOpTipoGuiaVentasFlujo.Items.Count > 0)
// cboOpTipoGuiaVentasFlujo.SelectedIndex = 0;
// }
// catch (Exception ex)
// {
// throw ex;
// }
//}
//private void Documento_CagarTipoVenta()
//{
// DocumentoWCFClient objDocumentoWCF;
// try
// {
// objDocumentoWCF = new DocumentoWCFClient();
// cboOpDocVenta.DataSource = objDocumentoWCF.Documento_ListarDocVenta(((Usuario_LoginResult)Session["Usuario"]).idEmpresa,
// ((Usuario_LoginResult)Session["Usuario"]).codigoUsuario);
// cboOpDocVenta.DataTextField = "Nombre";
// cboOpDocVenta.DataValueField = "ID";
// cboOpDocVenta.DataBind();
// if (cboOpDocVenta.Items.Count > 0)
// cboOpDocVenta.SelectedIndex = 0;
// }
// catch (Exception ex)
// {
// throw ex;
// }
//}
//private void Almacen_Cargar()
//{
// AgendaWCFClient objAgendaWCF;
// try
// {
// objAgendaWCF = new AgendaWCFClient();
// cboAlmacen.DataSource = objAgendaWCF.AgendaAnexo_ListarAlmacen(((Usuario_LoginResult)HttpContext.Current.Session["Usuario"]).idEmpresa, ((Usuario_LoginResult)HttpContext.Current.Session["Usuario"]).codigoUsuario);
// cboAlmacen.DataTextField = "AlmacenAnexo";
// cboAlmacen.DataValueField = "ID_AlmacenAnexo";
// cboAlmacen.DataBind();
// if (cboAlmacen.Items.Count > 0)
// cboAlmacen.SelectedIndex = 0;
// }
// catch (Exception ex)
// {
// throw ex;
// }
//}
//private void Credito_Cargar(string idAgenda)
//{
// CreditoWCFClient objCreditoWCF;
// try
// {
// objCreditoWCF = new CreditoWCFClient();
// var datasource = from x in objCreditoWCF.Credito_ListarCondicion(((Usuario_LoginResult)Session["Usuario"]).idEmpresa,
// ((Usuario_LoginResult)Session["Usuario"]).codigoUsuario, idAgenda)
// select new
// {
// ValueField = String.Format("{0},{1}", x.ID_CondicionCredito, x.DiasCredito),
// TextField = String.Format("{0}", x.Nombre)
// };
// cboTipoCredito.DataSource = datasource;
// cboTipoCredito.DataTextField = "TextField";
// cboTipoCredito.DataValueField = "ValueField";
// cboTipoCredito.DataBind();
// if (cboTipoCredito.Items.Count > 0)
// {
// cboTipoCredito.SelectedIndex = 0;
// txtDiasCredito.Text = cboTipoCredito.SelectedValue.Split(',')[1];
// dpFechaEmision.SelectedDate = DateTime.Now;
// dpFechaVencimiento.SelectedDate = DateTime.Now.AddDays(Int32.Parse(txtDiasCredito.Text));
// }
// }
// catch (Exception ex)
// {
// throw ex;
// }
//}
//private void Envio_Cargar()
//{
// EnvioWCFClient objEnvioWCF;
// try
// {
// objEnvioWCF = new EnvioWCFClient();
// cboTipoEnvio.DataSource = objEnvioWCF.Envio_ListarTipo(((Usuario_LoginResult)HttpContext.Current.Session["Usuario"]).idEmpresa, ((Usuario_LoginResult)HttpContext.Current.Session["Usuario"]).codigoUsuario);
// cboTipoEnvio.DataTextField = "Nombre";
// cboTipoEnvio.DataValueField = "ID";
// cboTipoEnvio.DataBind();
// if (cboTipoEnvio.Items.Count > 0)
// cboTipoEnvio.SelectedValue = "2";
// }
// catch (Exception ex)
// {
// throw ex;
// }
//}
//private void Sede_Cagar()
//{
// SedeWCFClient objSedeWCF;
// VBG02689Result objSede;
// List<VBG02689Result> lstSedes;
// try
// {
// objSedeWCF = new SedeWCFClient();
// objSede = new VBG02689Result();
// objSede.Nombre = "Ninguno";
// objSede.ID_Sede = -1;
// lstSedes = objSedeWCF.RRHHSede_Listar(((Usuario_LoginResult)Session["Usuario"]).idEmpresa, ((Usuario_LoginResult)Session["Usuario"]).codigoUsuario).ToList();
// lstSedes.Insert(0, objSede);
// cboSede.DataSource = lstSedes;
// cboSede.DataTextField = "Nombre";
// cboSede.DataValueField = "ID_Sede";
// cboSede.DataBind();
// if (cboSede.Items.Count > 0)
// cboSede.SelectedIndex = 0;
// }
// catch (Exception ex)
// {
// throw ex;
// }
//}
private void Sucursal_Cargar(string idAgenda, RadComboBox cbobox)
{
AgendaWCFClient objAgendaWCFC;
List <VBG00167Result> lstSucursal;
VBG00167Result objSucursal;
try
{
objAgendaWCFC = new AgendaWCFClient();
objSucursal = new VBG00167Result();
lstSucursal = objAgendaWCFC.AgendaAnexo_ListarDireccionCliente(((Usuario_LoginResult)Session["Usuario"]).idEmpresa, ((Usuario_LoginResult)Session["Usuario"]).codigoUsuario, idAgenda).ToList();
objSucursal.ID = -1;
objSucursal.Nombre = "Central";
lstSucursal.Insert(0, objSucursal);
cbobox.DataSource = lstSucursal;
cbobox.DataTextField = "Nombre";
cbobox.DataValueField = "ID";
cbobox.DataBind();
if (cbobox.Items.Count > 0)
{
cbobox.SelectedIndex = 0;
}
}
catch (Exception ex)
{
throw ex;
}
}
private void Direccion_Cargar(string idAgenda, RadComboBox cbobox)
{
DireccionWCFClient objDireccionWCF;
try
{
objDireccionWCF = new DireccionWCFClient();
var dirFiscal = from x in objDireccionWCF.Direccion_ListarCliente(((Usuario_LoginResult)Session["Usuario"]).idEmpresa,
((Usuario_LoginResult)Session["Usuario"]).codigoUsuario, idAgenda).ToList().FindAll(x => x.TipoDireccion == 104)
select new
{
x.ID,
DisplayField = String.Format("{0} {1} {2} {3}", x.Abreviatura, x.Direccion, x.Numero, x.Distrito)
};
cbobox.DataSource = dirFiscal;
cbobox.DataValueField = "ID";
cbobox.DataTextField = "DisplayField";
cbobox.DataBind();
if (cbobox.Items.Count > 0)
{
cbobox.SelectedIndex = 0;
}
}
catch (Exception ex)
{
throw ex;
}
}
protected void gvAutoSIPReject_ItemDataBound(object sender, GridItemEventArgs e)
{
if (e.Item is GridFilteringItem && e.Item.ItemIndex == -1)
{
DataTable dtgvWERPSIP = new DataTable();
GridFilteringItem filterItem = (GridFilteringItem)e.Item;
RadComboBox RadComboBoxRR = (RadComboBox)filterItem.FindControl("RadComboBoxRR");
dsRejectedSIP = (DataSet)Cache["RejectedAutoSIPDetails" + adviserVo.advisorId.ToString()];
DataTable dtSIP = new DataTable();
dtgvWERPSIP = dsRejectedSIP.Tables[0];
dtSIP.Columns.Add("WRR_RejectReasonDescription");
dtSIP.Columns.Add("WRR_RejectReasonCode");
DataRow drSIP;
foreach (DataRow dr in dtgvWERPSIP.Rows)
{
drSIP = dtSIP.NewRow();
drSIP["WRR_RejectReasonDescription"] = dr["WRR_RejectReasonDescription"].ToString();
drSIP["WRR_RejectReasonCode"] = int.Parse(dr["WRR_RejectReasonCode"].ToString());
dtSIP.Rows.Add(drSIP);
}
DataView view = new DataView(dtgvWERPSIP);
DataTable distinctValues = view.ToTable(true, "WRR_RejectReasonDescription", "WRR_RejectReasonCode");
RadComboBoxRR.DataSource = distinctValues;
RadComboBoxRR.DataValueField = dtSIP.Columns["WRR_RejectReasonCode"].ToString();
RadComboBoxRR.DataTextField = dtSIP.Columns["WRR_RejectReasonDescription"].ToString();
RadComboBoxRR.DataBind();
}
}
public static void bind_combobox(RadComboBox _obj, Int32 _id)
{
_obj.DataSource = dL.Talk.List(_id);
_obj.DataTextField = "title";
_obj.DataValueField = "talkid";
_obj.DataBind();
}
protected void cargarCadena()
{
RadComboBox cmb_cobertura = RadPanelBar_menu.FindChildByValue <RadPanelItem>("filtro").FindControl("cmb_cobertura") as RadComboBox;
RadComboBox cmb_cadena = RadPanelBar_menu.FindChildByValue <RadPanelItem>("filtro").FindControl("cmb_cadena") as RadComboBox;
RadComboBox cmb_ciudad = RadPanelBar_menu.FindChildByValue <RadPanelItem>("filtro").FindControl("cmb_ciudad") as RadComboBox;
Label lbl_cadena = RadPanelBar_menu.FindChildByValue <RadPanelItem>("filtro").FindControl("lbl_cadena") as Label;
cmb_cadena.Visible = false;
lbl_cadena.Visible = false;
DataTable dt = null;
iservicio = Convert.ToInt32(this.Session["Service"]);
iidcompany = Convert.ToInt32(this.Session["companyid"].ToString());
sidcanal = this.Session["Canal"].ToString();
if (cmb_cobertura.SelectedValue == "1" || cmb_ciudad.SelectedIndex > 0)
{
cmb_cadena.Visible = true;
lbl_cadena.Visible = true;
if (cmb_cobertura.SelectedValue == "1")
{
cmb_ciudad.SelectedValue = "9";
}
}
dt = oCoon.ejecutarDataTable("UP_WEBXPLORA_AD_OBTENER_NODECOMERCIAL_BY_cod_oficina", iservicio, sidcanal, iidcompany, cmb_ciudad.SelectedValue);
cmb_cadena.DataSource = dt;
cmb_cadena.DataValueField = "id_NodeCommercial";
cmb_cadena.DataTextField = "commercialNodeName";
cmb_cadena.DataBind();
cmb_cadena.Items.Insert(0, new RadComboBoxItem("--Todas--", "0"));
}
// set form input controls for insert/update
protected void gvDayType_ItemDataBound(object sender, GridItemEventArgs e)
{
if (e.Item is GridEditableItem && e.Item.IsInEditMode)
{
if (e.Item.OwnerTableView.DataMember == "DayTypeMaster")
{
ValidateDayType(e);
}
}
if (e.Item is GridCommandItem)
{
GridCommandItem commandItem = (GridCommandItem)e.Item;
RadComboBox ddlPrintOptions = (RadComboBox)commandItem.FindControl("ddlPrintOptions");
if (ddlPrintOptions != null)
{
Hashtable ht_Reports = new Hashtable();
ht_Reports.Add("@userid", Session["_UserID"].ToString());
ht_Reports.Add("@formtypeid", Request.QueryString["FormType"]);
DataTable dt_Reports = clsDAL.GetDataSet_admin("sp_Payroll_Get_Reports", ht_Reports).Tables[0];
if (ddlPrintOptions != null)
{
ddlPrintOptions.DataSource = dt_Reports;
ddlPrintOptions.DataTextField = "reportname";
ddlPrintOptions.DataValueField = "idd";
ddlPrintOptions.DataBind();
ddlPrintOptions.SelectedIndex = 0;
}
}
}
}
/// <summary>
/// When edit button is clicked, the RadComboBoc of the selected row is intitalised.
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void RadGrid1_ItemDataBound(object sender, GridItemEventArgs e)
{
// Bind AutoComplete values for Manager Column
if (e.Item is GridEditableItem)
{
GridDataItem gdi = e.Item as GridDataItem;
GridTableCell gdc = gdi["ManagerNameUnique"] as GridTableCell;
RadComboBox ManagerCB = (RadComboBox)gdc.FindControl("ManagerRadComboBox");
if (ManagerCB != null)
{
ManagerCB.DataSource = (from r in (Session["data"] as EmployeeDataContract).Employees
select r.Name).ToList <string>();
ManagerCB.DataBind();
// Initialize the ComboBox with the already selected text.
if (Session["ManagerInLabel"] != null)
{
ManagerCB.SelectedIndex = (from i in ManagerCB.Items
where i.Text == Session["ManagerInLabel"].ToString()
select i.Index).First <int>();
}
Session["ManagerInLabel"] = null;
}
}
}
public static void FillApstDDL(RadComboBox ddlApst, List<TouristApstInfo> lstTouristApst, int intSelected, int intTerritoryID)
{
ddlApst.DataSource = lstTouristApst;
ddlApst.DataTextField = "TuristApstakli";
ddlApst.DataValueField = "TuristApstakli_ID";
ddlApst.DataBind();
ddlApst.SelectedValue = intSelected.ToString();
}
protected void bindComboBox(RadComboBox r, DataSet d)
{
r.Items.Clear();
r.DataTextField = "AutoSearchResult";
r.DataSource = d;
r.DataBind();
r.Items.Insert(0, new RadComboBoxItem("", "0"));
r.SelectedValue = "0";
}
public void PopulateMasterSpeciality(RadComboBox rcbSpeciality)
{
DataSet dsSpeciality = objSpecialityBAL.SelectMasterSpeciality();
if (dsSpeciality.Tables.Count > 0 && dsSpeciality.Tables[0].Rows.Count > 0)
{
rcbSpeciality.DataSource = dsSpeciality;
rcbSpeciality.DataTextField = "DepartmentName";
rcbSpeciality.DataValueField = "DepartmentId";
rcbSpeciality.DataBind();
}
RadComboBoxItem CountryListItem = new RadComboBoxItem("--Select--", "--Select--");
rcbSpeciality.Items.Insert(0, CountryListItem);
}
// public void cmbCustomerProducts_OnLoad(object sender, EventArgs e)
public void cmbCustomerProducts_OnLoad(RadComboBox Box)
{
using (DataClasses1DataContext dbContext = new DataClasses1DataContext())
{
try
{
//RadComboBox cmbCustomerProducts = ((RadComboBox)sender);
//cmbCustomerProducts.Items.Clear();
//cmbCustomerProducts.Text = string.Empty;
if (Session["editableProductId"] != null && Session["editableProductId"].ToString() != string.Empty)
{
string myProductId = Session["editableProductId"].ToString();
Box.Visible = true;
//var myCustomers = from cust in dbContext.Customer
// join custProd in dbContext.CustomerProduct on cust.Id equals custProd.CustomerId into JoinedCustProd
// from custProd in JoinedCustProd.DefaultIfEmpty()
// orderby cust.Name ascending
// select new
// {
// CustomerId = cust.Id,
// CustomerName = cust.Name,
// IsChecked = custProd.ProductId == new Guid(Session["selectedProductId"].ToString()) ? true : false
// };
var myCustomers = from cust in dbContext.Customer
join lCust in dbContext.LargeCustomer on cust.Id equals lCust.CustomerId
orderby cust.Name ascending
select new
{
CustomerId = cust.Id,
CustomerName = String.IsNullOrEmpty(cust.MatchCode) ? cust.Name : cust.Name + "(" + cust.MatchCode + ")",
IsChecked = dbContext.CustomerProduct.SingleOrDefault(q => q.ProductId == new Guid(myProductId) && q.CustomerId == cust.Id) != null ? true : false
};
Box.DataSource = myCustomers;
Box.DataBind();
//cmbCustomerProducts.DataSource = myCustomers;
//cmbCustomerProducts.DataBind();
}
}
catch (Exception ex)
{
dbContext.WriteLogItem("Product Error " + ex.Message, LogTypes.ERROR, "Product");
throw new Exception(ex.Message);
}
}
}
public void getComboList_ID_Name(empStatus eStatus, RadComboBox cbx)
{
sqlStr = "EXEC proc_Get_EmpInfoIdName '" + (int)eStatus + "'";
sqlCon = new SqlConnection(cnStr);
sqlCon.Open();
sqlDA = new SqlDataAdapter(sqlStr, sqlCon);
dTable = new DataTable();
sqlDA.Fill(dTable);
cbx.DataSource = dTable;
cbx.DataTextField = "FullName";
cbx.DataValueField = "EmpId";
cbx.DataBind();
sqlCon.Close();
sqlCon.Dispose();
}
private void LoadControlToPage(int ReportId)
{
try
{
Panel.Controls.Clear();
cls_Report_User objUser = new cls_Report_User();
DataSet _ds = objUser.GetConfigReport(ReportId);
DataTable _dtConfig = _ds.Tables[0];
if (_dtConfig.Rows.Count == 0) return;
ViewState["Config"] = _dtConfig;
short TabIndex = 1;
Label LB;
string[] ArrRow =null;
int t = 0;
int k = 0;
while (k < _dtConfig.Rows.Count)
{
if (ArrRow == null)
Array.Resize(ref ArrRow, 1);
else
Array.Resize(ref ArrRow, ArrRow.Length + 1);
if (k < _dtConfig.Rows.Count - 1 && (Convert.ToInt32(_dtConfig.Rows[k]["Width"]) + Convert.ToInt32(_dtConfig.Rows[k + 1]["Width"]) <= (848 - 848 / 3)))
{
ArrRow[t] = k.ToString() + ":" + (k + 1).ToString();
k++;
}
else
{
ArrRow[t] = k.ToString();
}
t++;
k++;
}
//Lay max text
string strMax = "";
for (k = 0; k < ArrRow.Length; k++)
{
if (ArrRow[k] != null && ArrRow[k].Length > 0)
{
if (ArrRow[k].IndexOf(":") >= 0)
{
string[] ArStr = ArrRow[k].Split(':');
if (_dtConfig.Rows[Convert.ToInt32(ArStr[0])]["Parameter_Name"].ToString().Length > strMax.Length)
strMax = _dtConfig.Rows[Convert.ToInt32(ArStr[0])]["Parameter_Name"].ToString();
}
else
{
if (_dtConfig.Rows[Convert.ToInt32(ArrRow[k])]["Parameter_Name"].ToString().Length > strMax.Length)
strMax = _dtConfig.Rows[Convert.ToInt32(ArrRow[k])]["Parameter_Name"].ToString();
}
}
}
strMax += ": ";
//
for (k = 0; k < ArrRow.Length; k++)
{
if (k > 0)
{
HtmlAnchor te = new HtmlAnchor();
te.InnerHtml = "<br />";
Panel.Controls.Add(te);
HtmlAnchor te1 = new HtmlAnchor();
te1.InnerHtml = "<br />";
Panel.Controls.Add(te1);
}
if (ArrRow[k].Length > 0)
{
if (ArrRow[k].IndexOf(":") >= 0)
{
string[] ArStr = ArrRow[k].Split(':');
for (int j = 0; j < ArStr.Length; j++)
{
LB = new Label();
if (j > 0)
{
HtmlAnchor tex = new HtmlAnchor();
//tex.InnerText =
tex.InnerHtml = " ";
Panel.Controls.Add(tex);
}
string str = _dtConfig.Rows[Convert.ToInt32(ArStr[j])]["Parameter_Name"].ToString() + ": ";
LB.Text = str;
Panel.Controls.Add(LB);
if(j==0)
if (str.Length < strMax.Length)
{
string sadd ="";
for (int y = 0; y <= strMax.Length - str.Length;y++ )
sadd += " ";
HtmlAnchor add = new HtmlAnchor();
add.InnerHtml = sadd;
Panel.Controls.Add(add);
}
string sCate = _dtConfig.Rows[Convert.ToInt32(ArStr[j])]["Control_Type"].ToString();
if (sCate == "TextBox")
{
TextBox TB = new TextBox();
TB.ID = _dtConfig.Rows[Convert.ToInt32(ArStr[j])]["Parameter_Code"].ToString();
TB.Height = Convert.ToInt32(_dtConfig.Rows[Convert.ToInt32(ArStr[j])]["Height"]);
TB.Width = Convert.ToInt32(_dtConfig.Rows[Convert.ToInt32(ArStr[j])]["Width"]);
TB.TabIndex = TabIndex;
Panel.Controls.Add(TB);
}
if (sCate == "DatePicker")
{
RadDatePicker date = new RadDatePicker();
date.Height = Convert.ToInt32(_dtConfig.Rows[Convert.ToInt32(ArStr[j])]["Height"]);
date.Width = Convert.ToInt32(_dtConfig.Rows[Convert.ToInt32(ArStr[j])]["Width"]);
date.Skin = "Vista";
date.DateInput.DateFormat = "dd/MM/yyyy";
date.ID = _dtConfig.Rows[Convert.ToInt32(ArStr[j])]["Parameter_Code"].ToString();
// date.Culture = new System.Globalization.CultureInfo("Vietnamese");
date.Font.Bold = true; date.Font.Name = "Times New Roman";
date.Font.Size = 12;
date.SelectedDate = DateTime.Now;
date.TabIndex = TabIndex;
Panel.Controls.Add(date);
}
if (sCate == "DateTimePicker")
{
RadDateTimePicker date = new RadDateTimePicker();
date.Height = Convert.ToInt32(_dtConfig.Rows[Convert.ToInt32(ArStr[j])]["Height"]);
date.Width = Convert.ToInt32(_dtConfig.Rows[Convert.ToInt32(ArStr[j])]["Width"]);
date.Skin = "Vista";
date.DateInput.DateFormat = "dd/MM/yyyy";
date.ID = _dtConfig.Rows[Convert.ToInt32(ArStr[j])]["Parameter_Code"].ToString();
// date.Culture = new System.Globalization.CultureInfo("Vietnamese");
date.Font.Bold = true; date.Font.Name = "Times New Roman";
date.Font.Size = 12;
date.SelectedDate = DateTime.Now;
date.TabIndex = TabIndex;
Panel.Controls.Add(date);
}
if (sCate == "ComboBox")
{
RadComboBox com = new RadComboBox();
com.Skin = "Vista";
com.Height = Convert.ToInt32(_dtConfig.Rows[Convert.ToInt32(ArStr[j])]["Height"])*5;
com.Width = Convert.ToInt32(_dtConfig.Rows[Convert.ToInt32(ArStr[j])]["Width"]);
com.ID = _dtConfig.Rows[Convert.ToInt32(ArStr[j])]["Parameter_Code"].ToString();
com.EnableVirtualScrolling = true;
string SQL = _dtConfig.Rows[Convert.ToInt32(ArStr[j])]["Data_SQL"].ToString();
if (SQL.Length > 0)
{
DataTable _dt;
if (_dtConfig.Rows[Convert.ToInt32(ArStr[j])]["IsSP"] != null && Convert.ToBoolean(_dtConfig.Rows[Convert.ToInt32(ArStr[j])]["IsSP"]) == true)
{
int Index = SQL.IndexOf('@');
if (Index >= 0)
_dt = objUser.GetSP(SQL.Substring(0, Index), SQL.Substring(Index, SQL.Length - Index), Session["UserId"] == null ? "0" : Session["UserId"].ToString());
else
_dt = objUser.GetSP(SQL);
}
else
_dt = objUser.GetSQL(SQL);
com.DataValueField = "ID";
com.DataTextField = "Name";
com.DataSource = _dt;
com.DataBind();
}
com.TabIndex = TabIndex;
Panel.Controls.Add(com);
}
TabIndex++;
}
}
else
{
LB = new Label();
string str = _dtConfig.Rows[Convert.ToInt32(ArrRow[k])]["Parameter_Name"].ToString() + ": ";
LB.Text = str;
Panel.Controls.Add(LB);
if (str.Length < strMax.Length)
{
string sadd = "";
for (int y = 0; y <= strMax.Length - str.Length; y++)
sadd += " ";
HtmlAnchor add = new HtmlAnchor();
add.InnerHtml = sadd;
Panel.Controls.Add(add);
}
string sCate = _dtConfig.Rows[Convert.ToInt32(ArrRow[k])]["Control_Type"].ToString();
if (sCate == "TextBox")
{
TextBox TB = new TextBox();
TB.ID = _dtConfig.Rows[Convert.ToInt32(ArrRow[k])]["Parameter_Code"].ToString();
TB.Height = Convert.ToInt32(_dtConfig.Rows[Convert.ToInt32(ArrRow[k])]["Height"]);
TB.Width = Convert.ToInt32(_dtConfig.Rows[Convert.ToInt32(ArrRow[k])]["Width"]);
TB.TabIndex = TabIndex;
Panel.Controls.Add(TB);
}
if (sCate == "DatePicker")
{
RadDatePicker date = new RadDatePicker();
date.Height = Convert.ToInt32(_dtConfig.Rows[Convert.ToInt32(ArrRow[k])]["Height"]);
date.Width = Convert.ToInt32(_dtConfig.Rows[Convert.ToInt32(ArrRow[k])]["Width"]);
date.Skin = "Vista";
date.DateInput.DateFormat = "dd/MM/yyyy";
date.ID = _dtConfig.Rows[Convert.ToInt32(ArrRow[k])]["Parameter_Code"].ToString();
// date.Culture = new System.Globalization.CultureInfo("Vietnamese");
date.Font.Bold = true; date.Font.Name = "Times New Roman";
date.Font.Size = 12;
date.SelectedDate = DateTime.Now;
date.TabIndex = TabIndex;
Panel.Controls.Add(date);
}
if (sCate == "DateTimePicker")
{
RadDateTimePicker date = new RadDateTimePicker();
date.Height = Convert.ToInt32(_dtConfig.Rows[Convert.ToInt32(ArrRow[k])]["Height"]);
date.Width = Convert.ToInt32(_dtConfig.Rows[Convert.ToInt32(ArrRow[k])]["Width"]);
date.Skin = "Vista";
date.DateInput.DateFormat = "dd/MM/yyyy";
date.ID = _dtConfig.Rows[Convert.ToInt32(ArrRow[k])]["Parameter_Code"].ToString();
// date.Culture = new System.Globalization.CultureInfo("Vietnamese");
date.Font.Bold = true; date.Font.Name = "Times New Roman";
date.Font.Size = 12;
date.SelectedDate = DateTime.Now;
date.TabIndex = TabIndex;
Panel.Controls.Add(date);
}
if (sCate == "ComboBox")
{
RadComboBox com = new RadComboBox();
com.Skin = "Vista";
com.Height = Convert.ToInt32(_dtConfig.Rows[Convert.ToInt32(ArrRow[k])]["Height"]) * 5;
com.Width = Convert.ToInt32(_dtConfig.Rows[Convert.ToInt32(ArrRow[k])]["Width"]);
com.ID = _dtConfig.Rows[Convert.ToInt32(ArrRow[k])]["Parameter_Code"].ToString();
com.EnableVirtualScrolling = true;
string SQL = _dtConfig.Rows[Convert.ToInt32(ArrRow[k])]["Data_SQL"].ToString();
if (SQL.Length > 0)
{
DataTable _dt;
if (_dtConfig.Rows[Convert.ToInt32(ArrRow[k])]["IsSP"] != null && Convert.ToBoolean(_dtConfig.Rows[Convert.ToInt32(ArrRow[k])]["IsSP"]) == true)
{
int Index = SQL.IndexOf('@');
if (Index >= 0)
_dt = objUser.GetSP(SQL.Substring(0, Index), SQL.Substring(Index, SQL.Length - Index), Session["UserId"] == null ? "0" : Session["UserId"].ToString());
else
_dt = objUser.GetSP(SQL);
}
else
_dt = objUser.GetSQL(SQL);
com.DataValueField = "ID";
com.DataTextField = "Name";
com.DataSource = _dt;
com.DataBind();
}
com.TabIndex = TabIndex;
Panel.Controls.Add(com);
}
TabIndex++;
}
}
}
//
}
catch (Exception ex)
{
}
}
public void getPaymentCurrency(RadComboBox cbx)
{
sqlStr = "SELECT * FROM Currency WHERE Active=1 ORDER BY CurrencyID ASC";
sqlCon = new SqlConnection(cnStr);
sqlCon.Open();
sqlDA = new SqlDataAdapter(sqlStr, sqlCon);
dTable = new DataTable();
sqlDA.Fill(dTable);
cbx.DataSource = dTable;
cbx.DataTextField = "CurrencyName";
cbx.DataValueField = "CurrencyID";
cbx.DataBind();
sqlCon.Close();
sqlCon.Dispose();
}
/// <summary>
/// Populates the RAD combo box.
/// </summary>
/// <param name="e">The <see cref="Telerik.Web.UI.RadComboBoxItemsRequestedEventArgs"/> instance containing the event data.</param>
/// <param name="sourceListName">Name of the source list.</param>
/// <param name="valueFieldName">Name of the value field.</param>
/// <param name="textFieldName">Name of the text field.</param>
private void PopulateRadComboBox(RadComboBoxItemsRequestedEventArgs e, RadComboBox objRadComboBox, string sourceListName, string valueFieldName, string textFieldName)
{
DataTable dtFieldName = null;
StringBuilder strUserEnteredValue = new StringBuilder();
try
{
if(!string.IsNullOrEmpty(e.Text))
{
strUserEnteredValue.Append(e.Text);
//Commented in DREAM 4.0 For R%K Changes
/*if(!sourceListName.Equals(BASINLIST))
{
if(!strUserEnteredValue.ToString().Contains("*"))
{
strUserEnteredValue.Append("*");
}
}
else
{
char[] charSpecialCharacter = { '*', '%' };
if(strUserEnteredValue.ToString().Contains("*") || strUserEnteredValue.ToString().Contains("%"))
{
strUserEnteredValue.Remove(strUserEnteredValue.ToString().IndexOfAny(charSpecialCharacter), (strUserEnteredValue.ToString().Length - strUserEnteredValue.ToString().IndexOfAny(charSpecialCharacter)));
}
}*/
//Added in DREAM 4.0 For R%K Changes
//Starts
if(!strUserEnteredValue.ToString().Contains("*"))
{
strUserEnteredValue.Append("*");
}
//Ends
dtFieldName = GetDataForComboBox(strUserEnteredValue.ToString(), sourceListName);
if(dtFieldName != null && dtFieldName.Rows.Count > 0)
{
int intItemsPerRequest = 111;
int intItemOffset = e.NumberOfItems;
int intEndOffset = Math.Min(intItemOffset + intItemsPerRequest, dtFieldName.Rows.Count);
e.EndOfItems = intEndOffset == dtFieldName.Rows.Count;
objRadComboBox.DataSource = dtFieldName;
objRadComboBox.DataTextField = textFieldName;
objRadComboBox.DataValueField = valueFieldName;
objRadComboBox.DataBind();
e.Message = dtFieldName.Rows.Count.ToString();
}
else
{
e.Message = NORECORDFOUNDSEXCEPTIONMESSAGE;
}
}
}
finally
{
if(dtFieldName != null)
dtFieldName.Dispose();
}
}
static void BindCombo(object dataSource, RadComboBox combo, string textField, string valueField)
{
combo.DataSource = dataSource;
combo.DataTextField = textField;
combo.DataValueField = valueField;
combo.DataBind();
}
private void BindStateCombo(RadComboBox sender, int contryId)
{
objBindCombo = new BindCombo();
sender.Items.Clear();
sender.ClearSelection();
sender.DataTextField = "STATE_NAME";
sender.DataValueField = "STATE_ID";
sender.DataSource = objBindCombo.GetStateKeyValue(contryId);
sender.DataBind();
sender.Items.Insert(0, new RadComboBoxItem("", "0"));
sender.SelectedValue = "0";
}
private void BindCountryDropDown(List<CountryElement> countries, RadComboBox countryRadComboBox)
{
countryRadComboBox.DataSource = countries;
countryRadComboBox.DataTextField = "Name";
countryRadComboBox.DataValueField = "IsoCode";
countryRadComboBox.DataBind();
}
private void LoadListSalesmenToCombo(ICollection trom, RadComboBox comboBox, string firstItemText)
{
if (trom != null)
{
comboBox.DataSource = trom;
comboBox.DataTextField = DataTextFieldName;
comboBox.DataValueField = DataValueFieldName;
comboBox.DataBind();
if (trom.Count > 0)
{
var item = new RadComboBoxItem(firstItemText, "0");
comboBox.Items.Insert(0, item);
}
}
}
private void BindSecurityQuestionCombo(RadComboBox sender)
{
objUserMasterDAL = new UserMasterDal();
sender.Items.Clear();
sender.ClearSelection();
sender.DataTextField = "SECURITY_QUESTION_DESC";
sender.DataValueField = "SECURITY_QUESTION_ID";
sender.DataSource = objUserMasterDAL.GetSecurityQuestion();
sender.DataBind();
sender.Items.Insert(0, new RadComboBoxItem("--Select--", "0"));
sender.SelectedValue = "0";
}
private void LoadControls()
{
ds = BankProject.DataProvider.KhanhND.B_BDYNAMICCONTROLS_GetControls(Request.QueryString["tabid"].ToString(), this.ID.ToString(), Session["DataKey"].ToString());
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
if (i > 0)
{
Label lb = new Label();
lb.ID = "lbl" + ds.Tables[0].Rows[i]["DataControlID"].ToString();
lb.Text = VVTLabel;
RadComboBox rcb = new RadComboBox();
rcb.ID = "rcb" + ds.Tables[0].Rows[i]["DataControlID"].ToString();
rcb.AutoPostBack = true;
rcb.Items.Add(new RadComboBoxItem(""));
rcb.SelectedIndexChanged += rcb_SelectedIndexChanged;
rcb.AppendDataBoundItems = true;
rcb.Width = Unit.Parse(Width);
rcb.DataTextField = "TextField";
rcb.DataValueField = "ValueField";
if (DataSource != null)
{
rcb.DataSource = DataSource;
rcb.DataBind();
rcb.SelectedValue = ds.Tables[0].Rows[i]["Datavalue"].ToString();
}
ImageButton ibt = new ImageButton();
ibt.ID = "ibt" + ds.Tables[0].Rows[i]["DataControlID"].ToString();
ibt.ImageUrl = "~/Icons/Sigma/Delete_16X16_Standard.png";
ibt.Click += ibt_Click;
TableRow tr = new TableRow();
tr.ID = ds.Tables[0].Rows[i]["DataControlID"].ToString();
TableCell tc = new TableCell();
tc.CssClass = "MyLable";
tc.Controls.Add(lb);
tc.Width = Unit.Parse(LBWidth);
TableCell tc2 = new TableCell();
tc2.CssClass = "MyContent";
tc2.Width = Unit.Parse(Width);
tc2.Controls.Add(rcb);
TableCell tc3 = new TableCell();
tc3.Controls.Add(ibt);
tr.Cells.Add(tc);
tr.Cells.Add(tc2);
tr.Cells.Add(tc3);
tblMain.Rows.Add(tr);
}
else
{
Label lb = new Label();
lb.ID = "lbl" + ds.Tables[0].Rows[i]["DataControlID"].ToString();
lb.Text = VVTLabel;
RadComboBox rcb = new RadComboBox();
rcb.ID = "rcb" + ds.Tables[0].Rows[i]["DataControlID"].ToString();
rcb.AutoPostBack = true;
rcb.Items.Add(new RadComboBoxItem(""));
rcb.SelectedIndexChanged += rcb_SelectedIndexChanged;
rcb.AppendDataBoundItems = true;
rcb.Width = Unit.Parse(Width);
rcb.DataTextField = "TextField";
rcb.DataValueField = "ValueField";
if (DataSource != null)
{
rcb.DataSource = DataSource;
rcb.DataBind();
rcb.SelectedValue = ds.Tables[0].Rows[i]["Datavalue"].ToString();
}
rcb.Enabled = Enabled;
ImageButton ibt = new ImageButton();
ibt.ID = "ibt" + ds.Tables[0].Rows[i]["DataControlID"].ToString();
ibt.ImageUrl = "~/Icons/Sigma/Add_16X16_Standard.png";
ibt.Click += ibtVVT_Click;
ibt.Enabled = Enabled;
TableRow tr = new TableRow();
tr.ID = ds.Tables[0].Rows[i]["DataControlID"].ToString();
TableCell tc = new TableCell();
tc.CssClass = "MyLable";
tc.Controls.Add(lb);
tc.Width = Unit.Parse(LBWidth);
TableCell tc2 = new TableCell();
tc2.CssClass = "MyContent";
tc2.Width = Unit.Parse(Width);
tc2.Controls.Add(rcb);
TableCell tc3 = new TableCell();
tc3.Controls.Add(ibt);
tr.Cells.Add(tc);
tr.Cells.Add(tc2);
tr.Cells.Add(tc3);
tblMain.Rows.Add(tr);
}
}
}
/// <summary>
/// Populates the RAD combo box.
/// </summary>
/// <param name="e">The <see cref="Telerik.Web.UI.RadComboBoxItemsRequestedEventArgs"/> instance containing the event data.</param>
/// <param name="sourceListName">Name of the source list.</param>
/// <param name="valueFieldName">Name of the value field.</param>
/// <param name="textFieldName">Name of the text field.</param>
protected void PopulateRadComboBox(RadComboBoxItemsRequestedEventArgs e, RadComboBox objRadComboBox, string sourceListName, string valueFieldName, string textFieldName, bool populateFromSharePointList)
{
DataTable dtFieldName = null;
StringBuilder strUserEnteredValue = new StringBuilder();
try
{
if (!string.IsNullOrEmpty(e.Text))
{
if (e.Text == "empty")
{
e.Text = string.Empty;
}
strUserEnteredValue.Append(e.Text);
if (!populateFromSharePointList)
{
strUserEnteredValue.Append("*");
}
dtFieldName = GetDataSource(sourceListName, strUserEnteredValue.ToString());
if (dtFieldName != null && dtFieldName.Rows.Count > 0)
{
int intItemsPerRequest = 111;
int intItemOffset = e.NumberOfItems;
int intEndOffset = Math.Min(intItemOffset + intItemsPerRequest, dtFieldName.Rows.Count);
e.EndOfItems = intEndOffset == dtFieldName.Rows.Count;
objRadComboBox.DataSource = dtFieldName;
objRadComboBox.DataTextField = textFieldName;
objRadComboBox.DataValueField = valueFieldName;
objRadComboBox.DataBind();
e.Message = dtFieldName.Rows.Count.ToString();
RadComboBoxItem radComboItem = new RadComboBoxItem(DEFAULTDROPDOWNTEXT);
objRadComboBox.Items.Insert(0, radComboItem);
}
else
{
e.Message = dtFieldName.Rows.Count.ToString();
RadComboBoxItem radComboItem = new RadComboBoxItem(DEFAULTDROPDOWNTEXT);
objRadComboBox.Items.Clear();
objRadComboBox.Items.Insert(0, radComboItem);
e.Message = NORECORDFOUNDSEXCEPTIONMESSAGE;
}
}
}
finally
{
if (dtFieldName != null)
dtFieldName.Dispose();
}
}
/// <summary>
/// Loads the lithostrat group controls.
/// </summary>
private void LoadLithostratGroup(string listName, string filteredValue, RadComboBox radCboLithostratGroup, string dataTextField, string dataValueField)
{
DataTable dtLithostratGroup = null;
try
{
dtLithostratGroup = GetDataSource(listName, filteredValue);
if (dtLithostratGroup != null && dtLithostratGroup.Rows.Count > 0)
{
radCboLithostratGroup.DataSource = dtLithostratGroup;
radCboLithostratGroup.DataTextField = dataTextField;
radCboLithostratGroup.DataValueField = dataValueField;
radCboLithostratGroup.DataBind();
radCboLithostratGroup.Items.Insert(0, new RadComboBoxItem(DEFAULTDROPDOWNTEXT));
radCboLithostratGroup.SelectedIndex = 0;
}
else
{
radCboLithostratGroup.ErrorMessage = NORECORDFOUNDSEXCEPTIONMESSAGE;
}
}
catch (SoapException soapEx)
{
if (soapEx.Message.Equals(SOAPEXCEPTIONMESSAGE))
{
radCboLithostratGroup.ErrorMessage = NORECORDFOUNDSEXCEPTIONMESSAGE;
}
else
{
radCboLithostratGroup.ErrorMessage = UNEXPECTEDEXCEPTIONMESSAGE;
CommonUtility.HandleException(strCurrSiteURL, soapEx, 1);
}
}
catch (WebException webEx)
{
radCboLithostratGroup.ErrorMessage = UNEXPECTEDEXCEPTIONMESSAGE;
CommonUtility.HandleException(strCurrSiteURL, webEx, 1);
}
catch (Exception ex)
{
CommonUtility.HandleException(strCurrSiteURL, ex);
}
finally
{
if (dtLithostratGroup != null)
{
if (dtLithostratGroup.DataSet != null)
dtLithostratGroup.DataSet.Dispose();
dtLithostratGroup.Dispose();
}
}
}
protected void ibtVVT_Click(object sender, ImageClickEventArgs e)
{
DataSet dst = DataProvider.KhanhND.B_BDYNAMICCONTROLS_Update("0", Request.QueryString["tabid"].ToString(), this.ID.ToString(), "", "", Session["DataKey"].ToString());
Label lb = new Label();
lb.ID = "lbl" + dst.Tables[0].Rows[0]["DataControlID"].ToString();
lb.Text = VVTLabel;
RadComboBox rcb = new RadComboBox();
rcb.ID = "rcb" + dst.Tables[0].Rows[0]["DataControlID"].ToString();
rcb.AutoPostBack = true;
rcb.Items.Add(new RadComboBoxItem(""));
rcb.AppendDataBoundItems = true;
rcb.Width = Unit.Parse(Width);
rcb.DataTextField = "TextField";
rcb.DataValueField = "ValueField";
if (DataSource != null)
{
rcb.DataSource = DataSource;
rcb.DataBind();
}
ImageButton ibt = new ImageButton();
ibt.ID = "ibt" + dst.Tables[0].Rows[0]["DataControlID"].ToString();
ibt.ImageUrl = "~/Icons/Sigma/Delete_16X16_Standard.png";
ibt.Click += ibt_Click;
TableRow tr = new TableRow();
tr.ID = dst.Tables[0].Rows[0]["DataControlID"].ToString();
TableCell tc = new TableCell();
tc.CssClass = "MyLable";
tc.Controls.Add(lb);
tc.Width = Unit.Parse(LBWidth);
TableCell tc2 = new TableCell();
tc2.CssClass = "MyContent";
tc2.Width = Unit.Parse(Width);
tc2.Controls.Add(rcb);
TableCell tc3 = new TableCell();
tc3.Controls.Add(ibt);
tr.Cells.Add(tc);
tr.Cells.Add(tc2);
tr.Cells.Add(tc3);
tblMain.Rows.Add(tr);
}
public void LoadComboBox(RadComboBox RadDropDown, string SQL, string DisplayField, string ValueField, bool AppendRow = true)
{
AppManager am = new AppManager();
DataTable dt = am.DataAccess.RecordSet(SQL, new string[] { });
if (AppendRow)
{
DataRow dRow = dt.NewRow();
dRow[ValueField] = "0";
dRow[DisplayField] = "";
dt.Rows.InsertAt(dRow, 0);
}
RadDropDown.DataSource = dt;
RadDropDown.DataTextField = DisplayField;
RadDropDown.DataValueField = ValueField;
RadDropDown.DataBind();
if (AppendRow)
{
RadDropDown.SelectedValue = "0";
}
}
protected void SelectedCountry(object sender, EventArgs e)
{
string formID = Session["formpage"].ToString();
RadComboBox countryDrop = (RadComboBox)sender;
RadComboBox stateDrop = new RadComboBox();
TextBox stateTextB = new TextBox();
//if (formID == "1")
//{
// countryDrop = (RadComboBox)FindControl("CountryLabelDropDown");
// stateTextB = (TextBox)FindControl("StateLabelTextBox");
// stateDrop = (RadComboBox)FindControl("StateLabelDropDown");
//}
//else
//{
countryDrop = (RadComboBox)FindControl("CountryLabel" + formID + "RadComboBox");
stateTextB = (TextBox)FindControl("StateLabel" + formID + "TextBox");
stateDrop = (RadComboBox)FindControl("StateLabel" + formID + "RadComboBox");
//}
DataSet dsState = doQuery("SELECT * FROM States WHERE country_id=" + countryDrop.SelectedValue);
if (dsState.Tables.Count > 0)
if (dsState.Tables[0].Rows.Count > 0)
{
stateDrop.Items.Clear();
stateTextB.Visible = false;
stateDrop.Visible = true;
stateDrop.DataSource = dsState;
stateDrop.DataTextField = "state_name";
stateDrop.DataValueField = "state_id";
stateDrop.DataBind();
stateDrop.Items.Insert(0, new RadComboBoxItem("Please Select", "-1"));
}
else
{
stateTextB.Visible = true;
stateDrop.Visible = false;
}
else
{
stateTextB.Visible = true;
stateDrop.Visible = false;
}
if (countryDrop.SelectedValue != "223")
{
Panel temp = (Panel)FindControl(countryDrop.ID + "Local");
temp.Visible = false;
temp = (Panel)FindControl(countryDrop.ID + "Local2");
temp.Visible = false;
temp = (Panel)FindControl(countryDrop.ID + "International");
temp.Visible = true;
}
else
{
Panel temp = (Panel)FindControl(countryDrop.ID + "Local");
temp.Visible = true;
temp = (Panel)FindControl(countryDrop.ID + "Local2");
temp.Visible = true;
temp = (Panel)FindControl(countryDrop.ID + "International");
temp.Visible = false;
}
}
protected void Page_Init(object sender, EventArgs e)
{
SamesAsCheckBox3.Checked = false;
SamesAsCheckBox32.Checked = false;
SameAsLabel4CheckBox.Checked = false;
SameAsBillingLabel4CheckBox.Checked = false;
SameAsShippingLabel4CheckBox.Checked = false;
StaticFieldsPanel1.Visible = false;
StaticFieldsPanel2.Visible = false;
StaticFieldsPanel3.Visible = false;
StaticFieldsPanel4.Visible = false;
StaticFieldsPanel5.Visible = false;
StaticFieldsPanel6.Visible = false;
StaticFieldsPanel7.Visible = false;
StaticFieldsPanel8.Visible = false;
StaticFieldsPanel9.Visible = false;
if(Session["AccountCreateType"] == null)
Session["AccountCreateType"] = "Create";
bool isCreate = false;
if (Session["AccountCreateType"] == "Create")
isCreate = true;
string message = "";
try
{
if (Session["formpage"] == null)
{
Session["formpage"] = "1";
}
bool drawForm = false;
if (Session["RedrawForm"] == null)
{
drawForm = true;
}
else
{
if (bool.Parse(Session["RedrawForm"].ToString()))
drawForm = true;
else
drawForm = false;
}
if (!IsPostBack)
{
drawForm = true;
}
//ErrorLabel.Text = "got here2";
DataSet dsAll = doQuery("SELECT * FROM FormStaticPageFields");
if (drawForm)
{
string formID = Session["formpage"].ToString();
if (int.Parse(formID) < 7)
{
if (!isCreate)
{
Image theImage = (Image)FindControl("Image" + formID);
theImage.Visible = true;
}
DataSet ds = doQuery("SELECT NavTitle FROM FormPages WHERE ID=" + formID);
DataSet dsForm = doQuery("SELECT * FROM FormStaticPageFields WHERE FormPageID=" + formID);
DataSet dsCount = doQuery("SELECT DISTINCT FormPageID FROM FormStaticPageFields");
if (int.Parse(formID) < 6)
{
//ErrorLabel.Text = "got here";
ProductName.Text = ds.Tables[0].Rows[0]["NavTitle"].ToString();
if (formID == "2")
{
AllMoneyPanel.DefaultButton = "Button1";
}
else if(formID == "5")
{
AllMoneyPanel.DefaultButton = "Button5";
StaticFieldsPanel2.DefaultButton = "Button5";
BillingHidePanel.DefaultButton = "Button5";
}
}
else if(formID == "6")
{
ProductName.Text = "Review Order Information";
}
else if (formID == "7")
{
ProductName.Visible = false;
//Get the invoice
Explore.NetSuite.DataAccess.NDAL client = new Explore.NetSuite.DataAccess.NDAL();
Array theTransactions = (Array)client.GetTransactions(Session["UserID"].ToString(), DateTime.Now.AddMinutes(double.Parse("-10.00")), DateTime.Now);
//code recommended by john ogle. refer to bug 1688 in OA bug tracking system.
Dictionary<string, IEnumerable<Transaction>> invoiceMap = new Dictionary<string, IEnumerable<Transaction>>();
List<Transaction> invoices;
foreach (Transaction t in theTransactions)
{
if (t.Type != "SalesOrd")
{
invoices = new List<Transaction>();
if (invoiceMap.ContainsKey(t.CreatedFrom))
{
invoices = (List<Transaction>)invoiceMap[t.CreatedFrom];
}
else
{
invoiceMap.Add(t.CreatedFrom, invoices);
}
invoices.Add(t);
}
}
foreach (Transaction oneTrans in theTransactions)
{
if (oneTrans.Type == "SalesOrd" && oneTrans.OrderNumber == Session["OrderNumber"].ToString())
{
SalesOrderHyperLink.NavigateUrl = oneTrans.PrintoutURL;
}
}
}
else if (formID == "8")
{
ProductName.Visible = false;
}
if (formID == "6")
{
Explore.NetSuite.DataAccess.NDAL client = new Explore.NetSuite.DataAccess.NDAL();
BuildIt(client, client.GetCustomer(Session["UserID"].ToString()));
}
Panel staticPanel = (Panel)FindControl("StaticFieldsPanel" + formID);
staticPanel.Visible = true;
if (dsAll.Tables.Count > 0)
{
for (int i = 0; i < dsAll.Tables[0].Rows.Count; i++)
{
Label theLabel = (Label)FindControl(dsAll.Tables[0].Rows[i]["LabelFormName"].ToString());
message += dsAll.Tables[0].Rows[i]["LabelFormName"].ToString();
theLabel.Text = dsAll.Tables[0].Rows[i]["LabelName"].ToString();
}
}
RadComboBoxItem item;
RadComboBox countryDrop = new RadComboBox();
RadComboBox stateDrop = new RadComboBox();
TextBox stateTextB = new TextBox();
for (int i = 0; i < dsCount.Tables[0].Rows.Count; i++)
{
countryDrop = (RadComboBox)FindControl("CountryLabel" + (i + 1).ToString() + "RadComboBox");
stateTextB = (TextBox)FindControl("StateLabel" + (i + 1).ToString() + "TextBox");
stateDrop = (RadComboBox)FindControl("StateLabel" + (i + 1).ToString() + "RadComboBox");
if (countryDrop != null)
{
message += "fin got here";
DataSet dsCountry = doQuery("SELECT * FROM Countries ORDER BY country_2_code asc");
countryDrop.Items.Clear();
countryDrop.DataSource = dsCountry;
countryDrop.DataTextField = "country_name";
countryDrop.DataValueField = "country_id";
countryDrop.DataBind();
//for (int n = 0; n < dsCountry.Tables["table"].Rows.Count; n++)
//{
// item = new RadComboBoxItem(dsCountry.Tables["table"].Rows[n]["country_2_code"].ToString(),
// dsCountry.Tables["table"].Rows[n]["country_id"].ToString());
// countryDrop.Items.Add(item);
//}
dsCountry = doQuery("SELECT * FROM countries where country_name='" + ConfigurationManager.AppSettings.Get("defaultcountry") + "'");
countryDrop.SelectedValue = dsCountry.Tables["table"].Rows[0]["country_id"].ToString();
DataSet dsState = doQuery("SELECT * FROM states WHERE country_id=" + countryDrop.SelectedValue + " ORDER BY state_name ASC");
if (dsState.Tables["table"].Rows.Count > 0)
{
stateDrop.Items.Clear();
for (int n = 0; n < dsState.Tables["table"].Rows.Count; n++)
{
item = new RadComboBoxItem(dsState.Tables["table"].Rows[n]["state_name"].ToString(), dsState.Tables["table"].Rows[n]["state_code"].ToString());
stateDrop.Items.Add(item);
}
stateTextB.Visible = false;
stateDrop.Visible = true;
stateDrop.Items.Insert(0, new RadComboBoxItem("Please Select...", "-1"));
}
else
{
stateTextB.Visible = true;
stateDrop.Visible = false;
}
}
}
}
else
{
GoToForm(int.Parse(formID), 1);
}
}
DataView dvHelp = new DataView(dsAll.Tables[0], "hasHelp='True'", "", DataViewRowState.CurrentRows);
for (int j = 0; j < dvHelp.Count; j++)
{
Panel helpPanel = (Panel)FindControl(dvHelp[j]["LabelFormName"].ToString() + "HelpPanel");
CreateHelp(dvHelp[j]["HelpText"].ToString(), j.ToString(), ref helpPanel);
}
SetBoxes();
AddFields();
if (drawForm)
{
switch (Session["formpage"].ToString())
{
//case "1":
// FillAccount();
// break;
case "1":
RoleDropDown.Items.Clear();
DataSet ds = doQuery("SELECT * FROM ROLES ORDER BY ID ASC");
RadComboBoxItem item = new RadComboBoxItem();
item.Text = "Please Select...";
item.Value = "-1";
RoleDropDown.Items.Add(item);
for (int i = 0; i < ds.Tables["table"].Rows.Count; i++)
{
item = new RadComboBoxItem(ds.Tables["table"].Rows[i]["NAME"].ToString(),
ds.Tables["table"].Rows[i]["NetSuiteID"].ToString());
RoleDropDown.Items.Add(item);
}
ds = new DataSet();
AccountDropDown.Items.Clear();
ds = doQuery("SELECT * FROM AccountType");
item = new RadComboBoxItem();
item.Text = "Please Select...";
item.Value = "-1";
AccountDropDown.Items.Add(item);
AccountDropDown.Width = 240;
for (int i = 0; i < ds.Tables["table"].Rows.Count; i++)
{
item = new RadComboBoxItem(ds.Tables["table"].Rows[i]["AccountType"].ToString(),
ds.Tables["table"].Rows[i]["NetSuiteID"].ToString());
AccountDropDown.Items.Add(item);
}
break;
case "2":
StaticFieldsPanel2.DefaultButton = "Button1";
BillingHidePanel.DefaultButton = "Button1";
FillBilling();
break;
case "3":
FillShipping();
break;
case "4":
FillDelivery();
break;
case "5":
StaticFieldsPanel2.DefaultButton = "Button5";
BillingHidePanel.DefaultButton = "Button5";
GoToForm(5, 4);
//SetBoxes();
//BuildIt();
FillPayment();
break;
case "6":
GoToForm(6, 5);
Explore.NetSuite.DataAccess.NDAL client = new Explore.NetSuite.DataAccess.NDAL();
BuildIt(client, client.GetCustomer(Session["UserID"].ToString()));
FillPayment();
SetBoxes();
break;
default: break;
}
}
}
catch (Exception ex)
{
ErrorLabel.Text = ex.ToString() + message;
}
if (Session["formpage"] == "2")
{
if (Session["InShopping"] != null)
{
Button9.Visible = false;
}
}
}
private void BindEmployeeCombo(RadComboBox sender)
{
objUserMasterDAL = new UserMasterDal();
sender.Items.Clear();
sender.ClearSelection();
sender.DataTextField = "EMP_NAME";
sender.DataValueField = "EMP_ID";
sender.DataSource = objUserMasterDAL.GetEmployeeKeyValue();
sender.DataBind();
sender.Items.Insert(0, new RadComboBoxItem("", "0"));
sender.SelectedValue = "0";
}
private void BindComboBox(RadComboBox comboBox, bool hasAll, ItemType type)
{
string text = string.Empty;
string value = string.Empty;
comboBox.Items.Clear();
switch (type)
{
case ItemType.AllRoles:
text = "rolename";
value = "roleid";
comboBox.DataSource = AllRoles;
break;
case ItemType.AllSchools:
text = "name";
value = "id";
comboBox.DataSource = AllSchools;
break;
case ItemType.AllSchoolTypes:
text = "name";
value = "name";
comboBox.DataSource = AllSchoolTypes;
break;
case ItemType.AllPortals:
text = "portalname";
value = "id";
comboBox.DataSource = adm.GetPortalSelections();
break;
}
comboBox.DataTextField = text;
comboBox.DataValueField = value;
comboBox.DataBind();
if (hasAll)
{
comboBox.Items.Add(new RadComboBoxItem("All", "All"));
}
}
//
public static void initRadComboBox(ref RadComboBox cboList, string DataTextField, string DataValueField, object DataSource)
{
cboList.Items.Clear();
//
cboList.DataTextField = DataTextField;
cboList.DataValueField = DataValueField;
cboList.DataSource = DataSource;
cboList.DataBind();
if (cboList.Items.Count > 0)
{
cboList.Items.Insert(0, new RadComboBoxItem(""));
}
}
private void BindCountryCombo(RadComboBox sender)
{
objBindCombo = new BindCombo();
sender.Items.Clear();
sender.ClearSelection();
sender.DataTextField = "COUNTRY_NAME";
sender.DataValueField = "COUNTRY_ID";
sender.DataSource = objBindCombo.GetCountryKeyValue();
sender.DataBind();
sender.Items.Insert(0, new RadComboBoxItem("", "0"));
sender.SelectedValue = "0";
}
private void bindCountryCombo(RadComboBox sender, DataSet source)
{
objBindCombo = new BindCombo();
sender.Items.Clear();
sender.ClearSelection();
sender.DataTextField = "COUNTRY_NAME";
sender.DataValueField = "COUNTRY_ID";
if (source != null)
sender.DataSource = source;
else
sender.DataSource = objBindCombo.GetAirLine();
sender.DataBind();
sender.Items.Insert(0, new RadComboBoxItem("", "0"));
sender.SelectedValue = "0";
}
//#region btnDeleteAirport_Click
//protected void btnDeleteAirport_Click(object sender, EventArgs e)
//{
// try
// {
// int serialNo = 0;
// ImageButton imgbtnDetailDelete = (ImageButton)sender;
// if (imgbtnDetailDelete != null)
// Int32.TryParse(imgbtnDetailDelete.CommandArgument, out serialNo);
// objAirlineMapDal = new AirlineMapDal();
// int result = objAirlineMapDal.DeleteAirportBySrNo(serialNo);
// if (result == 1)
// {
// Master.DisplayMessage(ConfigurationSettings.AppSettings[SuccessMessage.Delete].ToString());
// Master.MessageCssClass = "successMessage";
// BindAirportGrid();
// }
// else if (result == 547)
// {
// Master.DisplayMessage(ConfigurationSettings.AppSettings[FailureMessage.Delete].ToString());
// Master.MessageCssClass = "errorMessage";
// }
// else
// {
// Master.DisplayMessage(ConfigurationSettings.AppSettings[FailureMessage.Delete].ToString());
// Master.MessageCssClass = "errorMessage";
// }
// }
// catch (Exception ex)
// {
// bool rethrow = ExceptionPolicy.HandleException(ex, DALHelper.DAL_EXP_POLICYNAME);
// if (rethrow)
// { throw ex; }
// }
//}
//#endregion
#endregion
#region Method
private void BindRegionCombo(RadComboBox sender, DataSet source)
{
objBindCombo = new BindCombo();
sender.Items.Clear();
sender.ClearSelection();
sender.DataTextField = "REGION_LONG_NAME";
sender.DataValueField = "REGION_ID";
if (source != null)
sender.DataSource = source;
else
sender.DataSource = objBindCombo.GetCityKeyValue(0, 0);
sender.DataBind();
sender.Items.Insert(0, new RadComboBoxItem("", "0"));
sender.SelectedValue = "0";
}
protected void bindComboBoxforquestion(RadComboBox r, DataSet d)
{
r.Items.Clear();
r.DataTextField = "MAIN_GROUP";
// r.DataValueField = "TEST_QUESTION_SRNO";
r.DataSource = d;
r.DataBind();
r.Items.Insert(0, new RadComboBoxItem("", ""));
r.SelectedValue = "";
}
public void LoadComboBox(RadComboBox RadDropDown, string SQL, string DisplayField, string ValueField, string[] WhereCluseValue)
{
AppManager am = new AppManager();
DataTable dt = am.DataAccess.RecordSet(SQL, WhereCluseValue);
DataRow dRow = dt.NewRow();
dRow[ValueField] = "0";
dRow[DisplayField] = "";
dt.Rows.Add(dRow);
RadDropDown.DataSource = dt;
RadDropDown.DataTextField = DisplayField;
RadDropDown.DataValueField = ValueField;
RadDropDown.DataBind();
RadDropDown.SelectedValue = "0";
}
