// method for getting divorcios. public static pBaseDivorcioAccidenteFacturacion getDivorciosAccidente(string ID) { pBaseDivorcioAccidenteFacturacion pBase = new pBaseDivorcioAccidenteFacturacion(); using (SqlConnection con = DBcomun.getConnection()) { SqlCommand comand = new SqlCommand(string.Format("SELECT * FROM divorcios WHERE ID = '{0}'", ID), con); SqlDataReader re = comand.ExecuteReader(); while (re.Read()) { pBase.ID = re["ID"].ToString(); pBase.DemandanteID = re["DemandanteID"].ToString(); pBase.DemandadoID = re["DemandadoID"].ToString(); pBase.serviceID = re["serviceID"].ToString(); pBase.Pagos = Convert.ToDouble(re["Pagos"]).ToString("f2"); pBase.Honorarios = Convert.ToDouble(re["Honorarios"]).ToString("f2"); pBase.Abono = Convert.ToDouble(re["Abono"]).ToString("f2"); } con.Close(); } return(pBase); }
// method for getting divorcios. public static pBaseDivorcioAccidenteFacturacion getDivorciosAccidente(string ID) { pBaseDivorcioAccidenteFacturacion pBase = new pBaseDivorcioAccidenteFacturacion(); using(SqlConnection con = DBcomun.getConnection()) { SqlCommand comand = new SqlCommand(string.Format("SELECT * FROM divorcios WHERE ID = '{0}'", ID), con); SqlDataReader re = comand.ExecuteReader(); while (re.Read()) { pBase.ID = re["ID"].ToString(); pBase.DemandanteID = re["DemandanteID"].ToString(); pBase.DemandadoID = re["DemandadoID"].ToString(); pBase.serviceID = re["serviceID"].ToString(); pBase.Pagos = Convert.ToDouble(re["Pagos"]).ToString("f2"); pBase.Honorarios = Convert.ToDouble(re["Honorarios"]).ToString("f2"); pBase.Abono = Convert.ToDouble(re["Abono"]).ToString("f2"); } con.Close(); } return pBase; }