//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;
}
}