//Grabar Kardex Material public static string GrabarKardexMaterial(KardexMaterial objParam, int accion) { string conn = System.Configuration.ConfigurationManager.ConnectionStrings["database"].ToString(); SqlConnection cnnDS = new SqlConnection(); SqlTransaction txOle = null; string Resultado = string.Empty; try { cnnDS.ConnectionString = conn; cnnDS.Open(); txOle = cnnDS.BeginTransaction(); if (accion == 1) { Resultado = AtencionPeluqueriaDAO.InsertarMovHardexMaterial(objParam, txOle); } else if (accion == 2) { AtencionPeluqueriaDAO.AnularKardexMaterial(objParam, txOle); } txOle.Commit(); cnnDS.Close(); return(Resultado); } catch (Exception ex) { txOle.Rollback(); cnnDS.Close(); throw; return(string.Empty); } finally { cnnDS = null; txOle = null; } }