public void ListaDetallesOrden() { var id = Request.Params["ORDERID"]; using (var connection = new FesaDataSourceDataContext()) { var customer = connection.GET_ASSIGNMENTDETAILS_SP(id).ToList(); var contacto = connection.GET_CONTACTDETAILS_SP(id).ToList(); var user = connection.GET_PERSONNELDETAILS_SP(id).ToList(); foreach (var c in customer) { Code.Text = c.CODE; Empresa.Text = c.NAME; Description.Text = c.DESCRIPTION; FechSolicitud.Text = c.REQUESTDATE.Value.ToString("dd/MM/yyyy"); FechEstimada.Text = c.ESTIMATEDSTARTDATE.Value.ToString("dd/MM/yyyy"); FechFinEstimada.Text = c.ESTIMATEDENDDATE.Value.ToString("dd/MM/yyyy"); District.Text = c.DISTRICT; Department.Text = c.DEPARTMENT; Province.Text = c.PROVINCE; Serial.Text = c.SERIALNUMBER; Brand.Text = c.BRAND; Model.Text = c.MODEL; LifeHours.Text = Convert.ToString(c.LIFEHOURS); } } }
public void ListaContacto() { using (var connection = new FesaDataSourceDataContext()) { var id = Request.Params["ORDERID"]; List <Contacto> list = new List <Contacto>(); var connec = connection.GET_CONTACTDETAILS_SP(id).ToList(); foreach (var u in connec) { list.Add(new Contacto { NameContact = u.NAME, EmailContact = u.EMAIL, PhoneContact = u.PHONE }); } GVContact.DataSource = list.ToList(); GVContact.DataBind(); } }