public long Get_Department(String ProductCode, String Type) { try { SqlParameter[] paramList = new SqlParameter[] { new SqlParameter("@ProductCode", ProductCode), new SqlParameter("@Type", Type) }; return(Execute.RunSP_Long(Connection, "SPGET_ProductManufacturing_ByID", paramList)); } catch (Exception ex) { throw new Exception(ex.Message, ex); } }